Senior Analytics Engineer - DWH Migration & Data Marts Lead

Bonapolia; Madrid; On-site; EUR 65,000 - 90,000; Full time

Benefits offered by this job

B2B contract via Bonapolia

Monthly invoicing schedule

We handle client-side paperwork

Job summary

Bonapolia is seeking a Senior Analytics Engineer to migrate and enhance data delivery on a core data warehouse platform. You will specialize in SQL, Python, and data modeling to build robust data marts and ensure data quality across attribution flows.

You will lead dbt model migrations, manage Airflow DAGs, and collaborate with stakeholders to translate needs into scalable data solutions. This is a full-time role with EU-centric requirements.

Qualifications

• 3+ years in Analytics Eng, DWH Eng, or Data Analysis.
• Advanced SQL and Python for ETL and data processing.
• Experience with DWH, ODS, data marts, and incremental loads.
• BigQuery or similar columnar DBs and data mart design.
• Proficient with dbt and orchestration tools like Airflow.

Responsibilities

• Clarify requirements and implement attribution logic and data marts.
• Lead migration of dbt models, Airflow DAGs, and sources to the core DWH platform.
• Build and optimise incremental BigQuery data marts with 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 Eng

SQL

Python

DWH Architecture

Data Modeling

BigQuery

Data Quality

Data Governance

Requirements Gathering

ETL/ELT

Tools

dbt

Airflow

Git

Looker

Dataform

Job description

Bonapolia is seeking a Senior Analytics Engineer to migrate and enhance data delivery on a core data warehouse platform. You will specialize in SQL, Python, and data modeling to build robust data marts and ensure data quality across attribution flows.

You will lead dbt model migrations, manage Airflow DAGs, and collaborate with stakeholders to translate needs into scalable data solutions. This is a full-time role with EU-centric requirements.