Remote Data Analyst | Workforce & Financial Modelling Pro

Harnham; Cumbernauld; Hybrid; GBP 41,000 - 51,000; Full time

Job summary

Harnham is seeking a Data Analyst for a remote role with one day per month in Leeds. You will analyse workforce, pay, and reward data to inform strategic decisions and build complex Excel models for forecasting and cost modelling.

The role requires strong analytical skills, stakeholder engagement, and the ability to translate policy questions into actionable insights. You will work with senior stakeholders, collaborate with policy teams, and contribute to developing analytical methodologies

Qualifications

• Advanced Excel skills with the ability to build complex models from scratch.
• Experience with formulas, Pivot Tables, charts, VBA and macros.
• Strong analytical and quantitative problem solving abilities.
• 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.
• 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 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.

Skills

Advanced Excel

Pivot Tables

VBA

Macros

Analytical thinking

Data analysis

Communication skills

Stakeholder management

Independent working

Problem solving

Education

STEM degree (maths/statistics/economics or related)

Tools

Excel

Job description

Harnham is seeking a Data Analyst for a remote role with one day per month in Leeds. You will analyse workforce, pay, and reward data to inform strategic decisions and build complex Excel models for forecasting and cost modelling.

The role requires strong analytical skills, stakeholder engagement, and the ability to translate policy questions into actionable insights. You will work with senior stakeholders, collaborate with policy teams, and contribute to developing analytical methodologies