Senior Analytics Engineer (dbt, Data Pipelines)

Quick Facts

Senior Analytics Engineer focused on dbt-based metrics governance, dashboard/metric quality monitoring, and API-driven ingestion into Amazon Redshift.

Description

Work hands-on in an established analytics environment using dbt, Lightdash, Airflow, Amazon S3, and Amazon Redshift. You will build governed business metrics, monitor metric quality freshness and drift, and reconcile dashboard figures with source systems. You will also develop pipelines and migrate or retire legacy dbt and Lightdash assets.

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 (freshness checks, anomaly detection, 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

Benefits

• Vacation days: up to 26 business days per year
• 10 illness/special days off per year (fully paid, no medical papers needed)
• 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, plus 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.)