Senior Analytics Engineer - BigQuery & dbt Migration Lead

Bonapolia; Georgia; Remote; USD 120,000 - 180,000; Full time

Job summary

Bonapolia is seeking a Senior Analytics Engineer to lead the data delivery and attribution pipeline migration to a core data warehouse platform. You will own data models, run large incremental projects, and collaborate with stakeholders to translate needs into robust data solutions.

As part of a global mobility and urban services team, you will use SQL, Python, BigQuery, dbt and Airflow to build and optimize data marts, implement quality checks, and support testing, releases, and documentation

Qualifications

• 3+ years of Analytics Engineering, DWH Engineering, or Data Analysis experience.
• Expert SQL and Python knowledge for ETL and data processing.
• DWH architecture, ODS, data marts, incremental loads, history handling, and deduplication.
• BigQuery or similar columnar databases; data mart design and optimisation.
• dbt for large incremental projects and Airflow or similar orchestration tools.
• 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

SQL

Python

DWH Architecture

Data Marts

ETL/ELT

dbt

Airflow

Git

Data Governance

Data Quality

Data Parity Validation

Requirements gathering

Tools

BigQuery

Google Cloud Platform

Cloud Storage

Dataform

Lightdash

Looker

Tableau

Job description

Bonapolia is seeking a Senior Analytics Engineer to lead the data delivery and attribution pipeline migration to a core data warehouse platform. You will own data models, run large incremental projects, and collaborate with stakeholders to translate needs into robust data solutions.

As part of a global mobility and urban services team, you will use SQL, Python, BigQuery, dbt and Airflow to build and optimize data marts, implement quality checks, and support testing, releases, and documentation