Forecasting Analyst

As a Forecasting Analyst, you will create the demand forecasts that drive our entire supply chain. Using machine learning platforms, you will analyse data at an item-location level to ensure our stock ordering and replenishment plans are highly accurate. Your work will be a key part of our Sales & Operations Planning (S&OP), ensuring our commercial goals perfectly match our logistics and supplier capabilities.

Beyond the data, you will use your insights and exception modeling to guide planning decisions across our Commercial, Supply Chain, and Distribution teams. Whether you are managing everyday category performance or planning for major promotional events, you will continuously refine our forecasts to support successful trading and the wider Partnership's plans.

Expected salary - Salary up to £50,000, depending on experience

Contract type - This position is Permanent

Working pattern/flexible working - The Partnership has adopted a hybrid working approach, meaning you'll be able to work a mixture between the office and home based upon your personal needs whilst balancing the needs of the business. The team aims for around 3 days a week in the office to connect and on a more ad-hoc basis to attend key meetings.

Core days are currently Tuesday, Wednesday and Thursday

Please note, some on call weekend working is expected for this role, on a rota basis

Location - This role is based at our Bracknell Head Office

• Analyse complex data and optimise enterprise planning tools to maximise forecast accuracy and reduce manual overrides.
• Act as the primary forecasting voice in S&OP forums, ensuring Commercial, Supply Chain, and Distribution plans are fully aligned.
• Translate complex technical data into clear, actionable insights to build credibility and influence non-technical stakeholders.
• Create robust forecasting models for changing trading conditions and seasonal events, carefully balancing stock availability with wastage reduction.
• Identify internal and external data sources, such as weather and local events, to continually refine and improve demand forecasts.
• Automate workflow bottlenecks, conduct routine data cleansing and create best practice guides to eliminate manual effort.
• Mentor cross-functional partners on data literacy while ensuring full compliance with GDPR and GSCOP regulations.

• Proven background in item-location demand forecasting within retail, FMCG, or a complex supply chain environment.
• Hands‑on proficiency with enterprise demand planning systems (e.g., Luminate Demand Edge) and data querying/visualisation tools like Tableau, Snowflake, or SQL.
• Strong ability to analyse large datasets, detect anomalies, cleanse data, and build scenario models.
• Experience supporting Sales & Operations Planning (S&OP) processes to align commercial demand with operational execution.
• Excellent collaborative skills, with a track record of translating complex technical insights into clear language for non-technical stakeholders.

• Previous experience working within cross‑functional agile teams or "Pods" alongside Commercial and Supply Chain partners.
• Proven success in automating workflows, writing Standard Operating Procedures (SOPs), and reducing manual system overrides.

We’re the largest employee owned business in the UK and home of our cherished brands, John Lewis and Waitrose. We’re not just employees, we’re Partners, driven by our purpose to build a happier world. As we look to our future, there’s never been a more exciting time to join us.

We’re ruthlessly focused on being brilliant  continue to innovate, adapt and diversify. Never Knowingly Undersold on price, quality and service in…