Workforce Data Analyst

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.