Job summary To provide a key role in the Business Intelligence function of the Trust. To work alongside colleagues in setting up new reporting processes to track and report activity data to key stakeholders. Special interest in developing, supporting and improving the Trust's Workforce planning interests and reporting offer to the People directorate. Business Intelligence technical skills are key with knowledge in PowerBI, SSRS and large data warehouses. Main duties of the job The role demands a high level of technical, administrative and communication skills that will support in providing accurate and timely delivery of data to meet internal and external business needs. This will be delivered through the provision of appropriately formatted data sets and reports from which informed decisions can be made The post holder will prepare reports and support the timely execution of the teams reporting schedule. The post holder will work with managers and HR colleagues to identify workforce information requirements of managers and manage the provision of such information. To support and be involved in AWP and BNSSG Workforce System Projects that require working on large profile projects. Responsible for proactive data quality excellence, for a seamless service to employees and service users by running data quality reports. Therefore, experience of ESR Business Intelligence Reporting and MS Excel to manipulate the data extracts for presentation would be highly advantageous. Understanding of National T&C'S (Agenda for Change), NHS Occupational Code Manual and knowledge of Data Protection (GDPR) is required The individual will be well used to a project management style approach, working with new/unfamiliar data and pulling out sensible reporting and KPI structures. Ideally experienced in SQL coding in SSRS and used to working with relational database management structures. About us We are AWP (Avon and Wiltshire Mental Health Partnership NHS Trust) a diverse organisation with over 5,000 dedicated staff providing inpatient and community-based mental health care. We provide services from a range of locations to approximately 1.8 million people living in Bath and North East Somerset (B&NES), Bristol, North Somerset, South Gloucestershire, Swindon, across the county of Wiltshire and in parts of Dorset. Our outstanding people promote mental health and wellbeing. The expertise and resources within AWP are dedicated to a person-centred approach for those who use our services and for all employees. We recognise that happy and fulfilled employees give better care. At AWP we actively encourage applicants from all backgrounds; we are particularly keen to encourage applications from people from Black, Asian and minority ethnic backgrounds, those with disabilities and from the LGBTQ community. We want people to bring their unique blend of experiences, backgrounds, perspectives and knowledge to AWP, as diversity makes us stronger. Date posted 10 March 2025 Pay scheme Agenda for change Band Band 6 Salary £37,338 to £44,962 a year Contract Permanent Working pattern Full-time Reference number 342-CS019-0325 Job locations Bath NHS House Bath BA1 3QE Job description Job responsibilities To develop and provide accurate and timely reports on activity and performance to commissioners, directors, managers and clinicians. Create and develop PowerBI reports to enhance current reporting or support new areas of work. To develop and maintain reports to be run by local staff in support of day-to-day operational activity. To help develop a culture based around the positive use of information for service delivery and service development. To support best practice techniques to uphold data quality and improve timeliness of information across the Trust Within designated areas, to provide an information reporting and analysis service to managers and clinicians to enable monitoring and improvement of their services. Responsible for all information provision within designated areas including maintaining and developing knowledge of specific reporting requirements To provide information, both patient-based and aggregate, to partner organisations within and outside the NHS for planning and commissioning purposes. Support staff with advice on data collection and definitions, in order to support their use of information and of the Trusts new patient administration system (RiO). Liaise with staff in their working environments to align data to their requirements and assist with data quality. To influence the organisational culture to make better use of information. Participate in Trust-wide projects and groups as determined by the Senior Information Analyst. To perform complex analytical tasks from the workforce systems and will support other analysts across the Organisation in their roles by preparing, cleansing, and checking data. Prepare reports and support the timely execution of the teams reporting schedule. Work with managers and HR colleagues to identify workforce information requirements of managers and manage the provision of such information. To support and be involved in AWP and BNSSG Workforce System Projects that require working on large profile projects. Responsible for proactive data quality excellence, for a seamless service to employees and service users by running data quality reports. Job description Job responsibilities To develop and provide accurate and timely reports on activity and performance to commissioners, directors, managers and clinicians. Create and develop PowerBI reports to enhance current reporting or support new areas of work. To develop and maintain reports to be run by local staff in support of day-to-day operational activity. To help develop a culture based around the positive use of information for service delivery and service development. To support best practice techniques to uphold data quality and improve timeliness of information across the Trust Within designated areas, to provide an information reporting and analysis service to managers and clinicians to enable monitoring and improvement of their services. Responsible for all information provision within designated areas including maintaining and developing knowledge of specific reporting requirements To provide information, both patient-based and aggregate, to partner organisations within and outside the NHS for planning and commissioning purposes. Support staff with advice on data collection and definitions, in order to support their use of information and of the Trusts new patient administration system (RiO). Liaise with staff in their working environments to align data to their requirements and assist with data quality. To influence the organisational culture to make better use of information. Participate in Trust-wide projects and groups as determined by the Senior Information Analyst. To perform complex analytical tasks from the workforce systems and will support other analysts across the Organisation in their roles by preparing, cleansing, and checking data. Prepare reports and support the timely execution of the teams reporting schedule. Work with managers and HR colleagues to identify workforce information requirements of managers and manage the provision of such information. To support and be involved in AWP and BNSSG Workforce System Projects that require working on large profile projects. Responsible for proactive data quality excellence, for a seamless service to employees and service users by running data quality reports. Person Specification Qualifications Essential Educated to masters level or equivalent level of experience of working at a similar level in specialist area. Desirable Qualified in or experience of working with relational databases and information reporting packages. Experience Essential Analysing and engaging with Trust operational dat Designing, developing and validating Reporting Services reports Knowledge & experience of NHS informatics, including Mental Health datasets (e.g. MHSDS) Desirable Experience of working with both relational and OLAP databases Experience of writing up test cases and insert test values into UAT environments Skills Essential Ability to grasp complex technical data requirements. Data manipulation and analysis. Well organised with a logical approach Attention to detail. Good written communication skills. Good verbal communication skills An ability to engender confidence in information in staff of the Trust An ability to work in a stressful environment whilst maintaining personal calm and control. Person Specification Qualifications Essential Educated to masters level or equivalent level of experience of working at a similar level in specialist area. Desirable Qualified in or experience of working with relational databases and information reporting packages. Experience Essential Analysing and engaging with Trust operational dat Designing, developing and validating Reporting Services reports Knowledge & experience of NHS informatics, including Mental Health datasets (e.g. MHSDS) Desirable Experience of working with both relational and OLAP databases Experience of writing up test cases and insert test values into UAT environments Skills Essential Ability to grasp complex technical data requirements. Data manipulation and analysis. Well organised with a logical approach Attention to detail. Good written communication skills. Good verbal communication skills An ability to engender confidence in information in staff of the Trust An ability to work in a stressful environment whilst maintaining personal calm and control. 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 details Employer name Avon & Wiltshire Mental Health Partnership NHS Trust Address Bath NHS House Bath BA1 3QE Employer's website http://www.awp.nhs.uk/about-us/working-for-us/ (Opens in a new tab)