Band 4 Information Assistant

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

Job summary

A mental health service provider in Birmingham is seeking an Information Assistant to extract and analyze data to support service delivery. This role involves producing regular reports and ensuring data accuracy. The ideal candidate will have 5 GCSEs and 2 A Levels, alongside strong numeracy and communication skills. This position offers the opportunity for hybrid working and provides a Level 4 Data Analyst Apprenticeship. Salary ranges from £27,485 to £30,162 pro rata.

Qualifications

• Experience of extracting data from relational database systems and producing summary reports.
• Knowledge of NHS & Social Care practices and data standards.

Responsibilities

• Extract, manipulate, and present information from systems and data warehouse.
• Produce routine and ad‑hoc reports and analysis.
• Identify weaknesses in data and ensure issues are resolved.
• Document procedures and maintain effective records.

Skills

High degree of numeracy

Verbal communication skills

Written communication skills

Use of software tools to query databases

Advanced use of MS Excel

Use of SQL query language

Use of MS Power BI

Education

5 GCSEs including Maths and English

2 A Levels at grade C or above

Relevant degree or other related training

Tools

SQL

MS Power BI

RiO or other clinical electronic patient record systems

Job description

Go back Birmingham and Solihull Mental Health NHS Foundation Trust

Band 4 Information Assistant

The closing date is 13 January 2026

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 person to 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.

The successful candidate would be given the opportunity to complete a Level 4 Data Analyst Apprenticeship as part of the role.

Main duties of the job

Extract, manipulate and present information from information systems and the Trust data warehouse on both a routine and ad‑hoc basis to meet regular and one‑off information requirements.

Maintain a good understanding of all major areas of analysis.

Produce routine and ad‑hoc reports and analysis.

Identify weaknesses in information systems data and data flows 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.

Document procedures, and keep effective records of all key internal and external returns.

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.

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 Uffculme Centre, or any other agreed site.

Person Specification

Qualifications

• 5 GCSE (incl Maths and English) and 2 A Levels at grade C or above
• Relevant degree of other related training

Experience

• Experience of extracting data from relational database systems, manipulating, and analysing data and producing summary reports.
• Knowledge of NHS & Social Care practices, data definitions and data standards

Skills/Knowledge

• High degree of numeracy, verbal, and written communication skills.
• Use of software tools to query databases and advanced use of MS Excel.
• Use of SQL query language, MS Power BI or other reporting tools.
• Use of RiO or other clinical electronic patient record systems.

Personal Qualities

• Logical and analytical approach to problem-solving. High level of attention to detail and adaptability.
• Produce high quality work to tight timescales and an ability to prioritise.
• Team player, willing to work flexible with others incl. analysts as well as clinical colleagues.

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.

Birmingham and Solihull Mental Health NHS Foundation Trust

£27,485 to £30,162 a year pro rata