Back to Search
We are seeking a skilled Senior Data Integration Engineer to join our dynamic team.
The successful candidate will work within a multidisciplinary team, leveraging agile methodologies to develop data models and efficiently integrate diverse data repositories. This role requires a deep understanding of data modeling principles, particularly Kimball Dimensional Modeling, and proficiency in SQL and data warehouse techniques.
Responsibilities
- Design data models adhering to industry best practices with an emphasis on Kimball Dimensional Modeling
- Collaborate with data consumers to define requirements, objectives, and interface specifications
- Create robust SQL code to establish data structures based on models and transform data during staging
- Develop unit tests to confirm code accuracy
- Evaluate data sources, assess quality, and identify optimal integration methods
- Produce Source to Target Mappings from data models for data integration (ETL) specifications
- Formulate strategies to integrate data from various sources and data warehouses
- Establish data models and standards that simplify the integration of large and diverse data repositories
- Engage in requirement checks and design sessions with stakeholders
- Assist in the development and deployment of data integration solutions
Requirements
- 3-5 years of experience in data modeling with expertise in dimensional data modeling
- Experience with Python
- Proficiency in SQL, stored procedure writing, ETL, and SCD
- Proven track record working on Data Warehouse projects
- Hands-on experience with Amazon Cloud Architecture including AWS S3, DataBricks, AWS Redshift
- Familiarity with SAP Power Designer, Erwin, or similar tools
- Exposure to DBT (Data Build Tool) development
- Strong attention to detail
- Competency in data warehouse concepts, practices, and coding
- Understanding of Airflow
- Excellent teamwork capabilities
- Experience with databases such as Redshift, Teradata, or Oracle
- Understanding of software engineering and testing practices within an Agile environment
- Proficiency in English, with excellent communication skills including the ability to persuade and negotiate
Looking for something else?
Find a vacancy that works for you. Send us your CV to receive a personalized offer.
Find me a job