Forecasting Analyst

John Lewis plc; Bracknell; Hybrid; GBP 44,000 - 69,000; Full time

Benefits offered by this job

Night Premium (£5.25/hr)

Job summary

John Lewis Partnership is seeking a Forecasting Analyst to create demand forecasts at an item-location level using ML platforms. You’ll drive S&OP alignment across Commercial, Supply Chain and Distribution, guiding planning with insights and exception modeling.

Role includes night premium for hours between 22:00–06:00 and a hybrid working pattern with ~3 days in Bracknell Head Office. Closing date 2026-10-11; salary up to £50,000 plus potential premium and experience-based adjustments.

Qualifications

• Proven background in item-location demand forecasting within retail, FMCG, or complex supply chain.
• Hands-on proficiency with enterprise demand planning systems and data querying/visualisation tools.
• Strong ability to analyse large datasets, detect anomalies, cleanse data, and build scenario models.
• Experience supporting S&OP processes to align commercial demand with operations.
• Excellent collaborative skills with ability to translate technical insights for non-technical stakeholders.

Responsibilities

• Analyse complex data and optimise planning tools to maximise forecast accuracy.
• Act as forecasting voice in S&OP forums to align plans.
• Translate complex data into clear insights to influence stakeholders.
• Create robust forecasting models for changing trading conditions.
• Identify external data sources to refine demand forecasts.
• Automate workflow bottlenecks and reduce manual effort.
• Mentor partners on data literacy while ensuring GDPR compliance.

Skills

Item-location forecasting

S&OP collaboration

Data analysis

Data storytelling

Cross-functional influence

Tools

Luminate Demand Edge

Tableau

SQL

Snowflake

Job description

ABOUT THE ROLE

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. In addition to your contractual pay, any time worked between 22:00 - 06:00 will attract Night Premium at a rate of £5.25 per hour. This will also apply to existing Partners who have enrolled onto Enhanced Hours Premium arrangements.

Job Details

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. Pay: £44,000.00 - £69,100.00. Annual Contract Type: Permanent. Hours of Work: 35. Job Level: Partnership Level 7. Where You'll Be Working: Bracknell Campus, Doncastle Road, Bracknell, Berkshire, RG12 8YA. Closing Date: October 11, 2026.

Key Responsibilities

• 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.

Essential skills/experience you’ll need

• 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.

Desirable skills/experience you may have

• 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.

Important points to note

It's important to note that some of our roles are subject to pre-employment vetting (which may include DBS checks for successful candidates). If required, you'll be informed and provided with information about vetting during the recruitment process and we encourage you to complete any vetting documents quickly to avoid delays. Any DBS checks required will be carried out by a third-party registered body and financial probity checks may also be required for some of our roles. We also recommend that you apply as soon as possible as vacancies can close early if we see a high number of applicants.

ABOUT THE PARTNERSHIP

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 at retail. We continue to innovate, adapt and diversify. Never Knowingly Undersold on price, quality and service in John Lewis and passionately serving food-lovers in Waitrose. As Partners we all share the responsibility of ownership and in its rewards. We use our voices to contribute to our success, working together through the good and challenging times, holding true to our behaviours and treating everyone with kindness and respect. We all own making the Partnership somewhere we belong. Embracing our differences and creating an environment where we're free to be ourselves and can THRIVE. Growing ourselves individually, and as a collective. As Partners, we make all the difference. And, we all own it. It's this ownership model that makes the Partnership a very unique place to work.