BI Analyst

£45,000 per annum, 30 days annual leave + bank holidays, hybrid working & generous pension scheme

Hays Technology are working in partnership with a large public sector organisation in Walsall to recruit a BI Analyst on a permanent basis.

You will be responsible for delivering high quality business intelligence through hands-on technical analysis, using SQL and Power BI to transform data into trusted actionable insight.

You will act as a strategic data partner to a defined area of the business, working closely with senior stakeholders to understand priorities, influence decision-making, and translate complex data into clear, compelling insights.
The role goes beyond traditional data analysis. Success will depend on strong technical capability across SQL, Power BI and related Business Intelligence tools, alongside effective communication, stakeholder management and data storytelling skills.

Technical proficiency underpins the role, enabling you to confidently shape, contextualise and communicate insight that drives performance and improvement.

This role requires strong hands-on technical capability, particularly in SQL, Power BI and the Microsoft Power Platform, alongside the ability to translate analysis into clear business insight.

Main tasks & responsibilities:

• Deliver end-to-end analysis, from requirements gathering through to SQL based data extraction, modelling and insight delivery.
• Transform data into clear, actionable narratives that resonate with non-technical audiences.
• Present insights in a way that highlights what the data means, why it matters and what action should be taken.
• Design dashboards and reports using a range of tools including Power BI, Excel and PowerPoint that prioritise clarity, relevance and ease of use rather than technical complexity.
• Support senior leaders with performance reviews, deep-dive analysis and ad-hoc insight requests.
• Ensure key metrics and KPIs are consistently defined, documented and reflected accurately across SQL datasets and Power BI reports.

In order to apply for this role, you must have the following skills and experience:

• Solid working knowledge of T-SQL for data extraction and analysis with experience of optimising queries and improving data performance.
• Experience using Power BI, DAX and Power Query to create clear, user-focused dashboards and reports.
• Strong Excel and PowerPoint skills for analysis, validation, ad-hoc insight and presentation.
• Practical experience with the Microsoft Power Platform, including building Power Apps and Power Automate flows to enhance reporting, automate processes or improve data quality.
• Experience working with structured data and building reusable datasets and metrics.
• Understanding of data quality, validation and governance principles.
• Strong analytical thinking and problem-solving capability.
• Strong experience acting as a business-facing Business Intelligence or data partner, not just a report developer.

If you have the relevant experience and would like to apply, please submit your CV.

Hays Specialist Recruitment Limited acts as an employment agency for permanent recruitment and employment business for the supply of temporary workers. By applying for this job you accept the T&C's, Privacy Policy and Disclaimers which can be found at (url removed)