Data Engineer – dbt Expert, SQL & AWS Redshift

Project overview

Project Framework

Project details

Berlin

Generally location-independent and remote (Nearshore: Germany & EEA)

01.12.2026–31.12.2027; approx. 13.00 months

Scope: 202 PT of which 192 remote, 10 onsite = 95.05% remote (2026: 22 PT remote; 2027: 180 PT of which 10 onsite)

Utilization: Full-time / Flexible

Onshore / Nearshore: Germany & European Economic Area

Language / Required Language Level: German – Independent language use (B2)

Conditions – Mandatory Information for Candidates

For further processing of your application, this information is essential:

Please state your desired billing method and your hourly or daily rate, separated for remote and onsite. Also indicate whether travel expenses are included or billed separately.

If billed separately, please state the amount or the basis for calculation.

1.1 Project/Process Context

1.2 Project Structure Project work in the data and finance environment according to agile collaboration models (e.g., SAFe, Scrum).

3.1 Scope

4.1 Must-Have Requirements – 100% Mandatory

M1: dbt Analytics Engineering Certification or dbt Fundamental; proof by certificates

M2: Experience in building and implementing complex dbt projects with dbt-core; proof by 2 references.

M3: SQL expertise for analytical databases, ideally on AWS Redshift; proof by years of experience: Senior (> 5 years of experience).

4.2 Should-Have Requirements

S1 (35%): Experience using AWS Redshift; 1 reference

S2 (35%): Experience using the open-source orchestrator Airflow or Dagster; 1 reference

S3 (30%): Know-how in agile project management (e.g., IAPM/CAPM, PMI-ACP, Scaled Agile Framework); proof by certificates.

• Conditions / Billing Method (Hourly or Daily Rate)
• Hourly Rate Remote (EUR/hour) and Hourly Rate Onsite (EUR/hour)
• Or Daily Rate Remote (EUR/day) and Daily Rate Onsite (EUR/day)
• Travel Expenses (if applicable)
• In the finance sector of the DB Group, a new data platform called F.HUB is being created for central provision of financial and structured data/data products for analytics purposes. The project is dependent on the SAP HANA transformation project Argo. AWS Redshift serves as the cloud data warehouse. The Python/SQL framework dbt-core is primarily used for data transformation, quality assurance, and documentation.
• Dagster or Airflow are used for orchestration. The contractor supports the business-aligned IT in the conception and realization of a production-ready setup, including an operating model, and in building sustainably maintainable data pipelines using modern development principles (CI/CD, versioning, reviews, automated testing).
• Project communication in German
• Consulting on the basic setup for dbt usage (development of cross-team conventions).
• Implementation of data pipelines and transformations with the Python open-source library dbt-core (conventions, repository organization, materializations, dbt packages, and development of custom macros including documentation).
• Development of dbt models and macros, including documentation and tests, according to the client's requirements.
• Conducting code reviews and advising on the optimization of dbt transformations for use on AWS Redshift.
• Participation in coordinating meetings of the development team (Planning, Dailies/Scrums, Retros).
• Start: 2026-12
• Duration: 13 Monate
• Remote: hybrid
• Location: Berlin, Deutschland, DE
• Languages: German