Workforce Planning Analyst - (SharePoint/HR/Resourcing/Excel/Power BI/Visio)

Workforce Planning Analyst - (SharePoint/HR/Resourcing/Excel/Power BI/Visio)

Posted 1 day ago by GIOS Technology

Negotiable
Undetermined
Hybrid
London Area, United Kingdom

Summary: The Workforce Planning Analyst role involves maintaining accurate workforce and resourcing data across various workstreams, ensuring quality and audit traceability. The position requires collaboration with Programme Managers and Team Leads to keep data current and involves managing datasets in Excel while integrating with Power BI and Power Automate. The analyst will prepare dashboards and reports to support multiple departments and maintain organisational charts and process maps. Additionally, the role focuses on providing reliable data for forecasting and identifying process improvement opportunities.

Key Responsibilities:

  • Maintain accurate workforce and resourcing data across multiple workstreams.
  • Gather updates from Programme Managers, Team Leads, and suppliers.
  • Manage Excel-based datasets and support integration with Power BI and Power Automate workflows.
  • Prepare dashboards and MI reports in Excel and Power BI.
  • Maintain organisational charts and process maps in Visio.
  • Track resource movements and support governance activities.
  • Provide timely and reliable data for forecasting, reconciliation, and supplier oversight.
  • Identify opportunities for process improvements.

Key Skills:

  • Excel
  • Power BI
  • Power Automate
  • SharePoint
  • Visio
  • Data Analysis
  • Reporting
  • Workforce Planning
  • Capacity Planning

Salary (Rate): undetermined

City: London

Country: United Kingdom

Working Arrangements: hybrid

IR35 Status: undetermined

Seniority Level: undetermined

Industry: Other

Detailed Description From Employer:

I am hiring for Workforce Planning Analyst - (SharePoint/HR/Resourcing/Excel/Power BI/Visio) Location: London Southwark / Lytham St Annes / Glasgow / Durham (40% office-based monthly)

Job Description

Maintain accurate workforce and resourcing data across multiple workstreams, ensuring quality, version control, and audit traceability. Gather updates from Programme Managers, Team Leads, and suppliers to keep capacity and capability data current. Manage Excel-based datasets and support integration with Power BI and Power Automate workflows. Prepare dashboards and MI reports in Excel and Power BI to support Finance, HR, PMO, and Resource Management. Maintain organisational charts and process maps in Visio; track resource movements and support governance activities. Provide timely and reliable data for forecasting, reconciliation, and supplier oversight while identifying opportunities for process improvements.

Key Skills

Excel, PowerBI, PowerAutomate, SharePoint, Visio, DataAnalysis, Reporting, WorkforcePlanning, CapacityPlanning