Data Warehouse Engineer

About the role

The Data Warehouse Engineer designs, builds and operates the company's central data warehouse, turning business requirements into robust data models and DWH concepts. The role covers ETL/ELT development, data quality controls and performance optimisation.

Key responsibilities

• Translate business requirements into data models and DWH concepts
• Develop and optimise ETL/ELT processes, including incremental loading
• Implement historization and change-tracking logic such as Slowly Changing Dimensions
• Ensure data quality, consistency and correctness across the full data flow
• Build validation, control and reconciliation mechanisms
• Optimise query, load and data structure performance
• Document data models, load processes and architectural decisions

Required profile

• Solid experience building and operating Data Warehouse solutions
• Strong knowledge of information modelling and DWH architecture (Kimball, star/snowflake schemas)
• Experience with multi-layer ETL/ELT pipelines (staging, core, data marts)
• Practical experience with incremental loads, delta logic, historization and versioning
• Experience in query and data structure optimisation (indexes, partitioning)
• Understanding of data quality, validation and control mechanisms
• Basic knowledge of data security, data protection and handling of personal data

Required skills

• T-SQL and Microsoft SQL Server, especially for T-SQL-based DWH/ETL frameworks
• Git, PowerShell and/or Python for automation; C#, Power BI and SSRS are a plus