Senior Analytics engineer

Synapri; Greater London; On-site; GBP 85,000 - 110,000; Full time

Job summary

Synapri is seeking a Senior Analytics Engineer to lead the design and delivery of curated, analytics-ready data within our Lakehouse environment in the United Kingdom. You will translate complex business requirements into robust SQL and PySpark pipelines, own the data serving layer, and ensure data is well-modelled, governed, performant and ready for consumption across analytics and BI.

You will design dimensional and semantic data models, define KPIs and conformed dimensions, and drive best

Qualifications

• Strong experience as an Analytics Engineer in a modern data platform.
• Expert-level SQL and hands-on PySpark experience.
• Strong understanding of dimensional modelling and semantic layers.
• Proven experience with Databricks and Lakehouse architectures.

Responsibilities

• Design and deliver dimensional and semantic data models for analytics.
• Define and maintain KPIs, conformed dimensions and consistent data definitions.
• Develop and optimise SQL and PySpark pipelines using Databricks.
• Ensure high standards of data quality, testing, performance and observability.
• Lead modelling reviews and contribute to technical and architectural decisions.
• Contribute to CI/CD, automation, testing and data governance standards.

Skills

SQL

PySpark

Dimensional modelling

Analytics engineering

Stakeholder management

Tools

Databricks

Unity Catalog

dbt

Job description

Senior Analytics Engineer - Databricks - Pyspark - Dimensional Models - Unity Catalog - Kimball

We're looking for a Senior Analytics Engineer to lead the design and delivery of curated, analytics-ready data within our Lakehouse environment.

You'll translate complex business requirements into robust SQL and PySpark pipelines, own the data serving layer, and ensure data is well-modelled, governed, performant and ready for consumption across analytics and BI.

Key Responsibilities:

• Design and deliver dimensional and semantic data models for analytics.
• Define and maintain KPIs, conformed dimensions and consistent data definitions.
• Develop and optimise SQL and PySpark pipelines using Databricks.
• Ensure high standards of data quality, testing, performance and observability.
• Lead modelling reviews and contribute to technical and architectural decisions.
• Contribute to CI/CD, automation, testing and data governance standards.

About You

• Strong experience as an Analytics Engineer within a modern data platform environment.
• Expert-level SQL and strong hands-on PySpark experience.
• Strong understanding of dimensional modelling, semantic layers and analytics engineering.
• Proven experience with Databricks and Lakehouse architectures.
• Excellent stakeholder management and communication skills.
• Experience providing technical leadership or mentoring.
• Experience with Unity Catalog, dbt or similar transformation frameworks.