Analytics Engineer

EMBS Engineering; Nottingham; Hybrid; GBP 65,000 - 90,000; Full time

Benefits offered by this job

Remote UK with monthly onsite

Competitive salary

Modern data platform

Job summary

EMBS Engineering is seeking an Analytics Engineer to own data modelling and the metrics layer within a modern data platform. You will transform data in Databricks into gold-layer models and build a semantic layer to empower analysts, BI tools, and AI initiatives.

You'll define and test shared metrics, collaborate with commercial stakeholders to finalise definitions, and apply CI/CD and automated tests to ensure data quality and provenance.

Qualifications

• Expert SQL and dimensional modelling experience.
• Hands-on Databricks experience with Delta tables and Unity Catalog.
• Experience with dbt or Lakeflow for production modelling.
• Git, code review, automated testing, and well-maintained documentation.
• Ability to agree metric definitions with commercial stakeholders and explain complex models clearly.

Responsibilities

• Transform bronze and silver data into gold-layer models.
• Design core quote, policy and claims models with consistent metrics.
• Define, document and test shared metrics for cross-team consistency.
• Build and maintain a semantic layer with metric views and clear data descriptions.
• Investigate incorrect AI-generated answers and improve underlying models.
• Provide governed datasets for Power BI reporting and pricing analysis.
• Design data grain and metric history to support forecasting and anomaly detection.
• Apply CI/CD, automated data tests and freshness checks to modelling.
• Set modelling standards and support analysts contributing to shared datasets.

Skills

SQL

Dimensional modelling

Databricks

dbt

Git

Code review

Automated testing

Documentation

Stakeholder alignment

Tools

Delta tables

Unity Catalog

Lakeflow

Genie

Power BI

Python

Databricks

Job description

Analytics Engineer - Databricks & Data Modelling

Databricks | SQL | Delta Lake | Unity Catalog | dbt / Lakeflow | Semantic Layer

Salary: £65,000 - £90,000

Location: UK Remote - 1 day per month onsite in the North West

We're recruiting an Analytics Engineer for an established UK digital business investing in a modern, trusted data platform. You'll take ownership of the modelling and metrics layer between raw data and the teams using it. The aim is to give analysts, reporting tools and AI one reliable, well-documented source of truth.

The role

• Transform bronze and silver data in Databricks into clean, tested and documented gold-layer models.


• Design core quote, policy and claims models, with consistent metrics for finance, pricing, marketing and operations.


• Define, document and test shared metrics so teams work from the same numbers.


• Build and maintain a semantic layer, including metric views, Genie spaces and clear data descriptions.


• Investigate incorrect AI-generated answers, improve the underlying models and definitions.


• Provide governed datasets for Power BI reporting and pricing analysis.


• Design data grain and metric history to support forecasting and anomaly detection.


• Apply Git, code review, CI/CD, automated data tests and freshness checks to modelling.


• Set modelling standards and support analysts contributing to shared datasets.

What we're looking for

• Expert SQL and strong dimensional modelling: facts, dimensions, grain and slowly changing dimensions.


• Hands-on Databricks, including Delta tables, workflows and Unity Catalog.


• Experience with dbt, Databricks Lakeflow or another production modelling framework.


• Git, code review, automated testing and well-maintained documentation.


• Ability to agree metric definitions with commercial stakeholders and explain complex models clearly.

Experience with Databricks metric views, Genie, Power BI modelling, Python, insurance data, pricing models or AI-ready datasets would be beneficial.

What's on offer

• Permanent role with a salary of £65,000 - £90,000.


• Opportunity to establish trusted metrics and modern data modelling standards.


• Work at the intersection of data engineering, BI, commercial analytics and AI.