Role Overview
As an Analytics Engineer, 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.
What You Will Do
You will design reporting layers in dbt, implement standardized definitions in the semantic layer, and enable self-service analytics.
Why It Might Be a Fit
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.
Requirements
- 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.
Benefits
- 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).
To apply for this job please visit careers.ocadogroup.com.


Follow us on social media