Senior Analytics Engineer

Synapri; Sheffield; Remote; GBP 70,000 - 110,000; Full time

Job summary

Synapri is seeking an experienced Senior Analytics Engineer to own the curated data layer within a Databricks Lakehouse, translating complex business requirements into robust models and pipelines for reporting and decision-making.

The role focuses on analytics-ready data, KPI definitions, data quality, and collaboration with architects, BI developers and stakeholders to drive scalable data solutions.

Qualifications

• Significant experience as Analytics Engineer or similar data engineering role.
• Expert SQL and PySpark hands-on experience.
• Proficient with Databricks and Lakehouse architectures.
• Strong dimensional modelling knowledge: fact tables, dimension tables, star schemas.
• Experience creating analytics-ready datasets for BI and analytics.
• Ability to translate business requirements into robust data models and KPIs.
• Knowledge of data quality, governance, and performance optimisation.
• Experience providing technical leadership or mentoring.

Responsibilities

• Lead design and development of analytics-ready data models.
• Build and optimise SQL and PySpark pipelines in Databricks.
• Define KPI definitions, conformed dimensions and business logic across data domains.
• Ensure data quality, testing, observability and performance across the curated data layer.
• Lead modelling design reviews and contribute to architectural decisions.
• Collaborate with Data Architects, BI Developers, analysts and stakeholders to translate requirements into data solutions.
• Establish and promote engineering standards, data governance practices and reusable modelling patterns.
• Contribute to CI/CD pipelines and automated testing frameworks and continuous improvement across the data platform.

Skills

Analytics engineering

SQL

PySpark

Dimensional modelling

Data quality & governance

Leadership/mentoring

Tools

Databricks

Lakehouse architecture

CI/CD pipelines

Job description

Synapri are looking for an experienced Senior Analytics Engineer to play a key role in developing high-quality, analytics-ready data across its modern data platform.

This is an opportunity to take ownership of the curated data layer within a Databricks Lakehouse environment, translating complex business requirements into robust data models and transformation pipelines that support reporting, analytics, and business decision-making.

Key Responsibilities

• Lead the design and development of curated, analytics-ready dimensional and semantic data models.
• Build, maintain and optimise complex SQL and PySpark transformation pipelines within Databricks.
• Define and maintain KPI definitions, conformed dimensions and consistent business logic across data domains.
• Ensure data quality, integrity, testing, observability and performance across the curated data layer.
• Lead modelling design reviews and contribute to technical and architectural decisions.
• Work closely with Data Architects, BI Developers, analysts and business stakeholders to translate requirements into effective data solutions.
• Establish and promote engineering standards, data governance practices and reusable modelling patterns.
• Contribute to CI/CD pipelines, automated testing frameworks and continuous improvement across the data platform.

Essential Skills

• Significant experience working as an Analytics Engineer or in a closely related data engineering role.
• Expert-level SQL skills and strong hands-on experience with PySpark.
• Proven experience working with Databricks and Lakehouse architectures.
• Strong understanding of dimensional modelling, including fact tables, dimension tables, star schemas and semantic layers.
• Experience developing curated, analytics-ready datasets for business intelligence and analytics consumption.
• Ability to translate complex business requirements into well-structured data models and consistent KPI definitions.
• Strong understanding of data quality, performance optimisation and reliable data transformation practices.
• Experience providing technical leadership, reviewing designs or mentoring other engineers.

Remote (ad-hoc travel to client site)