Business Intelligence Analyst

Reed Talent Solutions; Liverpool; Hybrid; GBP 35,000 - 50,000; Full time

Job summary

A leading public service provider in the UK is seeking a Business Intelligence Analyst to drive efficient reporting and support data needs across various contracts. The successful candidate will have extensive experience with Power BI and SQL, along with strong Excel skills. This role offers a base salary, flexibility, and numerous benefits, including training opportunities and a supportive work culture.

Benefits

25 days annual leave

Reed Pension Scheme

Award Winning Management & Leadership training

Professional & Personal Development Funds

Bi-annual pay reviews

Qualifications

• Demonstrable experience of using Power BI.
• Experienced in the use of relational databases including SQL.
• Demonstrable advanced excel spreadsheet skills.
• Ability to present complex Business Intelligence effectively.
• Excellent organisational and time management skills.

Responsibilities

• Lead in the preparation and development of key business intelligence.
• Ensure timely and efficient processing of claims data.
• Collaborate with stakeholders to translate needs into insights.
• Conduct data manipulation and transformation in Power BI.

Skills

Power BI

SQL

Advanced Excel skills

Data manipulation

Stakeholder management

Attention to detail

Tools

Microsoft Packages

Snowflake

Job description

Do you have demonstrable experience of using Power BI?

Are you experienced in the use of relational databases including SQL?

Business Intelligence Analyst at Reed in Partnership!

We are on a mission to be the partner of choice for developing people and their communities. Reed in Partnership is a public service provider specialising in skills training for the long-term unemployed, increasing employment opportunities by working with employers and providing youth services.

Internal applications for this role close on Tuesday 25th November 2025.

What is the role about?

The purpose of the Business Intelligence Analyst is to lead in the preparation and development of key business intelligence to enable efficient, effective and commercially focussed performance reporting within the business. The role will also ensure the data requirements of claims processing activity are met to ensure the business submits its claims in a timely and efficient manner.

The Business Intelligence Analyst is responsible for researching reporting requirements for a variety of stakeholders for current and newly awarded contracts, including designing robust controls to ensure the accuracy of the data presented.

The role will work closely with other departments to ensure business reporting requirements are delivered in an efficient and cost-effective manner and will ensure usage of the BI tool is maximised.

This Job Description does not constitute an exhaustive list of duties, and the BI analyst will be expected to carry out any other duties as may be specified by the line manager from time to time. This profile is non-contractual.

Just some of your day-to-day responsibilities will include

• Deliver measurable business impact through advanced BI solutions that drive strategic and operational outcomes.
• The development, optimization, and automation of Power BI dashboards and reports, ensuring they are insightful, scalable, and user-friendly.
• Collaborate with stakeholders to understand business needs and translate them into actionable insights and data products.
• Influence and inform decision-makers using compelling data storytelling, strategic analysis, and visual narratives.
• Act as a subject matter expert in Power BI, including DAX, data modelling, and visualization best practices.
• Build strong relationships with cross-functional stakeholders, ensuring alignment between BI outputs and business goals.
• Contribute to the continuous improvement of BI practices, tools, and governance frameworks.

Other

Other key responsibilities of the Business Intelligence Analyst are;

• Perform data manipulation and transformation in Power BI
• Understand and use code within Power BI
• To provide cover for other roles in the Business Intelligence Team in times of annual leave / absence or workload fluctuations
• The assist in the daily preparation of the Performance Flash and other ad-hoc reports as required

To coach operational and commercial management in understanding the data presented to aid performance improvement

What’s in it for you?

A generous base salary (pro-rata for part time), and great flexibility with your working schedule, we offer training, development and progression opportunities. You will have access to the range of Reed in Partnership benefits, which include:

• 25 days annual leave (pro-rata for part time) plus statutory bank holidays
• Reed Pension Scheme
• Award Winning Management & Leadership training
• Professional & Personal Development Funds
• Bi-annual pay reviews
• Plus much more that can be found on our website
• With the chance to dramatically make a difference to the local community, this role offers immense job satisfaction.

At Reed in Partnership, we live and breathe our values in every decision and action taken, resulting in a collaborative and enjoyable culture within our offices. Our company values – we are fair open and honest; we take ownership, and we work together.

Where possible we consider applications from candidates that require part-time hours, please discuss with your Talent Partner if this is something you require.

To be successful in this role, we are looking for someone with

Essential Criteria

• Experienced in the use of relational databases including SQL.
• Demonstrable experience of using Power BI
• Demonstrable advanced excel spreadsheet skills with pivots, macros and look‑ups.
• Demonstrable experience in dealing with high volumes of data with excellent attention to detail
• Ability to present complex Business Intelligence to all levels in the organisation.
• Ability to quickly understand and follow complex systems and procedures.
• Be able to work under pressure and work to strict reporting deadlines.
• Excellent organisational and time management skills.
• Technical skills: Data Manipulation, Data Validation, Data Cleaning, Row Level Security, Relational Databases Management, Dimensional Modelling.
• Soft skills: Stakeholder Management, Problem Solving, Communication, Logical Reasoning, Questioning Nature, Dataflows, Data Pipelines, Data Validation, Attention to Detail
• Programmes: Power BI, SQL, Microsoft Packages

Desirable Criteria

• Experience of developing informative Business Intelligence that meets the needs of its target audience.
• Able to understand and process changing requirements in a fast‑moving environment.
• Ability to build good, professional relationships, both internally and externally as a representative of Reed In Partnership.
• Technical skills: Snowflake Scheme Design, Kimball Methodology, Star Schemas
• Programmes: Snowflake