Data Analyst

Harnham; City Of London; Hybrid; GBP 41,000 - 51,000; Full time

Benefits offered by this job

Hybrid working

Office in London/Leeds

Career development opportunities

Job summary

Industry organisation in the public sector is seeking an experienced analytics professional to deliver workforce and pay analysis, build complex Excel models, and forecast scenarios. You will work with senior stakeholders across policy and reward functions to inform strategic decisions.

You will analyse large datasets, explain findings to non-technical audiences, and contribute to analytical best practice within a collaborative team. Hybrid working with UK-wide stakeholders is available.

Qualifications

• Advanced to expert-level Excel with complex modelling, Pivot Tables, formulas, VBA and macros.
• Strong experience modelling complex financial or workforce scenarios.
• Experience with large, complex datasets and deriving actionable insights.
• Ability to explain technical findings to non-technical audiences.
• Strong stakeholder management and communication skills.
• Comfortable working independently and handling changing priorities.
• Exposure to workforce analytics, reward analysis or policy environments is advantageous.

Responsibilities

• Delivering workforce and pay analysis to support strategic decision-making and policy development.
• Building and maintaining complex Excel-based workforce and financial models.
• Modelling the impact of pay changes, workforce growth, retention trends and policy proposals.
• Developing costings and long-term forecasts using scenario modelling techniques.
• Analyzing large workforce and payroll datasets to identify trends, risks and opportunities.
• Translating policy questions into analytical specifications and insights.
• Producing clear reports and recommendations for senior, non-technical stakeholders.
• Presenting findings to leadership teams and external partners.
• Supporting peer review processes and contributing to analytical best practice.
• Building relationships across policy, workforce and reward functions.

Skills

Advanced Excel

Excel modelling

Pivot Tables

Formulas & VBA

Data analysis

Power BI

Python

R

SPSS

Stakeholder communication

Tools

Power BI

Python

R

SPSS

Job description

This is a rare opportunity to join a highly respected organisation at the centre of workforce strategy and reward analysis. You will play a key role in delivering evidence-based insights that influence large-scale workforce planning and pay decisions, while working with senior stakeholders across a complex public sector environment.

The Company

They are a national membership organisation that supports employers across a large and complex workforce landscape. Their analytics function provides independent, evidence-led insight to support workforce strategy, pay modelling and policy development. The team works closely with senior leaders, policy specialists and external stakeholders to ensure decisions are informed by robust analysis. Operating in a politically sensitive environment, they are committed to delivering objective, high-quality evidence that stands up to scrutiny.

The Role

You will join a small, established analytics team and report directly to the Head of Analytics. Responsibilities include:

• Delivering workforce and pay analysis to support strategic decision-making and policy development
• Building and maintaining complex Excel-based workforce and financial models
• Modelling the impact of pay changes, workforce growth, retention trends and employment policy proposals
• Developing costings and long-term forecasts using scenario modelling techniques
• Analysing large workforce and payroll datasets to identify trends, risks and opportunities
• Translating policy questions into analytical specifications and actionable insights
• Producing clear reports and recommendations for senior, non-technical stakeholders
• Presenting findings and technical advice to leadership teams and external partners
• Supporting peer review processes and contributing to analytical best practice
• Building relationships with a wide range of stakeholders across policy, workforce and reward functions

Your Skills & Experience

• Advanced to expert-level Excel skills, including complex modelling, Pivot Tables, formulas, VBA and macros
• Strong analytical experience modelling complex financial or workforce scenarios
• Experience working with large, complex datasets and generating actionable insights
• Ability to explain technical findings clearly to non-technical audiences
• Strong stakeholder management and communication skills
• Comfortable working independently and managing changing priorities
• Experience with Power BI, Python, R or SPSS would be beneficial
• Exposure to workforce analytics, reward analysis, public sector data or policy-driven environments is advantageous

What They Offer

• Salary up to £46,000 depending on experience
• Hybrid working with offices in London or Leeds
• Opportunity to work on high-profile workforce and pay analysis projects
• Exposure to senior stakeholders and strategic decision-making
• Established role with long-term stability and potential future line management responsibilities
• Collaborative and supportive analytics team environment
• Excellent opportunity to deepen expertise in workforce analytics, modelling and policy impact assessment