Required skills
Languages: German
Job description
Data Warehouse Developer needed to accelerate the development of a Data Vault 2.0 model, maintain and extend a BIML-based generator for ETL/SSIS pipelines, and ensure documentation and knowledge transfer to the internal team.
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
Sound T-SQL knowledge, performance tuning, indexing,
partitioning
SSIS
Experience in design and operation of SSIS packages Must
Working style
Independent work, experience in agile teams, very good German
or English skills (min. C2 in one language)
Financial industry
Experience in insurance, banking, or regulated environment Can
CI/CD
Git, automated deployment and testing in the DWH environment Can
Documentation
Experience with metadata repositories and automated documentation Can
I look forward to your application including CV and hourly rate.
Best regards
Martina Di Luca
Project details
asap
End: 31.12.2026
Full-time
Hannover, largely remote possible; presence by arrangement (e.g., kickoff, workshop)
Extension: An assignment in 2027 is envisaged.
Task:
The goal is to accelerate the further development of the Data Warehouse in the months until the end of the year: expansion of the Data Vault 2.0 model, maintenance and extension of the BIML-based generator for ETL/SSIS pipelines, as well as ensuring documentation and knowledge transfer to the internal team.
The developers work closely with the internal team and take on the following tasks:
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 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 the model, generator, and load processes, as well as handover to the internal team (pairing, workshops).
- 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