Senior Data Engineer - Data Vault 2.0, MSSQL, BIML - predominantly remote

Project overview

Senior Data Engineer - Data Vault 2.0, MSSQL, BIML - predominantly remote

On-site & remote | Remote and Hannover

|

02.11.2026 | 31.12.2026 + Extension Option

For our project IT_2385, we are looking for the following specialist:

Important Information:

Submission Deadline: 10/20/2026 eob

Utilization: Full-time / 40 PT

The goal is to accelerate the further development of our Data Warehouse in the months until the end of the year: expansion of the Data Vault 2.0 model, maintenance and expansion of the BIML-based generator for the ETL/SSIS pipelines, and securing documentation and knowledge transfer to the internal team.

Starting Situation:

The Data Warehouse runs on Microsoft SQL Server and is modeled according to Data Vault 2.0. Loading pipelines and parts of the data model are generated via a BIML-based generator.

Database: Microsoft SQL Server

Modeling: Data Vault 2.0

Generation: BIML (BimlStudio) for generating SSIS packages or loading logic

ETL: SSIS and T-SQL

Working Method: Scrum Team in SAFe context

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 (Hashkeys, Hashdiffs, Load Date Handling, Multi-Active Satellites, Effectivity).

ETL/ELT Development: Implementation and optimization of loading pipelines 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 model, generator, and loading processes, as well as handover to the internal team (pairing, workshops).

Requirements

Data Vault 2.0: Min. 5 years of practical modeling and implementation experience in at least 2 DWH projects; DV 2.0 certification desirable

MS SQL Server: Profound T-SQL knowledge, performance tuning, indexing, partitioning

SSIS: Experience in design and operation of SSIS packages

Working Method: Independent work, experience in agile teams, very good German or English skills (min. C2 in one language)

Seniority: At least Consultant level, preferably Manager level

Industry Experience: Experience in insurance, banking, or regulated environments

CI/CD: Git, automated deployment and testing in the DWH environment

Documentation: Experience with metadata repositories and automated documentation

Project details

Predominantly remote / presence in Hannover only by arrangement

Project Language: German

Fee: max. €80/hr remote and €90/hr on-site

Special Features: German residency required

• Start: 2026-11
• Location: DE
• Languages: German