Senior Analytics Engineer dbt, Data Team

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.

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.

• 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

• 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