Business Intelligence Analyst

Warwickshire County Council; Warwick; On-site; GBP 36,000 - 48,000; Full time

Benefits offered by this job

Pension scheme

Agile working

Generous annual leave

Vivup benefits

Job summary

Warwickshire County Council is seeking an experienced and enthusiastic business intelligence analyst to join the Strategic Research Team in the Business Intelligence function. This is a fixed-term post until 31 March 2028.

The role focuses on analysing data from various sources, building PowerBI dashboards, and providing evidence-based insights to support decision making and service delivery, including survey analysis and stakeholder reporting.

Qualifications

• Experience as a business intelligence analyst in a public sector setting.
• Ability to design and build PowerBI dashboards.
• Experience analysing quantitative and qualitative survey data.

Responsibilities

• Interpret and report on local and national datasets to support strategies.
• Design and build PowerBI dashboards for elected members.
• Support council plan delivery through data analysis and reporting.
• Provide data analysis for consultation and engagement activities.

Skills

Data analysis

Stakeholder engagement

Communication

Problem-solving

Tools

PowerBI

Excel

Job description

We are looking to recruit an experienced and enthusiastic business intelligence analyst to join the Strategic Research Team in Business Intelligence at Warwickshire County Council. This is a fixed term post until 31st March 2028.

This is an exciting opportunity to join a Business Intelligence team that provides a critical function to the council, ensuring that we can make evidence-based decisions, can understand what we are doing well and where we can do better. The role will help to deliver the team’s work programme through the analysis, interpretation and innovative reporting of both contextual and service data. You will be fundamental to ensuring that senior management and commissioners have the best intelligence available to them to support decision making and service delivery, allowing the effective targeting of resources within a challenging financial environment.

The successful candidate will be based in the Strategic Research team which is part of the Business Intelligence function. The Business Intelligence Analyst’s role will be varied and involve providing solutions to collecting, analysing, interpreting and presenting data from a number of areas across Warwickshire County Council. The candidate will also be involved in the analysis of both quantitative and qualitative survey data. The role will involve:

• Using a range of tools and techniques to interpret and report on local and national datasets and published research to support the development of evidence-based corporate strategies, policies and prioritised change activity.
• Designing and building PowerBI dashboards to enable teams and elected members to understand complex data
• Supporting delivery of the Council Plan through participation in project groups and the provision of relevant data analysis and reporting.
• Providing support to consultation, engagement and user research activity including the design and build of surveys, and analysis of both quantitative and qualitative responses.

You’ll find there is a varied workload with opportunities to work with colleagues from across the organisation on current and important issues. In addition to underpinning the day-to-day operation of council services there is a need to be agile and react to the ever-changing external environment.

You will have access to the technology and the data you’ll need to do the best job possible; we use the Microsoft suite of tools and subscribe to a number of datasets that allow us to provide the insight required to support evidence-based practice. Training is provided where necessary and proactive learning and development positively encouraged.

You will also have some flexibility around where and when you work, including time at our Shire Hall offices in the heart of Warwick. These offices have recently been reconfigured to allow both face-to-face collaboration and virtual working, providing an excellent working environment.

Working for the Business Intelligence Team you will be part of a friendly and supportive team who look out for each other; we’ll give you the support and encouragement you need to succeed and help others around you – because we know a job done well, is a job done together.

So, if you’re someone who is prepared to get stuck in, who wants to do the best job possible, who approaches everything with passion and purpose, then we want you to work for us. You’ll be able to apply your knowledge and abilities in a place that matters to people and communities. And simply put, you’ll enjoy working here because of that.

For further information please see the Job Description and Person Specification.

Working for Warwickshire – This is the difference you make

Warwickshire County Council is a place where everyone feels valued, included, safe, supported, and welcome. Our people are at the heart of this vision, could you be one of them!

At Warwickshire County Council we are committed to ensuring Warwickshire’s economy is vibrant and supported by the right jobs, training, skills and infrastructure. Our people vision for Warwickshire County Council is a great place to work where diverse and talented people are enabled to be their best.

Your future matters to us, we provide a generous pension scheme which includes an employer contribution rate of typically around 19 percent per month, to help support your financial security during retirement. The scheme also offers a valuable package of benefits for members and their dependants. To find out more please visit: Warwickshire Pension Fund homepage – Warwickshire Pension Fund'

The benefits we offer include agile working, a valuable part of the pay and reward package for employees working in local government, generous annual leave entitlement, plus bank holidays and an additional day at Christmas, and access to Vivup benefits and discounts platform.

Additional Information

The Fluency Duty is outlined in the Code of Practice on the English language requirements for public sector workers. The Fluency Duty for this role is Required. You must be able to speak and provide advice in accurate spoken English to the public.

If you are applying for this role on a secondment basis please ensure you have permission from your line manager.

Closing date: 17th September 2026
Interview date: Friday 2nd October or Monday 5th October 2026