Senior Data Warehouse Engineer

We are seeking a Senior Data Warehouse Engineer to join the Codeex team!

If you’re ready to grow your career and assist businesses with their digitalization, you’ve come to the right place.

With the many challenging international projects, Codeex is a great place for tech experts to get a boost of professional growth. At Codeex we offer end-to-end IT solutions across multiple countries and industries. We respond to the constantly changing standards, skills and requirements of the IT industry.

At Codeex we constantly make sure that our employees are growing professionally, that they always have someone to learn from and that someone is learning from them.

Job Responsibilities

Proficiency in Data Modeling and experience in building scalable data architectures
Design, enhance, and operate our central Data Warehouse
Translate business requirements into robust data models and DWH concepts
Develop and optimize ETL/ELT processes, including incremental loading
Implement historization and change‑tracking logic (e.g., Slowly Changing Dimensions)
Ensure data quality, consistency, and correctness across the full data flow
Build validation, control, and reconciliation mechanisms
Optimize query, load, and data structure performance
Document data models, load processes, and architectural decisions.

Job Requirements

Solid experience in building and operating Data Warehouse solutions
Excellent command of T‑SQL and Microsoft SQL Server, especially for T‑SQL‑based DWH/ETL frameworks
Strong knowledge of information modeling 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 concepts
Experience in query and data structure optimization (indexes, partitioning)
Understanding of data quality, validation, and control mechanisms
Basic knowledge of data security, data protection, and handling of personal data
Proficiency in Git, PowerShell, and/or Python for automation, as well as C# and Power BI / SSRS, is a plus.