Senior Analytics Engineer — DWH Migration & ETL Lead

Bonapolia; España; Remote; EUR 70,000 - 95,000; Full time

Job summary

Bonapolia is seeking a Senior Analytics Engineer to drive data delivery and attribution pipeline migration to a core data warehouse platform. You will design and optimize BigQuery data marts, migrate dbt models and Airflow DAGs, and build robust data quality checks while translating stakeholder needs into actionable data requirements.

The role involves working with an international client base, CET time zone, and a six-month engagement.

Qualifications

• 3+ years of Analytics Engineering, DWH Engineering, or Data Analysis experience.
• Expert SQL and strong Python knowledge for ETL and data processing.
• DWH architecture, ODS, data marts, incremental loads, history handling, and deduplication.
• BigQuery or similar columnar DB; data mart design and optimisation.
• dbt for large incremental projects and Airflow or similar orchestration.
• Pipeline migration, data parity validation, Git, Data Quality, and Data Governance.
• Ability to translate stakeholder needs into data requirements.

Responsibilities

• Clarify requirements and implement changes to attribution logic, sources, and data marts.
• Lead migration of dbt models, Airflow DAGs, and sources to the core DWH platform.
• Build and optimise incremental BigQuery data marts, including recalculations and backfills.
• Implement data quality checks and investigate discrepancies.
• Analyse external inputs and ensure reliable data delivery.
• Participate in testing, validation, releases, and technical documentation.

Skills

Analytics Engineering

DWH Engineering

Data Analysis

SQL

Python

Data Quality

Data Governance

Stakeholder Communication

Tools

BigQuery

dbt

Airflow

Git

Job description

Bonapolia is seeking a Senior Analytics Engineer to drive data delivery and attribution pipeline migration to a core data warehouse platform. You will design and optimize BigQuery data marts, migrate dbt models and Airflow DAGs, and build robust data quality checks while translating stakeholder needs into actionable data requirements.

The role involves working with an international client base, CET time zone, and a six-month engagement.