Workforce Planning Analyst

A workforce planning analyst works out how many people an organisation needs, with what skills, in which locations, and at what times - and whether the current staff can meet that demand. In operational settings like contact centres, retail, hospitals, logistics and airlines, this usually means forecasting customer or patient demand and building staff rosters and shift patterns to match it. In corporate HR settings, it means longer-range modelling of headcount, attrition, recruitment pipelines and pay budgets to help senior managers decide who to hire, where, and when.

Approximate graduate salary

Typically around GBP 25,000-35,000 to start, though this varies widely by sector and location - operational planning roles outside London and public sector posts tend to sit at the lower end, while graduate schemes at large financial services or consulting employers, and roles in London, can be noticeably higher.

What you'd actually do

Pulling data out of HR, payroll, rostering or contact-centre systems and cleaning it up in Excel or SQL so it can actually be analysed - a surprisingly large share of the week
Building and updating forecasts: predicting call or contact volumes, patient admissions, seasonal retail demand or expected staff leavers over coming weeks, months or quarters
Translating a forecast into a staffing requirement - how many advisors, nurses, drivers or engineers are needed per half-hour, per shift or per month - and flagging where the numbers do not add up
Producing and maintaining dashboards and recurring reports on headcount, vacancies, turnover, absence, overtime and agency spend, usually in Power BI, Tableau or Excel
Sitting in review meetings with operations managers, HR business partners or finance to explain why the model says what it says and what the options are (recruit, use overtime, move people, change shift patterns)
Running scenario models - 'what happens to staffing costs if attrition rises', 'what if we open a new site', 'what if this contract volume doubles' - and writing these up for leadership
Investigating variances after the fact: why did we overstaff on Tuesdays, why did absence spike in one depot, why is one team missing its service targets

How graduates get in

Direct entry into a junior analyst or 'resource planning analyst' role, often after a spell in a frontline operational job. In contact centres, retail and logistics this is very common - people move from the phones or the shop floor into real-time monitoring, then into scheduling, then into forecasting.
Graduate schemes in HR / people, business management or operations at large employers, with a workforce planning rotation. Common in banking, insurance, utilities, retail groups, the NHS and the Civil Service; less common at smaller organisations, which tend to hire directly.
NHS routes: the NHS Graduate Management Training Scheme (HR or general management specialisms) and direct-entry band roles in workforce information, e-rostering or workforce planning teams within trusts and integrated care boards.
Sideways moves from a general data analyst, MI (management information) analyst or finance analyst role - a well-trodden path, since the modelling skills transfer and the HR context can be learned.
Civil Service Fast Stream (particularly the HR or operational delivery streams) and departmental analyst roles, where workforce planning sits alongside wider people strategy.
Internships or placement years in HR, operations or business analysis - useful but not required; many people arrive with no formal HR background at all.

What employers ask for

A degree in most cases, though the subject matters less than the ability to handle numbers. Economics, maths, statistics, business, management, psychology, geography and social sciences all appear frequently. Some employers hire without a degree if you have operational experience and can demonstrate the analysis.
Demonstrable Excel ability - this is checked properly. Expect to be asked about lookups, pivot tables and building a model, and to sit an Excel or numerical exercise at interview.
Grades: 2:2 or above is typical where a class is specified; some graduate schemes ask for a 2:1 and set A-level or UCAS thresholds, others have dropped grade filters entirely. This varies a lot by employer.
No mandatory professional qualification. CIPD (Chartered Institute of Personnel and Development) qualifications are common and often employer-funded if you sit on the HR side; on the operational planning side, employers care far more about tool skills than certificates.
Experience with SQL, Power BI or Tableau is frequently listed as desirable rather than essential at entry level, but it strongly improves your chances and becomes near-essential for progression.
Familiarity with workforce management or HR systems (rostering tools, HRIS platforms, contact-centre WFM software) is usually taught on the job - do not rule yourself out for lacking it.

Skills that matter

Practical Excel modelling

Most forecasts, staffing calculators and scenario models still live in spreadsheets, and you will be expected to build, fix and explain them rather than just read them.

Forecasting and basic statistics

You need to understand seasonality, trends and averages well enough to know when a model is misleading you - for example, when one unusual month is distorting next year's headcount plan.

SQL and data visualisation

Workforce data is scattered across rostering, payroll and recruitment systems, so being able to query it yourself and present it in a dashboard saves days of waiting on other teams.

Explaining numbers to non-analysts

A ward manager or head of operations will not read your model; they need a clear recommendation and an honest account of what the forecast assumes and where it could be wrong.

Handling disagreement and pushback

Your analysis often implies someone cannot have the headcount they asked for, and managers will challenge your assumptions - you have to defend the method calmly without becoming inflexible.

Attention to detail with messy data

Duplicate records, part-time staff counted as full-time and leavers left on the system quietly wreck a headcount number, and nobody else will catch it before it reaches a director.

Where it leads

Junior or assistant analyst: running established reports, updating existing models, doing real-time or short-term scheduling work. Usually the first year or two, though this varies with employer size.
Workforce planning analyst / resource planning analyst: owning a forecast, a business area or a set of models, and presenting directly to operational managers.
Senior analyst or workforce planning manager: taking on longer-range planning, leading a small team, and being involved in decisions about recruitment volumes, shift design and operating budgets. Timelines here vary widely - a few years in a fast-growing operation, longer in a large stable one.
From there the paths fork. Some move into strategic workforce planning or people analytics at group level; some move into operations management, having learned how the business actually runs; some move into finance-facing roles such as FP&A (financial planning and analysis) or commercial analysis; some move into HR business partnering, usually with a CIPD qualification behind them.
Longer term, the role can lead to head of workforce planning, head of people analytics, or operations director roles, and it is a reasonably common launchpad into independent consultancy for people with sector-specific forecasting expertise.

What people get wrong

“It is an HR job, so it is mostly about people skills rather than numbers.”

In most organisations it is one of the most quantitative roles in the people function, and the day-to-day looks closer to a data analyst's than a recruiter's. Some roles sit in operations or finance rather than HR at all.

“You forecast once a year and the plan stays fixed.”

Plans are revised constantly as attrition, demand, absence and business decisions shift. Much of the job is re-forecasting and explaining why last month's number changed - and in contact-centre style roles, planning happens down to fifteen- or thirty-minute intervals.

“The hard part is building the model.”

The hard part is usually getting trustworthy data in the first place, and then persuading managers to act on an answer they do not like. Technically elegant analysis that nobody acts on counts for nothing.

“It is a back-office role with little exposure.”

Because headcount is one of the largest costs most organisations have, analysts often present to senior leadership early in their careers and their numbers feed directly into budget and recruitment decisions.

Where this varies

The title covers two fairly different jobs. In contact centres, retail, hospitality, logistics and airlines, 'workforce planning' usually means short-term resource planning: forecasting demand in fine time intervals, building rosters and monitoring service levels in real time, often as part of a team split into real-time, scheduling and forecasting functions, and sometimes on shift patterns that include evenings or weekends. In corporate HR, consultancy and the public sector, it means strategic workforce planning: multi-year headcount modelling, skills gap analysis, succession and pipeline planning, with far more work in PowerPoint and business cases and no real-time element. The NHS has its own well-developed version, with dedicated workforce information and e-rostering teams and national workforce data standards. Check which flavour an advert means before applying - the skills overlap but the daily rhythm does not.

General guidance about the role across the UK market, not about any specific employer. Entry routes and requirements vary — always check the individual job advert.