Data Warehouse Architect & Developer

Project overview

Hello network,

For a major client in Hamburg, I am currently looking for a Data Warehouse Architect & Developer.

Project details

Architecture (approx. 25-30%)

Development (approx. 70-75%)

Must-have Skills

If interested, please send me your current CV with the earliest possible start date & hourly rate. I will contact you after review.

I look forward to your message.

Best regards,

Lea Reiners

Associate Principal Candidate Consultant

*@*.com

Outpace tomorrow, together

sthree.com

SThree GmbH, Querstraße 7, 60322 Frankfurt, Germany. Registergericht Frankfurt am Main: HRB 78875, Geschäftsführer: Niklas Werner, Christophe Zwaenepoel, Satinderjeet Sidhu. Ust.-ID: DE252066603

SThree_Germany is acting as an Employment Business in relation to this vacancy.

• Start: November 2026
• Duration: 6 months (with option for extension)
• Capacity: Full-time
• Work mode: 80% remote, 1 day per week on-site
• Client location: Hamburg
• Project language: German
• Conception and further development of the data warehouse architecture
• Modeling and setup of an enterprise DWH landscape
• Development of Data Vault models
• Implementation of Kimball modeling approaches
• Definition and implementation of Medallion architectures
• Design of relational data structures
• Evaluation and refactoring of existing data models
• Support with architectural decisions and best practices
• Hands-on development within the modern data platform
• Implementation of data pipelines and data models
• Development with dbt
• Work in Google BigQuery
• Refactoring of existing legacy components
• Technical implementation of the migration from the old platform to the new Lakehouse world
• Close collaboration with business departments and development teams
• Several years of experience in building and further developing data warehouse solutions
• Very good knowledge of Data Vault 2.0
• Experience with Kimball modeling
• Sound knowledge of Lakehouse architectures and Medallion Schema
• Very good knowledge of dbt
• Practical experience with Google BigQuery
• Good SQL knowledge
• Experience in migrating or modernizing existing DWH landscapes
• Ability to take on both architectural and development tasks
• Start: 2026-11
• Remote: hybrid
• Location: Hamburg, Deutschland, DE
• Languages: German