Workforce Planning Analyst

Boots Opticians; Nottingham; On-site; GBP 30,000 - 40,000; Full time

Job summary

A leading retail pharmacy is seeking a Workforce Analyst to support workload and salary planning across UK stores. You will analyze complex datasets, model store workloads, and contribute to business cases. Proficiency in Microsoft Excel and analytical skills are essential. This role offers flexible benefits and a supportive work environment.

Benefits

Boots Retirement Savings Plan

Discretionary annual bonus

Employee discounts

Enhanced maternity/paternity leave

Flexible benefits scheme

Employee Assistance Programme

Qualifications

• Ability to understand complex data streams.
• Proficient in interpreting complex datasets.
• Experience in workforce planning is desirable.

Responsibilities

• Model forecasted workload for each store.
• Calculate salary and investment based on workload.
• Deliver insights from complex data streams.

Skills

Analytical skills

Microsoft Excel proficiency

Attention to detail

Continuous improvement mindset

Tools

IBM Planning Analytics

Power BI

VBA

Power Automate

Job description

Job Description

Contract: 9 Months Fixed Term Contract

Location: Nottingham Support Office

Recruitment Partner: Daniel White

About the role

Have you ever wanted to shape our investment in over 40,000 colleagues?

We have a rare, exciting opportunity for a Workforce Analyst to join the Allocation of Colleague Investment (ACI) Team, to support the Workforce Manager with workload and salary planning for all Boots UK and ROI stores.

The role will support the overall workforce planning agenda within Boots UK and ROI, and will play a key role in ensuring that our stores have the right people, in the right place, at the right time, to offer an outstanding service to our customers.

You will have the opportunity to leverage your expertise and knowledge of data, solution finding and process mapping to help deliver workload and salary budgets to each store.

Key responsibilities

The Allocation of Colleague Investment (ACI) Team is a small but high-profile team within the Central Operations function and plays a key role in supporting the Retail Leadership Team, and 2,000 stores across the UK and ROI.

Key responsibilities include:

• Modelling forecasted workload for each store based on complex datasets from across the business.

• Calculating the required salary and colleague shape of investment based on the workload each store needs to deliver.

• Interpreting complex data streams and delivering insights.

• Supporting the creation of business cases from stakeholders across the Business Units.

• Identifying continuous improvement opportunities using a combination of practical knowledge of retail environments and data.

What you'll need to have

• Able to understand complex data streams and be highly proficient in Microsoft Excel.

• Ability to make complex processes simple, have a strong continuous improvement mindset and keen eye for detail.

• Ability to flex your workload to support the long-term projects as well as short term ad-hoc data work.

• Ability to understand and translate real-world processes / tasks occurring into data-driven process maps

It would be great if you also have

• Previous experience of IBM Planning Analytics / TMI, VBA, Power BI and Power Automate is desirable, but not essential.

• Previous experience of Workforce Planning is desirable, but not essential.

Our benefits

• Boots Retirement Savings Plan

• Discretionary annual bonus

• Generous employee discounts

• Enhanced maternity/paternity/adoption leave pay and gift card for anyone expecting or adopting a child

• Flexible benefits scheme including option to buy additional holiday, discounted gym membership, life assurance, activity passes and much more.

• Access to free, 24/7 counselling and support through TELUS Health, our Employee Assistance Programme.

We have a great range of benefits in addition to the above that offer flexibility to suit you - find out more at boots.jobs/rewards. Exclusions may apply, eligible roles only. Please note, any salary estimates given on third-party sites are not provided or endorsed by Boots and may not be accurate.

Why Boots

At Boots, we foster a working environment where consideration and inclusivity help everyone to be themselves and reach their full potential. We are proud to be an equal opportunity employer, passionate about embracing the diversity of our colleagues and providing a positive and inclusive working environment for all. As the heart of everything we do at Boots, with you, we change for the better.

What's next

If your application is successful, a member of the recruitment team will be in contact.

Where a role is advertised as full-time, we are open to discussing part-time and job share options during the application process. If you require additional support as part of the application and interview process, we are happy to provide reasonable adjustments to help you to be at your best.

Boots is a Ban the Box employer and will consider the suitability of applicants with criminal convictions on a case-by-case basis.

Business Area

Support Office

Function

Retail & Central Operations

Keywords

workforce planning; pharma; planning; pharmacy; excel

Hours per week

37.5

Latitude,longitude 1

52.927182,-1.183948

Is this a Global Brands req?

No

Airport

No

Company

Non Stores

Division

Non Stores

Should this vacancy be excluded from being posted onto the Boots.jobs career site?

No

Region

East Midlands

Area

East Midlands (non stores)

Store

Nottingham Support Office

Req Posted Date

06-Aug-2025

County

Nottinghamshire

Country

UK

Address 1

Recruitment Service Centre (D94)

Address 2

Thane Road

Address 3

Nottingham