Business Intelligence 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.