Workforce Data Analyst
Posted 1 day ago by 1764908114
£400 Per day
Inside
Hybrid
Glasgow
Summary: The Data Workforce Analyst role is a 6-month contract position focused on maintaining accurate resource data and providing high-quality reporting to support the Transformation Programme. The analyst will work closely with a small team to ensure timely and validated information for capacity and capability management. This delivery-focused role requires strong Excel skills and experience in data management within a Programme Management Office or similar environment. The position is hybrid, requiring presence in Glasgow, Durham, or London, and is classified as inside IR35.
Key Responsibilities:
- Maintain, update and quality assure resourcing data across multiple workstreams, ensuring accuracy and consistency.
- 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 workflow.
- Prepare resourcing reports, dashboards and MI within Excel and Power BI to support stakeholders.
- Maintain and update organisation charts and process charts in Visio on behalf of the Transformation Programme.
- Track resource movement and ensure POs are raised and governance is followed.
- Provide reliable, timely data to Finance for forecasting and month-end reconciliation.
- Coordinate with suppliers to ensure timely submission of resourcing information and timesheet.
- Support improvements to processes and tooling by providing insights from day-to-day resourcing operational experience.
Key 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.
- 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.
Salary (Rate): £400 daily
City: Glasgow
Country: United Kingdom
Working Arrangements: hybrid
IR35 Status: inside IR35
Seniority Level: Mid-Level
Industry: IT
Data Workforce Analyst | 6 Month Contract | (Inside IR35) | Hybrid, 40% - Glasgow/Durham/London | Starting ASAP
Day Rate: £400
About the Role:
To maintain accurate, trusting resource data and provide high-quality reporting that supports the Transformation Programme in the client's 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 clients Transformation Programme resourcing data and reporting - to get it accurate to support strategic decisions linked to capacity and capability management and workforce planning.
Main Duties
- 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 workflow
- 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 timesheet
- Support improvements to processes and tooling by providing insights from day-to-day resourcing operational experience
Essential Skills & Experience:
- 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.
Desirable Qualifications
- 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
This role has been deemed Inside IR35 by the client. Applicants must hold, or be happy to apply for, a valid Basic Disclosure Scotland. Please click the link to apply.