Extelligence is an intelligent partner that goes the extra mile. We provide customized information management solutions for major industries. Our team in Prague and Bucharest is working with international companies, transforming, and adding value to their business on a daily basis. We are growing quickly, and we are interested to bring more talented individuals into our team.
As a Data Modeling & ETL expert, you will be part of a project delivery team preparing IT and OT
oriented data products for manufacturing in the area of human health (Digital MMD).
Responsibilities:
- Analysis of business requirements
- Analysis of data sources, detailed design & description of required data transformations
- ETL design and mapping of data from data source systems through all DWH layers
- Integration of new data sources into existing datasets
- Preparation of documentation, pertaining to SDLC standards
- Optimization/industrialization of existing database and data transformation solutions
- Communication with source system data owners and visualization developers
Required skills:
- Has deep understanding of data modeling and preparation of optimal data structures
- Has knowledge of ETL methods
- Has advanced knowledge of SQL and data transformation practices
- Has experience with SQL query optimization
- Has experience with Amazon Redshift
- Has experience with WhereScape RED tools for data modeling
- Has experience with DBT (Data Build Tool)
- Has experience with data profiling
- Understanding ER diagrams (entity-relationship) as a part of business analyses artefact
- Familiarity with cloud architecture and services, particularly AWS
- Knowledge of data warehousing concepts and best practices
- Proficiency in Python or another programming language used in data processing
- Experience with data governance and data quality frameworks
- Understanding of data security and privacy regulations
Soft Skills and Languages:
- Can fluently communicate in English
- Effective communicator
Education:
- Bachelor’s Degree in Information Technology, Computer Science, or equivalent experience
Working with Extelligence:
- We take care of the important things that matter to contractors, for example, we guarantee on-time payment for your work. You will never have to chase us for payment.
- We always seek to have long term relationships with our team and we always seek to offer opportunities to extend cooperation beyond the first contract or project.
- Extelligence is a multicultural team, we have more than 15 different nationalities working with us.
- We also organize events to bring our team together including team building activities and social events.