Senior Analytics Engineer: DWH & Data Pipeline Lead

Bonapolia; New York (NY); Remote; USD 120,000 - 180,000; Full time

Benefits offered by this job

Monthly invoicing

Contract under your country's law

Firm paperwork handled (MSA/NDA/invoic

Job summary

Bonapolia is seeking a Senior Analytics Engineer to drive data delivery and attribution migration on a global mobility platform. You will lead dbt model migrations, build incremental BigQuery data marts, and implement data quality checks to ensure reliable data delivery.

The role requires 3+ years in analytics engineering or related fields, expert SQL, Python, and experience with data warehouses, orchestration tools like Airflow, and data governance.

Qualifications

• 3+ years of Analytics Engineering, DWH Engineering, or Data Analysis experience
• Expert SQL and good 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

BigQuery

dbt

Airflow

Data quality

Data governance

Stakeholder data needs

Tools

GCP

Cloud Storage

Dataform

Looker

Tableau

Lightdash

dbt

Airflow

Job description

Bonapolia is seeking a Senior Analytics Engineer to drive data delivery and attribution migration on a global mobility platform. You will lead dbt model migrations, build incremental BigQuery data marts, and implement data quality checks to ensure reliable data delivery.

The role requires 3+ years in analytics engineering or related fields, expert SQL, Python, and experience with data warehouses, orchestration tools like Airflow, and data governance.