Workforce Planning Analyst

BOOTS; London; On-site; GBP 100,000 - 125,000; Full time

Job summary

A leading retail company in London is seeking a Workforce Analyst to support workforce planning for its 2,000 stores across the UK and ROI. The role focuses on modeling forecasted workloads, calculating salary investments, and leveraging data for insights. Strong analytical skills and proficiency in Microsoft Excel are essential. The company offers various benefits including flexible working arrangements and discounts.

Benefits

Boots Retirement Savings Plan

Discretionary annual bonus

Generous employee discounts

Enhanced parental leave pay

Flexible benefits scheme

24/7 counselling and support

Qualifications

• Ability to simplify complex processes and enhance efficiency.
• Adaptability to tight deadlines and simultaneous tasks.
• Experience in workforce planning is a plus.

Responsibilities

• Model forecasted workload using complex datasets.
• Calculate required salary investments for each store.
• Deliver insights from complex data streams.
• Support business case creation from various stakeholders.
• Identify continuous improvement opportunities in data.

Skills

Strong analytical skills

Proficient in Microsoft Excel

Problem solving

Data-driven process mapping

Continuous improvement mindset

Tools

IBM Planning Analytics

Power BI

VBA

Power Automate

Job description

Closing date: 03 August

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 a brilliant service to our customers.

You will have the opportunity to leverage your expertise and knowledge of data, problem solving 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

• Strong analytical skills, able to understand complex data streams and highly proficient in Microsoft Excel.
• Ability to make complex processes simple, have a strong continuous improvement mindset and keen eye for detail.
• Adaptable to tight deadlines and be able 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

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.