Senior Analytics Engineer with dbt, Data Team

Technology stack

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

Project overview

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.

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.

Position overview

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.

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

What We Offer:

• Vacation days: Up to 26 business days per year.
• 10 illness/special days off per year (fully paid, no medical papers needed) for all contract types
• Health and life insurance (Luxmed)
• MyBenefit platform with Multisport option
• Internal psychological support service
• English language classes from the first working day
• Access to external learning platforms: O’

Reilly, LinkedIn Learning, Udemy, and a wide catalog of diverse internal training

• Flexible workplace: work from the office, from home, or choose a hybrid option
• Tech Skills Mentoring Program
• Opportunities to develop as a public speaker, mentor, or technical interviewer
• Certification reimbursement (AWS, GCP, Microsoft, etc.)