Role: Workforce Planning Analyst REF 98053
Contract Length: 6 months (potential to extend or be moved to FTC)
Location: Hybrid/London Southwark, Lytham St Annes, Glasgow or Durham - 40% office based over monthly basis
IR35: Inside
Pay Rate to Intermediary: Up to £440 per day
Security Clearance: BPSS
Spinwell is recruiting for a Workforce Planning Analyst for an excellent opportunity within the public sector.
RESPONSIBILITIES OF THE WORKFORCE PLANNING ANALYST
- Maintain, update and quality assure resourcing data across multiple workstreams, ensuring accuracy and consistency. In turn, maintain version control, audit trails and clear documentation of changes to resourcing data
- Gather resourcing updates from Programme Managers, Team Leaders and suppliers to keep workforce and capacity data current
- Manage Excel resourcing data to support integration of data across Power BI and Power Automate workflows
- Prepare resourcing reports, dashboards and MI within Excel and Power BI to support stakeholders i.e. Resource Manager, Finance, HR and Programme Management Office.
- Maintain and update organisation charts and process charts in Visio on behalf of the Transformation Programme
- Track resource movement (joiners, leavers, extensions, role changes) and ensure POs are raised and ensure governance around this is followed. In turn, support the Resource Manager in maintaining controls for approvals, (Statement of Works, pre-invoicing) governance and supplier oversight
- Provide reliable, timely data to Finance for forecasting and month-end reconciliation
- Coordinate with suppliers to ensure timely submission of resourcing information and timesheets
- Support improvements to processes and tooling by providing insights from day-to-day resourcing operational experience
SKILLS/EXPERIENCE OF THE WORKFORCE PLANNING ANALYST
- Experience working with structured data, ideally in a Programme Management Office, HR or Resourcing Operations environment
- Strong Excel skills: pivot tables, formulas, data validation and conditional formatting
- Ability to manage and update SharePoint lists and create structured datasets for reporting into Power BI and creating Power Automate flows.
- Experience creating clear, accurate resourcing reports and dashboards in Excel and Power BI.
- Proven experience in maintaining Visio organisational charts for complex programmes and process diagrams for resourcing governance.
- Strong attention to detail, ensuring data accuracy and completeness
- Ability to follow establish processes and maintain consistent documentation and audit trails
- Good organisational skills with ability to manage multiple data requests and deadlines
- Ability to interpret workforce/capacity data and highlight gaps or inconsistencies.
- Comfortable engaging with range of colleagues to gather updates and clarify data issues
- Good communication skills, able to explain data queries clearly
- Collaborative team player willing to support across PMO, HR and Programme teams
- Proactive in identifying errors, risks or opportunities to streamline processes and work effectively with Resource, HR and Workforce Planning Manager to articulate this
If you are a Workforce Planning Analyst, apply now or send your CV to Spinwell!
We welcome all applications regardless of background, in line with our commitment to diversity, equality and inclusion.
Applying to this or any other vacancy advertised by Spinwell Ltd constitutes an agreement for Spinwell Ltd to hold your details for 24 months for the purpose of assessing suitability for the advertised position and to make you aware of any other positions deemed suitable of which You will make you aware by means of either email, text or phone. In line with GDPR regulations you are able to request your details be removed from the company data at any time by emailing us
Disability Confident
As a member of the disability confident scheme, the client guarantees to interview all candidates who have a disability and who meet all the essential criteria for the vacancy. In cases where we have a high volume of candidates who have a disability who meet all the essential criteria, we will interview the best candidates from within that group.
Armed Forces Covenant
The client is proud to support the Armed Forces Covenant and as such, we guarantee to interview all veterans or spouses / partners of military personnel who meet all the essential criteria for the vacancy. In cases where we have a high volume of ex-military candidates / military spouses or partners, who meet all of the essential criteria, we will interview the best candidates from within that group.
If you qualify for the above, please notify us and quote the role you are applying for.
We will be in touch to discuss your suitability and arrange your Guaranteed Interview.
Should you require reasonable adjustments at any point during the recruitment process or if there is a more accessible way for us to communicate, please do let us know.