Supply Chain Planning & Capacity Analyst

John Lewis Partnership; Milton Keynes; Hybrid; GBP 44,000 - 68,000; Full time

Job summary

A leading retail partnership in Milton Keynes is seeking a Capacity Analyst to create data insights informing operational decisions. The role requires strong analytical skills and experience in Supply Chain environments. You will work hybrid, with a salary between £44,800 and £67,200. The ideal candidate will have a solid understanding of complex data, modeling, and warehouse operations. Join a dynamic team committed to customer-centric decision-making, driving continuous improvement across the organization.

Qualifications

• Proven working experience in a Supply Chain or other complex environment.
• Ability to rapidly learn and self-develop.

Responsibilities

• Synthesize data and report from multiple sources.
• Hypothesis testing through modelling.
• Create insight for decision making.

Skills

Complex data

Data mining

Technical modelling (Matlab, R, SQL, Python, SAS, BQ)

Exceptional problem solving

Numerical skills

Commercial acumen

Understanding of warehouse operations

Job description

About the role

As a Capacity Analyst, you will create accurate and high quality planning and performance insight and modelling from multiple inputs and data streams to support choices about how best to utilise our network and to drive decision making across a range of activity and timescales, both within Supply Chain and in Trading and Shops. You will highlight risks and conflicts and work with a broad network of stakeholders to support the resolution or management of these. You will need to be able to interrogate and interpret complex and ambiguous data to create insight in an applied manner; you will script, code and model outputs and then present recommendations to a range of stakeholders. You will create key data and insight which will: inform future changes and development in our Supply Chain network; identify opportunities for continuous improvement and prioritise, recommend and drive change; forecast the perceived unknowns providing a view of what is to be expected in the future with accuracy; form the basis of all operational decisions made in the Supply Chain, and across the business where the operational impact and costs of change are being assessed and understood; input into longer term development initiatives and projects. You will work across the Supply Chain as well as with a range of stakeholders within the Partnership, and externally such as suppliers and third‑party logistics providers to ensure awareness of internal and external change and that analysis and recommendations are aligned to the overarching team and business strategy.

At a Glance: Location: Magna Park • Hours: 35 hours, Mon – Fri, Hybrid position with requirement of 2 days in the office • Contract Type: Permanent • Salary: £44,800 – £67,200

What you will do:

• Synthesis of data and reporting from multiple sources, both operational and financial
• Hypothesis testing through extensive modelling of new propositions, impact of changes in process, sales forecasts, volumes etc.
• Commerciality – applying operational knowledge of the Supply Chain operation to the data
• Create insight which clearly articulates a compelling story to aid and inform decision making across the Supply Chain, and to influence decision making across the organisation
• Analyse data in order to highlight risks and opportunities, as well as then make recommendations of potential mitigations and next steps
• Customer obsession: The data and insight you generate will form the foundation upon which the Supply Chain operation delivers products and services to our customers, and directly influence how effectively and efficiently it is able to do this.

Essential Skills Required:

• Complex data, data mining and technical modelling (Matlab, R, SQL, Python, SAS, BQ)
• Proven working experience in a Supply Chain or other complex environment, applying exceptional problem solving, numerical skills and commercial acumen to deliver quality insight and analysis
• Detailed understanding of warehouse operations and business E2E processesAbility to rapidly learn and self‑develop

Important Information – Application and Interview Process

• The application form consists of a CV upload followed by application questions. Internal applicants please check your Workday notifications and see further guidance on the PDW under internal application process.
• Once you've submitted an application the next steps of the process, if successful, will include a one-to-one interview.
• You'll be asked about any adjustments you might need to support the recruitment process. Let us know, and we'll be sure to discuss it with you.
• We occasionally close vacancies early in the event we receive a high volume of applications, therefore, we recommend you apply early.

#LI-SHOPTRADE

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.

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 occasionally close vacancies early in the event we receive a high volume of applications, and therefore, we recommend you apply early. If you require a reasonable adjustment due to a disability which means you may need longer to complete your application please contact us as soon as possible.

We want all of our Partners to have a good work‑life balance and we support flexible working. This might mean flexible or compressed hours, job sharing or shorter hour contracts, where possible. Please discuss this further with the hiring manager during your interview.