Full job descriptionBI 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.