Senior Data Engineer - dbt & AWS Redshift

Project overview

We are looking for a Senior Data Engineer to further develop a modern financial data platform. The focus is on building and professionalizing data models and transformation pipelines in a cloud-based analytics environment. We are looking for an experienced freelancer who provides conceptual and hands-on support in architecture, implementation, and quality assurance.

Requirements

Apply now for this project: https://consultingheads.com/projekte/bewerben?projekt=*

• Several years of experience as a Data Engineer in building complex dbt-core projects
• Very good SQL skills in analytical database environments and relational data modeling
• Practical experience with AWS Redshift in production analytics or data warehouse setups
• Experience in developing dbt models, macros, tests, and technical documentation
• German language skills at least at B2 level
• Certification in dbt Analytics Engineering or comparable proof of qualification
• Experience with Airflow or Dagster for orchestrating data pipelines
• Knowledge of modern development principles such as CI/CD, automated testing, reviews, and Git-based collaboration
• Experience in agile project environments, e.g., Scrum or SAFe (with proof of certification)

Project details

12/2026

13 months

Remote/On-site: Hybrid

Utilization: 100%

Berlin

YOUR CHALLENGE:

YOUR TALENTS:

• Advising on the initial setup of a company-wide dbt standard, including cross-team conventions, repository structure, and development guidelines
• Conception and implementation of performant data pipelines and transformations with dbt-core based on business requirements
• Development and maintenance of dbt models, macros, tests, and technical documentation for a sustainable and maintainable analytics platform
• Optimization of relational data models and SQL-based transformations for analytical workloads on a cloud data warehouse, especially AWS Redshift
• Definition and implementation of best practices for materializations, modularization, reusability, and the use of suitable dbt packages
• Conducting code reviews and ensuring development quality through testing, versioning, and traceable documentation
• Support in the conception of production-ready development and operating models in close coordination with internal stakeholders and development teams
• Participation in agile delivery formats such as Planning, Daily, Review, and Retrospective for the structured implementation of the development roadmap
• Start: 2026-12
• Duration: 13 Monate
• Remote: hybrid
• Location: Berlin, Deutschland, DE
• Languages: German

Source notes

consultingheads. When results matter. We connect you with the most impactful freelance consultants, IT & subject matter experts, and interim managers - personally selected, quickly available, and reliable in the project.

What We Do

Where pure algorithms reach their limits, our strength begins: personal consulting. We analyze your challenge together and find exactly the personality that fits you professionally and personally.

Our Network

With over 23,000 experts, one of the largest and most carefully selected in the DACH region, full of quality-assured consultants, specialists, and managers ready to lead your projects to success.

Our Approach

We combine the excellence of consulting with the flexibility and speed that modern companies need. Hand-picked, results-oriented, and always in partnership. Since 2016, leading companies, consultancies, and private equity firms have trusted us - in over 3,000 successful projects.