Band 5 Reporting Analyst - Trust HQ

Job summary

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 andservices to help meet this challenge.

We are looking for a proactive and enthusiastic Reporting Analyst to join us and make substantialcontributions to this work. In this role you will be part of a team working to gain detailed understanding of services' activities, issues andchallenges and then providing high quality analytical support and insights. You will ensure that all regular reports and data sets are delivered ontime and to specification, carry out individual pieces of analysis, participate in projects to extend reporting capability, automate production ofroutine 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.

Last verified against our ingestion on 28 October 2026; sponsor register dataset 2026-10-28.