Band 5 Reporting Analyst - Trust HQ

Bsmhft; Birmingham; Hybrid; GBP 32,000 - 42,000; Full time

Job summary

Reporting Analyst sought by Birmingham and Solihull Mental Health NHS Foundation Trust to join our Information Team. You will develop and deliver high-quality reports, support clinicians and managers, and contribute to data-driven service improvements.

Responsibilities include sourcing data from trust systems, building dashboards (Power BI), ensuring data quality, and collaborating with internal teams to meet reporting needs across services.

Qualifications

• Experience in a similar reporting role.
• Experience working with stakeholders.
• Knowledge of data quality and validation.

Responsibilities

• Lead key reporting streams and collaborate with clinical services.
• Extract and present data from trust systems and data warehouse.
• Automate routine reports using Power BI.
• Ensure reports meet user requirements and are accurate.

Skills

SQL

Stakeholder management

Analytical thinking

Tools

SQL Server

Power BI

Job description

Please note that this post may close earlier than the indicated closing date if a sufficient number of applications are received.

Job overview

Do you have a passion for using information to help service managers and clinicians deliver effective high-quality services that make a real difference 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.

Working for our organisation

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.

Detailed job description and main 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. If re-opened and you have previously applied, please do not resubmit your application. 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

Our Trust is committed to treating individuals fairly and ensuring they have the same opportunities to fulfil their potential, even if this means doing things differently for different people sometimes. We are working hard to ensure our workforce reflects the diversity within Birmingham and Solihull and that our services meet the needs of all diverse service users and carers.

The Trust is committed to safeguarding and promoting the welfare of children, young people and vulnerable adults and expects all staff and volunteers to share this commitment. As part of our safe recruitment practice pre-employment checks will be undertaken before any appointment is confirmed. As part of the selection process you may be required to undergo a Disclosure and Barring Service (DBS) check, however all cases of criminal record history are dealt with on a case by case basis.

Please note, if applicable for your role you will be required to cover the cost of your DBS certificate. This will be deducted from your salary over 3 months.

All successful applicants will be required to complete the Trust’s induction programme. The Fundamental (Statutory and Mandatory) training will be in an e-learning format. You will be required to complete training modules online (approx. 9-14 hours depending on post) by the end of your second week with us.

If you are successful at the shortlisting stage of the recruitment process we may contact you via email to advise you of the interview details. Please ensure you access your email account from which you applied regularly once the position has closed. Our selection process may involve more than one interview or assessment.

Applications from job seekers who require sponsorship to work in the United Kingdom (UK) are welcome and will be considered alongside all other applications. However, please ensure that you check if this role meets the eligibility criteria for sponsorship. Non UK /Republic of Ireland candidates wishing to apply can self-assess the likelihood of obtaining a Certificate of Sponsorship here Browse: Work in the UK - GOV.UK (www.gov.uk) . The minimum salary threshold for a Health and Social Care is £25,000 and for the Skilled Worker route is £38,700. If the starting salary for this role is below this, we will not be able to provide sponsorship.

Relocation expenses may be reimbursed subject to eligibility. The policy provides for reimbursement up to £8,000.

Please note - if you are applying for a role within Police custody, due to Police Vetting requirements you must have been a UK resident for the last years.

"