Operations Insight Analyst

We’re Ocado Retail. We’re the people powering Ocado.com, the UK’s fastest-growing grocer, and* Ocado Zoom*, our almost-as-fast-growing, same-day grocery service. As the world’s biggest and best online-only grocer, we work tirelessly to bring more of what matters to our customers: unbeatable range, fair value, and effortless convenience.
We’re an exceptional and mighty bunch of colleagues who are inspired by our three awesome values: Always be curious, Bring your best self, and Challenge what's possible. We’re growing fast, and we’re looking for like-minded people to join us for the next step of this.
About the TeamOperations Insight Analysts are responsible for supporting the Operations team with reporting, analysis and insight to help them better understand current state and drivers of change.
The Operations team has three primary purposes:

• Working with Ocado Group to deliver KPIs across Supply Chain, CFCs and Service Delivery
• Drive operational change to benefit either the customer and/or deliver financial savings
• Acts as a stakeholder for Ocado Group on their key project

Example projects

• Understanding the drivers of delivery-slot booking conversion
• Recommendations for the optimum SKU discount levels on flash sale to minimise margin loss from purge
• Reducing our lost sales by understanding the drivers of customers late-canceling their order and “customer not in”
• Modelling the cost savings of suppliers delivering to a consolidator and recommending which ones to trial.

Roles & Responsibilities

• Form a strong working partnership with the wider Operations team and key stakeholders in Group (who often have access to required datasets).
• Strong stakeholder management and communication on workload progress, targets and obstacles is key
• Develop area expertise, understanding drivers of operational performance, and help shape the team’s weekly actions and long-term priorities to have the greatest impact
• Write SQL queries to manipulate and extract data from our Google BigQuery and Oracle databases
• Analyse data to draw out the commercial implications, and present recommendations to stakeholders in an engaging way to guide key decision-making.
• Develop and maintain a suite of reports to enable the self-serving of data among stakeholders.
• Act as a subject matter expert with other Insight teams when projects overlap with other business areas.

Knowledge, Skills & Experience

• Essential:
• Strong experience as an analyst
• Experience in presenting analytics-driven output to wide-ranging audiences
• Ability to drive projects forward and deliver to plan
• The ability to communicate and influence at all levels
• Excellent Excel skills
• Numerate or Technical Degree (2:1 and above)
• Mathematics A Level (or equivalent) Grade A or above

• Preferred:
• Proven experience of data mining using SQL (Oracle and BigQuery)
• Experience in a retail, e-commerce or FMCG consumer-facing business
• Experience with data visualisation software such as Tableau
• Familiarity with Google’s wider data ecosystem (e.g. Google Cloud Storage, AutoML)
• Knowledge of VBA
• Experience of R or Python

Business Competencies

• Problem Solving
• Communication Skills
• Influencing
• Project Management/Planning
• Relationship Management
• Commercial Awareness

What We Offer You
At Ocado, we value our employees and want to ensure you are rewarded for your contribution through competitive salaries and fantastic benefits.

• Hybrid working
• Free onsite parking and free shuttle service from Hatfield station
• Regular socials
• 26 Days of Annual Leave plus bank holidays
• 15% Ocado discount and 20% Marks and Spencer discount
• Private Medical Insurance
• Income Protection & Life Assurance
• Enhanced Pension Scheme (with 7% matching)
• Exciting company benefits through Reward Gateway

A little bit more about us
Our business is a joint venture between Ocado Group and M&S. It’s a successful combination of award-winning customer service and unrivalled customer data; world-leading technology and logistics from Ocado Group, and unrivalled product development from M&S.
Equal Opportunity Employer
Ocado Retail Ltd is an equal opportunities employer and as such makes every effort to ensure that all potential employers are treated fairly and equally, regardless of their sex, sexual orientation, marital status
Recruitment Privacy Notice
Ocado Retail Limited will process and store your personal information in accordance with our Recruitment Privacy Notice. By submitting your CV/resume and application information, you confirm that you have read and understood this privacy notice.

Job Type: Full-time