BI Analyst

BI Analyst London, Leeds (1 day per month in office) | £46,000 + Benefits Must be advanced in Excel No sponsorship offered

2 years minimum experience

Looking for a BI Analyst role where your work directly influences major workforce and business decisions? This is an opportunity to join a highly respected organisation at the centre of workforce strategy, delivering complex analysis and modelling that helps shape critical decision-making. Working within a specialist analytics team, you'll combine technical expertise with stakeholder engagement to provide insights that have genuine organisational impact.

The Company

This organisation plays a significant role in supporting workforce planning, employment policy and strategic decision-making across a large and complex sector. Their analytical function provides evidence-based insight used to inform senior leaders, policy teams and external stakeholders.

The Role

As a BI Analyst, you will be responsible for delivering workforce and financial analysis that supports policy development, workforce planning and operational decision-making.#

Key responsibilities include

Building and maintaining complex workforce and financial models in Excel.

Analysing large datasets to identify trends, risks and opportunities.

Producing cost modelling and impact assessments for proposed business initiatives and workforce changes.

Developing scenario planning and forecasting models to support strategic decisions.

Translating business and policy questions into analytical specifications.

Creating reports, dashboards and presentations for both technical and non-technical audiences.

Providing evidence-based recommendations to senior stakeholders.

Supporting stakeholder discussions through clear, objective analysis.

Collaborating with colleagues across analytics, policy and operational teams.

Contributing to the continuous improvement of analytical processes and methodologies.

Your Skills & Experience

To be successful in this BI Analyst role, you'll have

Advanced Excel skills, including complex modelling, Pivot Tables, formulas, charts and VBA/macros.

Strong analytical experience working with large and complex datasets.

Demonstrable experience building and improving financial, operational or workforce models.

The ability to explain technical findings clearly to non-technical stakeholders.

Strong communication and stakeholder management skills.

Experience balancing multiple priorities in a fast-paced environment.

A degree in a quantitative discipline such as Mathematics, Statistics, Economics, Engineering, Computer Science or a related STEM subject.

Desirable experience includes

Python, R or SPSS.

Workforce analytics, people analytics or public sector analysis.

Exposure to workforce planning, reward, compensation or operational modelling.

What They Offer

Salary of £46,000.

Flexible and remote working options.

One office visit per month.

Opportunity to work on high-profile analytical projects with real-world impact.

Exposure to senior stakeholders and strategic decision-making.

Ongoing professional development and learning opportunities.

Potential future leadership responsibilities within the analytics function.

Collaborative and supportive team environment.

How to Apply

If you're an analytically minded BI Analyst with advanced Excel modelling skills and a passion for turning complex data into actionable insight, please apply today to learn more about this opportunity.