Workforce Planning Analyst

BOOTS; City Of London; On-site; GBP 60,000 - 80,000; Full time

Job summary

A leading retail company in the UK is looking for a Workforce Analyst to support workload and salary planning for its stores. The role involves data analysis to ensure efficient workforce management, and candidates should have proficiency in Excel and the ability to interpret complex data. Benefits include a retirement savings plan, employee discounts, and flexible work options.

Benefits

Retirement Savings Plan

Discretionary annual bonus

Generous employee discounts

Enhanced maternity/paternity/adoption leave

Flexible benefits scheme

Access to 24/7 counselling and support

Qualifications

• Ability to simplify complex processes.
• Flexibility to support various projects.
• Skill in translating real-world processes into data-driven maps.

Responsibilities

• Model forecasted workload for each store.
• Calculate required salary and colleague investment shape.
• Interpret complex data streams and deliver insights.
• Support creation of business cases from stakeholders.
• Identify improvement opportunities using data.

Skills

Understanding complex data streams

Proficient in Microsoft Excel

Continuous improvement mindset

Detail-oriented

Tools

IBM Planning Analytics

Power BI

VBA

Power Automate

Job description

Overview

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.