Data Analyst, Operational Analysis

  • John Lewis
  • London, NW10
  • UK
  • 2 days remaining
To support the Customer Delivery Operation (CDO) network by the collection, collation and timely presentation of operational reports & KPIs to support a successful Green Van Fleet operation. Uses detailed data for trend analysis and to validate strategic operational decisions. Uses advanced analytical skills in MS Excel & Business Objects to maximise value of data obtained. Works closely with DM Dynamic Booking and Scheduling System (DBS) and the Central Scheduling Team to understand reporting requirements and, if necessary, to provide support to that Team. Strives for continuous improvement in the detailed and systematic analysis of planned customer delivery routes in comparison with those actually undertaken by customer delivery teams. To ensure the correct processes are in place for the Customer Delivery Hubs to comply with route analysis Investigations. To evaluate and measure success and ensure this feeds into future change.

Job Requirements

This is a permanent, full-time role based in Origin Park, West London. Rarely, there will be a requirement to travel to sites within the CDH network and to other Partnership locations, as required.

Key responsibilities will include:- 

To collect data from necessary sources. Designs and maintains informative and highly accurate spreadsheets to present data obtained from the analysis of plan versus actual routes using Ms Excel, BOXI, Tracking software and other available software as appropriate.

Ensures spreadsheets can be easily and swiftly manipulated and interpreted for a range of purposes. Works with Management Information Systems to understand full the range of data available within the business.

Analyse, design, map and implement processes to support continuous improvement in the workflow. Creates reports to highlight results. Identifies and communicates defined benefits or risks of inaction.

For full details of the role, please see the attached job description.

Required essential experience skills and qualifications


  • Maths GCSE
  • English Language GCSE


  • Has experience of working in a dynamic technical environment.
  • Possesses excellent Microsoft skills, Excel in particular.
  • Has proven experience of analysing data.

Required desirable experience skills and qualifications


  • Educated to degree level


  • Has experience of using delivery routing software.
  • Able to write reports using Business Objects software or similar.
  • Is a PC Super User.
  • Has an understanding of supply chain logistics and processes.

Sign up to receive our weekly job alert