Required skills
Languages: German
Job description
We are looking for two experienced DWH Developers to support a Data Warehouse based on Microsoft SQL Server and modeled according to Data Vault 2.0. The role requires strong knowledge of T-SQL, ETL processes with SSIS, and experience with BIML development.
Project overview
We, emagine GmbH, are looking for two experienced DWH Developers (m/f/d) for our Business Unit Insurance to support the Data Warehouse, which is based on Microsoft SQL Server and modeled according to Data Vault 2.0. The role requires in-depth 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 loading 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 loading 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
- In-depth 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 working style 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
Scope: 40 PT
Hannover, predominantly remote (presence by arrangement)
- Start: ab sofort
- Duration: 2 Monate
- Remote: hybrid
- Location: Hannover, Deutschland, DE
- Languages: German
Indexed by 9am's meta-search. You are a job provider? Claim or manage this listing
Found on FreelancerMap DE