Senior Analytics Engineer: Data Warehouse & dbt Lead

Bonapolia; United States; Remoto; USD 90.000 - 130.000; Tempo pieno

Descrizione del lavoro

Bonapolia is seeking a Senior Analytics Engineer to join our globally distributed team. The role focuses on migrating data pipelines to a core data warehouse platform and building scalable data marts using BigQuery, dbt, and Airflow.

You will translate stakeholder needs into robust data models and ensure data quality across sources. The ideal candidate has 3+ years in analytics/DWH, expert SQL skills, and solid Python experience for ETL.

Competenze

• 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, deduplication.

Mansioni

• 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.

Conoscenze

SQL

Python

Data modeling

Strumenti

BigQuery

dbt

Airflow

Descrizione del lavoro

Bonapolia is seeking a Senior Analytics Engineer to join our globally distributed team. The role focuses on migrating data pipelines to a core data warehouse platform and building scalable data marts using BigQuery, dbt, and Airflow.

You will translate stakeholder needs into robust data models and ensure data quality across sources. The ideal candidate has 3+ years in analytics/DWH, expert SQL skills, and solid Python experience for ETL.