Data Warehouse (DWH) Developer with Focus Data Vault 2.0 - REMOTE/Hannover

Project overview

We, emagine GmbH, are looking for two experienced DWH developers (m/f/d) to support the Data Warehouse, which is based on Microsoft SQL Server and modeled according to Data Vault 2.0. The role requires profound knowledge of T-SQL, ETL processes with SSIS, and experience in development with BIML. Independent work and experience in agile environments are advantageous.

Framework Conditions

Responsibilities

• Data Vault 2.0 Modeling: Functional and technical modeling of new hubs, links, and satellites including Business Vault and Information Marts according to DV 2.0 standard (hash keys, hash diffs, load date handling, multi-active satellites, effectivity).
• ETL/ELT Development: Implementation and optimization of load processes in SSIS and T-SQL, including error handling, restart capability, and performance tuning.
• Quality Assurance: Creation of tests (unit/integration tests, source-target comparison), code reviews, and adherence to development guidelines.
• Documentation and Knowledge Transfer: Documentation of models, generators, and load processes, as well as handover to the internal team (pairing, workshops)

Requirements

• At least 5 years of experience in Data Vault 2.0 in at least 2 DWH projects
• Profound knowledge of MS SQL Server, especially in T-SQL, performance tuning, indexing, and partitioning
• Experience in designing and operating SSIS packages
• Experience in creating BIML generators
• Independent way of working and experience in agile teams
• Very good German or English skills (at least C2 in one language)

Nice to have

• DV 2.0 certification
• Experience in insurance, banking, or regulated environments
• Knowledge of CI/CD (Git, automated deployment and testing in DWH)
• Experience with metadata repositories and automated documentation

Project details

02.11.2026

End: 31.12.2026 + Option for 2027

Scope: 40 PT

Hannover, predominantly remote (on-site by arrangement)

• Start: 2026-11
• Duration: 2 Monate
• Remote: hybrid
• Location: Hannover, Deutschland, DE
• Languages: German