DWH Consultant (44366)

Enjoy building data foundations that a whole enterprise relies on? A leading utility company in Germany is driving a major transformation of its central data platform and is adding a DWH Consultant to its agile data team. The role covers re-architecting Data Vault 2.0 models for next-generation Billing and CRM source systems and supporting the platform’s migration from Snowflake to Databricks using dbt and Airflow. Required are advanced SQL, hands-on production experience with Snowflake and dbt Core, a strong data warehousing background and English C1.

🚀 Project
- Architecting, developing and maintaining scalable data models and modern data pipelines in an agile team
- Re-modeling and re-building core data structures for upcoming migrations of the primary Billing and CRM source systems
- Supporting the strategic migration of the enterprise data estate from Snowflake to Databricks
- Close collaboration with business analysts, domain squads and stakeholders – translating business logic into technical solutions
- Building business-ready data products for Tax, Sales and Billing
- Auditing and fine-tuning existing workflows for performance, maintainability and lower cloud compute costs

🎯 Skills
- Advanced SQL for complex data transformations, DWH queries and data models
- Hands-on production experience with Snowflake and dbt Core (data models and orchestration patterns)
- Strong background in data warehousing architectures, principles and pipeline methodologies
- AI-assisted development with Claude Code and GitHub Copilot
- English C1

💡 Nice to have
- German B2+
- Data Vault 2.0
- Databricks
- Apache Airflow
- Python
- Azure DevOps

#LI-RJ1