Workforce Planning Analyst
| Job Type | Contract |
| Location | London or Lytham St Annes or Glasgow or Durham/ Hybrid |
| Area | Uk-wide, UK |
| Sector | Central Government |
| Salary | £440 Per Day |
| Start Date | December 4th, 2025 |
| Advertiser | Jack Ingram |
| Job Ref | 7247-PSR1JP00098053 |
| IR35 | Inside |
| Security Clearance | DBS/DS |
- Description
- The Client:
A government department client is looking for a Workforce Planning Analyst to join them on a 6 month contract. This position will be based in London or Lytham St Annes or Glasgow or Durham/ Hybrid.
Job Summary:
Core purpose of Resource Data Analyst: To maintain accurate, trusting resource data and provide high-quality reporting that supports the Transformation Programme in decision making for capacity and capability management and workforce planning. The role is delivery-focussed, supporting the Programme Resource Manager by ensuring the right information is captured, validated and on time. You’ll be working in a small and friendly team (Programme Manager, Workforce Planning Manager and HR Manager). This is an exciting and fast paced role to benefit the improvement of the Transformation Programme's resourcing data and reporting – to get it accurate to support strategic decisions linked to capacity and capability management and workforce planning.
As a Resource Data Analyst, your main responsibilities will be:
- 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.
Essential Technical Skills:
- 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.
Analytical and Delivery Skills:
- 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.
Stakeholder and Team Skills:
- 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.
Desirable:
- Experience supporting a PMO or working in a transformation programme.
- Familiarity with resource planning, capacity reporting or workforce MI.
Our Company:
Malikshaw Interim \& Executive is a specialist provider of talent management solutions helping our clients transform the delivery of our public services. As an Equal Opportunities Employer, we combine providing the best talent with delivering diverse, inclusive workforces and particularly encourage applications from candidates who are likely to be underrepresented. These include people from Black, Asian and minority ethnic backgrounds, disabled people, LGBTQI+ people, and women.
How to Apply:
Please apply through the link provided to send your application directly to the Recruiter managing this assignment.
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:
As a member of the Armed Forces Covenant, the Client guarantees 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 any of the above, please notify us on your covering letter and your recruiter will confirm if the client is a member. We will then 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 me know.
- 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.
