Band 5 Reporting Analyst - Trust HQ

Birmingham and Solihull Mental Health NHS Foundation Trust; Birmingham; Hybrid; GBP 32,000 - 39,000; Full time

Job summary

Birmingham and Solihull Mental Health NHS Foundation Trust is seeking a Band 5 Reporting Analyst at Trust HQ to support analytical services, deliver reports on time, and develop reporting capability.

You will lead reporting streams, work with SQL Server, data warehouse and Power BI to help clinicians and managers access information to improve services.

Qualifications

• Work experience in a related role.
• Evidence of using relevant software.
• Evidence of work experience with information management and reporting.

Responsibilities

• Lead key reporting streams and collaborate with clinical services and internal teams.
• Use SQL Server to extract, manipulate and present data from trust systems and data warehouse.
• Automate regular reporting processes, primarily with Power BI.
• Ensure reports meet user requirements with validation and clear presentation.

Skills

Analytical skills

Stakeholder engagement

Tools

Software experience

Job description

Birmingham and Solihull Mental Health NHS Foundation Trust

Band 5 Reporting Analyst - Trust HQ

The closing date is 09 November 2026

Do you have a passion for using information to help service managers and clinicians deliver effective high-quality services that make a realdifference to service users and carers?

Our Information Team works closely with operational services, delivering analytical support and continuously developing reporting systems and services to help meet this challenge.

We are looking for a proactive and enthusiastic Reporting Analyst to join us and make substantial contributions to this work. In this role you will be part of a team working to gain detailed understanding of services' activities, issues and challenges and then providing high quality analytical support and insights. You will ensure that all regular reports and data sets are delivered on time and to specification, carry out individual pieces of analysis, participate in projects to extend reporting capability, automate production of routine reports and data sets, and increase the availability and accessibility of information to clinicians and managers.

Main duties of the job

The post-holder would take lead responsibility for a number of key reporting streams, but with an expectation to flexibly work closely with a range of clinical services and internal teams across our information department.

Aspects of the role include:

- Using SQL Server to extract, manipulate and present information from trust systems and the data warehouse on both a routine and ad-hoc basis to meet regular and one-off information requirements.
- Maintain an understanding of all major areas of analysis carried out by the trust and produce routine and ad-hoc reports in other areas to cover staff absences.
- Identify weaknesses in information systems data flows and data and work with appropriate staff and agencies to ensure identified problems are resolved.
- Design and use appropriate validation mechanisms and checking routines to ensure that all reports produced meet the user's requirements and are accurate, reliable and clearly presented.
- Facilitate the automation of regular reporting processes, primarily within Power BI, for our internal intranet reporting system and maintain documentation of such procedures. Design, maintain and adapt other information reporting systems to meet changing internal and external information requirements.

About us

Welcome to Birmingham and Solihull Mental Health NHS Foundation Trust. Our 4,000 clinical and support staff help us to improve mental health wellbeing and meet the needs of the 70,000 people we serve each year. We provide a range of mental healthcare services across Birmingham and Solihull, as well as specialised services nationally. We also offer medical, nursing and psychology training and are proud of our international reputation for both research and innovation.

Our population is culturally diverse, characterised in places by high levels of deprivation which create an increasing demand for our services and a necessity for us to make sure everyone can access the help they need. We are a team of compassionate, inclusive and committed people working together to provide excellent care to support our community. If you are looking for a place to belong, where you can make a real difference to people's lives, join our team where our warm welcome is waiting for you.

Job responsibilities

For further information about the main responsibilities please view the attached job description and person specification.

The advert will be open for two weeks but will close earlier based on the number of applications received. However, the advert may be re-opened if there are not a sufficient number of appropriate candidates to progress to interview. Shortlisting and interview dates are an estimate and will be contingent upon when we reach the quota of people to invite to interview.

We are unable to support applications from job seekers who require sponsorship to work the United Kingdom (UK)

This role gives the opportunity for hybrid working and you will typically be asked to work in a hybrid way, working from your home and also from Trust HQ The Uffculme Centre, or any other agreed site.

Person Specification

Qualifications

Analytical skills and experience

• work experience in related role

Technical skills

• evidence of using relevant software
• evidence of working with stakeholders

Information management and reporting

• evidence of work experience

Disclosure and Barring Service Check

This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.

Employer name

Birmingham and Solihull Mental Health NHS Foundation Trust

£32,073 to £39,043 a yearper annum, pro rata