Senior Analytics Engineer with dbt, Data Team

About the Position

We are looking for a Senior Analytics Engineer to work hands on across metrics governance, pipeline development, and legacy model consolidation. You will contribute to reliable analytics workflows and help improve consistency, quality, and visibility across business data.

About the Project

You will work on a data initiative within an established analytics environment that uses dbt, Lightdash, Airflow, S3, and Redshift. The work includes governed business metrics, dashboard quality monitoring, API based ingestion, and the rationalisation of legacy analytics assets.

About the Team

You will be part of a data team, working closely with BI and data engineering leads as well as business owners across the company. Collaboration is cross functional and focused on clear communication, shared metric definitions, and reliable data delivery.

Responsibilities

• Build governed dbt models for critical business metrics
• Develop Lightdash dashboards and metric trees to monitor metric quality freshness and drift
• Create automated alerts for metric owners
• Document metric definitions calculations ownership and sources
• Align metric definitions across business teams
• Build and maintain Airflow pipelines that ingest data from external APIs into Redshift
• Improve the Zendesk pipeline
• Reconcile ticket volume and CSAT figures with the source system
• Migrate or retire legacy dbt models and Lightdash content
• Use usage data and clear communication with users during legacy content consolidation

Requirements

• Strong experience in analytics engineering or data engineering
• Strong experience with dbt
• Advanced SQL skills
• Experience with Amazon Redshift
• Experience with Lightdash or a similar dbt native BI tool
• Experience with Python
• Experience with Airflow for API based data ingestion
• Experience with data quality monitoring including freshness checks anomaly detection and alerting
• Experience with metric and semantic layer design
• Experience with data reconciliation against source systems
• Solid understanding of PII handling and data minimisation
• Confidence working with non technical stakeholders
• Fluent English

Technologies

dbt, Lightdash, Airflow, Amazon S3, Amazon Redshift, SQL, Python, Zendesk