Data Specialist - Data Analytics Engineer

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

More about the role

Our Data & Analytics team creates value for Morrisons by making sure we have the right data in the right place, transformed into clean, accessible structures ready for reporting, data product creation and enabling advanced decision-making. Utilising our Google Cloud data platform, the Analytics Engineer transforms raw data from across our operations from field to fork into optimised, reliable, and well-documented data models and data products. You will bridge the gap between technical data pipelines and business insight, enabling analysts and leaders to make faster, better-informed decisions.

Accountabilities

The role will have the following accountabilities:

Customer

• Build trusted relationships with data consumers and business analysts across internal functions.
• Translate business processes, operational requirements, 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.

Colleague

• 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.
• Facilitate clear communication between technical engineering teams and non-technical business stakeholders.

Cash & Profit

• Support a lean working culture by building optimised, reusable conformed data layers that minimise processing waste and lower GCP cloud compute costs.
• Reduce duplicate engineering efforts by consolidating redundant metrics into centralised analytical data models.

Operational

• Design, code, test, and deploy secure, maintainable data models and transformations using modern data tools (e.g., SQL, Dataform) in Google Cloud Platform.
• Build, maintain, and govern the centralised semantic layer (e.g. LookML, or cloud data catalog metrics) to deliver consistent, trusted business definitions across all reporting platforms.
• Map enterprise domain ontologies into relational data models, ensuring business concepts and their relationships accurately mirror real-world retail and supply chain processes.
• Implement and maintain metadata repositories, data dictionaries, and lineage tools within the enterprise data catalog.
• Define test conditions and execute automated data quality scripts to validate datasets before production release.
• Continually refine existing models to adapt to operational changes, platform upgrades, and new business priorities.

More about you

What we’re looking for:

Skills, Qualifications and Experience

As a Data & Analytics Specialist - Analytics Engineer you will have experience of:

• Data Modelling: Proven experience building and maintaining data models using recognised patterns (e.g., Kimball, Inmon, dimensional modelling).
• Semantic Layer Architecture: Hands-on experience building and managing centralised semantic layers, metrics tiers, or business abstraction layers in modern data tools.
• Business Ontology & Domain Mapping: Proven ability to analyse complex enterprise domain ontologies and translate entity relationships (e.g., supplier-to-product-to-store hierarchies) into structured dimensional schemas.
• Advanced SQL: Exceptional SQL capabilities for data profiling, transformation, aggregation, and performance tuning.
• Data Transformation & CI/CD: Practical experience using transformation tools (e.g. Dataform) and version control workflows (Git, Jenkins) to deploy maintainable code.
• Data Quality & Testing: Experience writing automated data validation scripts and test suites to verify accuracy and structural integrity.
• Metadata & Documentation: Ability to design and manage metadata, data dictionaries, and data cataloging assets.
• Stakeholder Translation: Excellent ability to communicate complex data structures to non-technical business users.
• Delivery Frameworks: Comfortable working within Agile and Waterfall project delivery methodologies.

Desirable:

• Cloud Infrastructure: Hands-on experience with Google Cloud Platform (BigQuery, GCP storage) or equivalent cloud providers (AWS/Azure).
• Programming Languages: Proficiency in Python, R, or general-purpose scripting languages.
• Analytics Tools: Exposure to visualisation software (e.g., Looker, Looker Studio) and proficiency in Look ML.
• Domain Experience: Experience in FMCG, retail, manufacturing, supply chain, or logistics environments.
• Modern Architectures: Exposure to Data Mesh concepts, domain-driven data ownership, or data catalog tools.

More about our perks

In return for all your hard work, you will receive:

• 15% discount in store from the day you join us
• Additional 10% discount card for a friend or family member
• Annual bonus scheme
• Career progression and development opportunities
• Generous holiday entitlement
• Market leading pension scheme and life assurance
• Healthcare benefits including Aviva Digital GP
• ‘MyPerks’ giving you discount with over 850 retailers
• Free parking onsite
• Enhanced Family, Maternity and Paternity Leave
• Private Healthcare

Alive with activity, our modern Head Office is home to our corporate teams that make sure everything runs smoothly. Here, you’ll find comfy breakout areas, a coffee shop, Morrisons Daily and a subsidised restaurant. We are within commuting distance of Leeds, Manchester and the Yorkshire Dales - and we even have free parking!

At our Head Office you will expect to find supplier showcases, charity fundraising and celebrations all year round for the events that mean the most to our colleagues.

There’s more to our business as it’s fast paced and ever changing, as such we’ve got lots of fresh opportunities for you to play your part in our success. We’d love to meet you!

At Morrisons, we’re proud to be building a team that reflects the diversity of the communities we serve. We want every colleague to feel respected, supported and able to be themselves at work. Different voices, experiences and ways of thinking help us grow and improve and that’s good for our customers too.We’re always looking for people from all walks of life to join us and bring their talents to our team. Together, we can build a workplace where everyone has the chance to thrive, make a difference and belong.