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 can provide conceptual and hands-on support in architecture, implementation, and quality assurance.

Responsibilities

Absolutely required

• Consultation 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
• 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 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 certificate)

Project details

• Start: 12/2026
• Duration: 13 Monate
• Remote: hybrid
• Location: Berlin, DE
• Languages: German