Quick overview
Job description
Analytics Engineer | Tech Ops | Hybrid Working | Hatfield
Introduction:
We are Ocado Group, and we're bringing world-class automation to online grocery. Our Ocado Smart Platform (OSP) combines cutting-edge robotics, AI, and IoT within our advanced CFCs (Customer Fulfilment Centres). We've mastered the single pick, transforming online delivery for our global partners. Join us and be part of a team pushing the boundaries of retail technology.
About the Role:
As an Analytics Engineer for Tech Ops and OMRS, you will bridge the gap between data producers and data consumers, transforming complex data from our robotics and automated systems into trusted, certified data foundations. Focusing on bot, grid, and maintenance telemetry, you will design reporting layers in dbt and implement standardized definitions in the semantic layer to ensure metrics remain consistent across all dashboards, analysts, and AI tools.
In this role, you will act as the key liaison between Data Engineering and business analysts, establishing robust data models and governing metric changes. You will play a pivotal role in enabling self-service analytics, triaging domain requests, and using modern AI-assisted engineering tools to build reliable, high-performing data pipelines that support our global operations.
Key Responsibilities:
- Build and maintain layered dbt models in BigQuery, balancing query performance with long-term maintainability.
- Implement and govern standardized business metrics within the dbt semantic layer (MetricFlow).
- Migrate existing metric logic into the semantic layer while resolving data duplication.
- Elevate analyst workflows into certified, production-ready reporting marts with full documentation and lineage.
- Implement automated data quality testing and monitoring, escalating issues to upstream data producers.
- Serve as the primary point of contact to triage and scope data requests across Tech Ops and OMRS.
- Translate operational processes into clear data requirements in collaboration with subject matter experts.
- Enable and coach analysts on dbt best practices, conducting merge request reviews.
- Maintain metadata to ensure compatibility with AI tools and automated analytics plugins.
- Utilize AI-assisted development tools (such as Claude Code) to accelerate data modelling and migration.
What We’re Looking For:
Essential
- Strong hands-on experience with SQL (BigQuery preferred) and dbt, including models, macros, testing, and documentation.
- Proven background in dimensional data modelling (Kimball or Inmon methodologies) and Git version control workflows.
- Solid understanding of BI platforms (such as Looker) to align reports with semantic layers.
- Ability to translate ambiguous business requirements into precise technical data structures.
- Clear communication skills with the ability to explain technical trade-offs to non-technical stakeholders.
- Degree in a numerate discipline or equivalent practical experience.
Nice to Haves
- Experience working with metric/semantic layers (MetricFlow, LookML) or data quality tools (e.g., Validio).
- Proficiency with Python, Google Cloud Platform (GCP), or data modelling tools such as SQLdbm.
- Familiarity with using AI development tools to write, optimize, or review analytics code.
- Prior exposure to telemetry, robotics, warehouse automation, or maintenance data.
Benefits
We believe in supporting our people with meaningful, flexible benefits that prioritise well-being and work-life balance. Here’s a snapshot of what you can expect:
- Time to recharge:
25 days annual leave (rising to 27 after 5 years), plus the option to buy more – and 30 days a year to work from anywhere in the world. - Health & wellbeing:
Private Medical Insurance from your first month, wellbeing support through specialist apps and EAP, plus Income Protection and Life Assurance. - Family-first policies:
22 weeks paid maternity/primary carer leave and 6 weeks paid paternity leave - Financial support:
Pension with employer matching up to 7%, share schemes (Sharesave & BAYE), and interest-free loans for train tickets. - Commuter perks:
Cycle to Work Scheme and free shuttle buses to/from Hatfield and Welwyn Garden City stations. - Exclusive discounts:
15% off at Ocado.com with free delivery (starting in your first month).
Be bold, be unique, be brilliant, be you. We are looking for individuality and we value diversity. We are an equal opportunities employer and we are committed to treating all applicants and employees fairly and equally. We are committed to making reasonable adjustments to provide a positive, barrier-free recruitment process and supportive work environment. If you have any support or access requirements, we encourage you to advise us at the time of application.
Haystack's AI agent can fill in and submit this application for you. How AI auto apply works
Will your CV get past this employer's screening? Check your CV against this job, free
Similar jobs
- SM

Salesforce Technical Lead - 6 month FTCRecently posted Auto Apply
SmartestEnergy · London · Remote · Posted 20 Nov 2026 🇬🇧
RecruitingStakeholder ManagementCRM+2TechnologySalary not listed - AL
Junior Support EngineerRecently posted Auto Apply
Allego · Newcastle · Remote · Posted 20 Nov 2026 🇬🇧
SQLAWSCustomer Success+2Technology£30k - £39k/yr - VM

Senior Analyst - (Data Science and Analytics)Recently posted Auto Apply
VML · London · Hybrid · Posted 20 Nov 2026 🇬🇧
SQLMicrosoft ExcelLooker+6TechnologySalary not listed - SE

PowerPlatform engineerRecently posted Auto Apply
Seccl · Bath · Hybrid · Posted 20 Nov 2026 🇬🇧
AWSMental HealthAzure+5Technology£55k - £75k/yr - ZO

Senior iOS EngineerRecently posted Auto Apply
Zopa · London · Hybrid · Posted 20 Nov 2026 🇬🇧
Talent AcquisitionSwiftSwiftUI+5TechnologySalary not listed - OA
Senior Software EngineerRecently posted Auto Apply
OAG Aviation Worldwide · Luton · Hybrid · Posted 20 Nov 2026 🇬🇧
SnowflakeC#Databricks+3TechnologySalary not listed - KP

Fullstack Engineer Auto Apply
Kpler · United Kingdom · Hybrid 🇬🇧
DockerFastAPIMicroservices+14TechnologySalary not listed - PA

Software Engineer (Go)Recently posted Auto Apply
Paddle · United Kingdom · Remote · Posted 20 Nov 2026 🇬🇧
AWSNotionTechnologySalary not listed - MI

IT Specialist, LondonRecently posted Auto Apply
Mistral.ai · London · Hybrid · Posted 20 Nov 2026 🇬🇧
OnboardingGoogle WorkspaceTCP/IP+3TechnologySalary not listed - EW

Cybersecurity Co-Founder / CPTO (100 % remote) (m/f/d)Recently posted Auto Apply
EWOR GmbH · Belfast · Hybrid · Posted 20 Nov 2026 🇬🇧
TechnologySalary not listed - EW

Cybersecurity Co-Founder / CPTO (100 % remote) (m/f/d)Recently posted Auto Apply
EWOR GmbH · Reading · Hybrid · Posted 20 Nov 2026 🇬🇧
TechnologySalary not listed - EV

Middle Java DeveloperRecently posted Auto Apply
EveryMatrix · London · Hybrid · Posted 20 Nov 2026 🇬🇧
DockerMicroservicesSQL+23TechnologySalary not listed
