Analytics Engineer: Data Modeling & Semantic Layer

Morrisons; Bradford; On-site; GBP 60,000 - 90,000; Full time

Benefits offered by this job

15% discount in store

Additional 10% discount card for a fri

Annual bonus scheme

Career progression and development

Generous holiday entitlement

Market leading pension scheme and life

Healthcare benefits including Aviva GP

MyPerks discounts with 850+ retailers

Free parking onsite

Enhanced Family, Maternity and Paterni

Private Healthcare

Job summary

Morrisons is seeking an Analytics Engineer to join our Data & Analytics team at our Head Office. You will shape data models and centralised semantic layers that power trusted reporting and data products across the business.

You’ll translate complex business requirements into scalable data structures, mentor colleagues on SQL and data testing, and collaborate with stakeholders to drive insight-driven decisions while optimising data pipelines on Google Cloud Platform.

Qualifications

• Proven experience building and maintaining data models using recognised patterns (Kimball, Inmon, dimensional modelling).
• Hands-on experience building centralised semantic layers, metrics tiers, or business abstraction layers in modern data tools.
• Proven ability to analyse complex enterprise domain ontologies and translate relationships into dimensional schemas.
• Exceptional SQL capabilities for data profiling, transformation, aggregation and performance tuning.
• Experience using transformation tools (Dataform) and version control workflows (Git, Jenkins).
• Experience writing automated data validation scripts and test suites.
• Ability to design and manage metadata, data dictionaries, and data cataloging assets.
• Excellent ability to communicate complex data structures to non-technical users.
• Comfortable working within Agile and Waterfall project delivery methodologies.

Responsibilities

• Build trusted relationships with data consumers and business analysts across internal functions.
• Translate business processes and user feedback into robust data architecture and optimised analytical datasets.
• Own data model delivery for the domain area, ensuring documentation and data definitions are accurate and accessible.
• Champion data literacy, modelling best practices, and standard transformation guidelines across the organisation.
• Mentor trainee data practitioners on SQL standards, data testing, version control, and business domain context.
• Design, code, test, and deploy secure, maintainable data models and transformations using modern data tools (SQL, Dataform) in Google Cloud Platform.
• Build, maintain, and govern the centralised semantic layer to deliver consistent, trusted business definitions across all reporting platforms.
• Map enterprise domain ontologies into relational data models, reflecting real-world retail and supply chain concepts.
• Define test conditions and execute automated data quality scripts to validate datasets before production release.

Skills

Data Modelling

Semantic Layer Architecture

Domain Mapping

Advanced SQL

Data Transformation

Data Quality & Testing

Metadata & Documentation

Stakeholder Translation

Delivery Frameworks

Tools

Dataform

Looker

LookML

Git

Jenkins

BigQuery

Job description

Morrisons is seeking an Analytics Engineer to join our Data & Analytics team at our Head Office. You will shape data models and centralised semantic layers that power trusted reporting and data products across the business.

You’ll translate complex business requirements into scalable data structures, mentor colleagues on SQL and data testing, and collaborate with stakeholders to drive insight-driven decisions while optimising data pipelines on Google Cloud Platform.