Data Analyst
Role details
Job location
Tech stack
Job description
As a Data Analyst you will strengthen the Strategic Workforce Planning (SWP) function by building and maintaining high-quality workforce datasets and models. You'll own the "data engine" behind SWP-pulling data from multiple sources, validating and cleansing it, improving definitions and controls, and producing clear outputs that leaders can trust. You'll also help the team explore practical uses of AI to improve data quality, efficiency, and insight generation
What you'll do
- Extract, prepare, and maintain workforce data from multiple sources (HRIS, ATS, finance, and operational systems), including repeatable refresh routines, data dictionaries, and a clear audit trail.
- Validate and cleanse data across sources through reconciliations, exception reporting, duplicate removal, standardisation, and taxonomy alignment, while tracking quality metrics and driving fixes with data owners.
- Build and maintain Excel models supporting strategic workforce planning, including baseline workforce views, supply/demand analysis, scenario modelling, and governance-ready charts and outputs.
- Continuously improve analytical capability over time through automation, structured templates, and sensitivity testing.
- Identify and trial practical AI-assisted improvements to data processes - such as classification, anomaly detection, and documentation - sharing learnings and operating within company policy.
- Partner with HR, Finance, and business stakeholders to resolve data discrepancies, clarify definitions, and support the SWP Lead with analysis for planning cycles, transformation programmes, and executive reporting.
Requirements
Do you have experience in SQL?, * Advanced Excel skills including pivots, XLOOKUP, SUMIFS, IF logic, and data validation, with Power Query/Power Pivot and basic DAX experience a strong advantage.
- High data literacy with a proven ability to manage data quality, perform reconciliations, and work confidently with large, multi-source datasets.
- Basic SQL or experience querying reporting tools, ideally with exposure to HR/people data concepts such as headcount, FTE, job families, and org structures.
- Clear, precise communicator who can document assumptions, explain changes, and present findings to stakeholders in plain language.
- Proactive, detail-oriented, and dependable - you spot anomalies before others do, propose fixes rather than just flagging issues, and deliver accurate work under deadline pressure.
- Genuine curiosity about AI and its practical application in analytics workflows, combined with a respect for governance, data privacy, and controls.
Benefits & conditions
- £1,000 learning fund
- Twice-yearly bonus (with part of it guaranteed!)
- Pension contribution scheme
- Private healthcare
- Access to thousands of Udemy courses
- Invest via the Company Sharesave Scheme
- 16 hours paid volunteering time per year
- Uncapped holiday