Analytics Engineer
- Level
- Mid
Not stated in the posting: salary, work type, visa.
Open. First seen 19 November 2026.
About the role
Analytics Engineer | Tech Ops | Hybrid Working | Hatfield
Ocado Group's standard text
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
Ocado Group's standard text
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.
#LI-HYBRID
#LI-JT1
What this role asks for
Particular to this role
Git · Looker
Rare in Ocado Group's other 40 open postings.
Standard for data engineering roles
Python · SQL · dbt
Common in data engineering postings at any company.
88% of this description is written for the role. The rest is Ocado Group's standard text, folded away below.
Compared with Ocado Group's other open jobs.
Salary context
25 other open postings titled Analytics Engineer state a salary: median USD 135,000 to USD 152,250 a year.
Similar jobs
- Analytics Engineer at Fifty-Five
Shares 7 skills: Looker, BigQuery, dbt… · same seniority · same country - Data & Analytics Engineer at Zoomo
Shares 6 skills: Looker, BigQuery, dbt… · same seniority - Senior BI Analytics Engineer at Carwow
Shares 5 skills: Looker, BigQuery, dbt… · same country - Data Engineer at Addepto
Shares 7 skills: Looker, BigQuery, dbt… · same seniority - Analytics Engineer, Finance at Scopely
Shares 7 skills: Looker, BigQuery, dbt… · same seniority - Cyber Security Analyst (Maternity cover) at Ocado Group
Also at this company
More jobs like this
Is this your posting? Email [email protected] to have it removed.