Ocado GroupOfficial careers listing

Posted 2d ago

Analytics Engineer

Pay

Not stated

Location

Hatfield, United Kingdom

On site

Skills this role screens for

PythonSQLGCPGitCloudTestingAnalyticsBusiness intelligenceCommunicationDocumentation

Opens on Ocado Group's site. Sign in first and we keep it in your pipeline.

Still studying?Paid data internships in the United Kingdom open now

About the role

Analytics Engineer | Tech Ops | Hybrid Working | Hatfield

Also

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.

The work

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.

The work

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.

Who they want

What We’re Looking For

Also

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 have

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.

What you get

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:

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.

Private Medical Insurance from your first month, wellbeing support through specialist apps and EAP, plus Income Protection and Life Assurance.

22 weeks paid maternity/primary carer leave and 6 weeks paid paternity leave

Pension with employer matching up to 7%, share schemes (Sharesave & BAYE), and interest-free loans for train tickets.

Cycle to Work Scheme and free shuttle buses to/from Hatfield and Welwyn Garden City stations.

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.

#LI-HYBRID

#LI-JT1

  • Time to recharge:
  • Health & wellbeing:
  • Family-first policies:
  • Financial support:
  • Commuter perks:
  • Exclusive discounts:

Ocado Group

Found on the web. You apply on the company's own site

From the Wire Desk

Where this listing comes from

From Ocado Group's own careers system (Greenhouse).

insiderOne never charges students to apply. Never pay anyone for an internship. Check an offer you received

Prove Python first

This role screens for Python. Sit a ten-minute live challenge, get a signed receipt, and the employer sees it verified on your application instead of claimed.

Prove it, then apply

Ask about this role

SCOUT, an AI agent, not a person, answers from this ad, and says so when the ad doesn't cover it. No account, and nothing you type here is kept.

More data roles

Every data role here

insiderOne University

Get certified for roles like this: Data Analytics Associate

Free, about 2 hours, ending in a project marked against a rubric and a certificate any employer can check. Put it on this application and every one after it.

Start the certificationWhat is in it