Data Analyst

Harnham; Guildford; Hybrid; GBP 28,000 - 46,000; Full time

Job summary

Harnham in the United Kingdom is seeking a Data Analyst to join a team at the intersection of workforce analytics and policy. You will build Excel-based models, forecast workforce and financial outcomes, and present insights to senior stakeholders.

The role emphasizes advanced Excel, VBA and data modelling, with opportunities to work independently and collaboratively across policy teams. This is a remote role with one day per month in Leeds office, offering exposure to high-quality analytics and

Qualifications

• Advanced Excel skills including complex models.
• Experience with formulas, Pivot Tables, VBA and macros.
• Strong analytical and quantitative problem-solving ability.
• Experience modelling complex business/workforce/financial scenarios.
• Ability to work with large datasets and extract insights.
• Excellent written and verbal communication skills.
• Experience presenting to non-technical stakeholders.
• Strong stakeholder management skills.
• STEM degree in maths/statistics/economics or related.
• Ability to work independently and manage competing priorities.

Responsibilities

• Deliver workforce, pay, and reward analysis to support strategic decision-making.
• Build and maintain complex Excel-based models to forecast workforce and financial outcomes.
• Develop cost modelling for pay proposals, policy changes, and workforce initiatives.
• Create scenario analysis and long-term forecasts incorporating variables like growth, attrition, and inflation.
• Analyse large and complex datasets to identify trends, risks, and opportunities.
• Translate business and policy questions into analytical specifications and modelling frameworks.
• Produce clear reports and recommendations for non-technical audiences.
• Present findings and analytical insights to senior stakeholders.
• Collaborate with policy teams and external stakeholders to support evidence-based decisions.
• Contribute to ongoing development of analytical methodologies and best practices.

Skills

Analytical thinking

Stakeholder management

Communication skills

Independent working

Education

STEM degree in maths/statistics/economics

Tools

Excel

Pivot Tables

VBA

Macros

Job description

DATA ANALYST

REMOTE (ONE DAY A MONTH IN LEEDS OFFICE)

UP TO £46,000

This is an opportunity to join a highly respected organisation at the intersection of workforce strategy, analytics, and policy. As a Data Analyst, you will play a key role in shaping evidence-based decisions that influence workforce planning, pay frameworks, and long-term organisational strategy. You'll work on complex analytical challenges whilst engaging with a broad range of senior stakeholders.

ROLES AND RESPONSIBILITIES:

The Data Analyst will:

• Deliver workforce, pay, and reward analysis to support strategic decision-making.
• Build and maintain complex Excel-based models to forecast workforce and financial outcomes.
• Develop cost modelling for pay proposals, policy changes, and workforce initiatives.
• Create scenario analysis and long-term forecasts incorporating variables such as workforce growth, attrition, and inflation.
• Analyse large and complex datasets to identify trends, risks, and opportunities.
• Translate business and policy questions into analytical specifications and modelling frameworks.
• Produce clear reports and recommendations for non-technical audiences.
• Present findings and analytical insights to senior stakeholders.
• Collaborate with policy teams and external stakeholders to support evidence-based decisions.
• Contribute to the ongoing development of analytical methodologies and best practices.

YOUR SKILLS AND EXPERIENCE:

The ideal candidate will have the following skills and experience:

• Advanced Excel skills, including building complex models from scratch.
• Experience using formulas, Pivot Tables, charts, VBA, and macros.
• Strong analytical and quantitative problem-solving capability.
• Experience modelling complex business, workforce, or financial scenarios.
• The ability to work with large datasets and extract meaningful insights.
• Excellent written and verbal communication skills.
• Experience presenting technical information to non-technical stakeholders.
• Strong stakeholder management and relationship-building skills.
• A STEM degree, ideally within mathematics, statistics, economics, or a related discipline.
• The ability to work independently and manage competing priorities.