Remote Data Analyst - Workforce & Pay Forecasting

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

Benefits offered by this job

Remote one day a month in Leeds office

Job summary

Harnham is seeking a Data Analyst for a remote role with one mandatory Leeds office day per month. You will shape workforce analytics, build complex Excel models, and forecast workforce and financial outcomes to support strategic decision-making.

You will analyse large datasets, develop cost modelling for pay proposals, and present insights to senior stakeholders. A STEM degree and strong communication skills are essential.

Qualifications

• Advanced Excel skills including building complex models from scratch.
• Experience with formulas, Pivot Tables, charts, VBA, and macros.
• Strong analytical and quantitative problem-solving capability.
• Experience modelling complex business, workforce, or financial scenarios.
• 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 related discipline.
• 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 key variables.
• 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.

Skills

Advanced Excel

Pivot Tables

VBA / Macros

Data analysis

Quantitative analysis

Stakeholder management

Communication

Problem solving

Independent worker

Education

STEM degree

Tools

Excel

VBA

Macros

Job description

Harnham is seeking a Data Analyst for a remote role with one mandatory Leeds office day per month. You will shape workforce analytics, build complex Excel models, and forecast workforce and financial outcomes to support strategic decision-making.

You will analyse large datasets, develop cost modelling for pay proposals, and present insights to senior stakeholders. A STEM degree and strong communication skills are essential.