Operations Insight Analyst

Operations 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 projects

What you’ll do

Example projects

• Set slot availability in different regions of the country taking into account the additional service delivery costs and lost orders from customers who don’t purchase due to poor availability

• Set up a trial to assess the incrementally of offering customers same-day delivery and provide a recommendation to the CEO on what our same-day delivery service should look like

• Work with the commercial team to identify high-purge SKUs and develop a process to reduce purge without damaging availability

• Work with teams at ORL and OG to analyse customer refunds and provide recommendations on ways to improve the customer experience

• Work with the Network Development and Commercial Teams to identify areas of future capacity constraints and provide recommendations on potential options to resolve

• Collaborate with the Ocado Data Science and Commercial team to automate the selection of substitute products, trial this process and evaluate it before rolling it out.

Roles and 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 self-serving of data among stakeholders.

• Act as a subject matter expert with other Insight teams when projects overlap with other business areas.

• Experience deriving insight from data

• Experience in presenting analytics driven outputs 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:

• Experience in a retail, e-commerce or FMCG consumer-facing business

• Experience of data mining using SQL

• Experience with data visualisation software such as Tableau

• Familiarity with Google’s wider data ecosystem (e.g. Google Cloud Storage, AutoML)

• Experience of R or Python

• Car scheme

• Company pension

• Discounted gym membership

• Private medical insurance

• Shuttle service provided