Job summary The post holder will be part of team delivering a high-quality business intelligence and analytics function to support Trust services and ensure the Trust has and is using a relevant and effective set of performance measures and indicators, including those prescribed by government and commissioners. The post holder will support the Head of BI by developing, maintaining, and operating reporting services and information systems to produce routine corporate information and reporting outputs in the most effective and efficient manner and within required deadlines. The role requires strong technical skills in data management, business intelligence and analytics, including data modelling and data visualization, and the ability to use data blending and statistical software to create insights. The post holder will use their knowledge of Trust data and business processes, to support research on emerging analytics tools and technologies, as required, and contribute to putting forward options and recommendations on the Trust can take advantage of relevant tools and technologies to become a high-performing insight-driven organisation. To develop appropriate solutions to provide insight into, and to help address Trust performance. Main duties of the job o Interpret complex and routine information requests from across the Trust in line with national and local requirements o Use advanced data analysis techniques, corporate reporting systems and Business Intelligence tools with other members of the team and directorate to design, test and produce appropriate new or updated reporting outputs. o Work to automate and delegate routine delivery of report outputs where appropriate o Develop the BI and information systems to ensure all routine information outputs are delivered on time and quality assured before dissemination and publication o Lead on the delivery of changes to the corporate reporting system using appropriate technical and project management methodologies o Undertake report testing and support transition to new corporate reporting systems or the ingestion of new data feeds into the data warehouse and Trustwide reports o Act as the main point of contact for divisional teams in relation to routine information outputs, highlighting data quality, completeness and/or interpretation issues as appropriate o Investigate data quality issues and highlight these for action, involving relevant Trust staff within and external to the Analytics and wider Digital directorate as needed. About us North London NHS Foundation Trust (NLFT) is committed to improving mental health care across North London to deliver excellent services to our local people. Our Five-Year Strategy: We will provide consistently high-quality care closer to home. With our partners in North London and each borough we will ensure equity of outcome for all We will offer great places to work, providing staff with supportive environment to deliver outstanding care. We will be more effective as an organisation by pioneering research, quality improvement and technology. In order to meet the needs of the Trust you may be required from time to time to work at different locations to your normal place of work. This may mean that you are required to work at any location that fall under Barnet, Camden, Enfield, Haringey or Islington. The Trust reserves the right to require staff to work at such other places or locations as it considers reasonable and necessary on a temporary or permanent basis. Date posted 18 February 2025 Pay scheme Agenda for change Band Band 7 Salary £51,883 to £58,544 a year Per annum including HCAS Contract Permanent Working pattern Full-time Reference number 306-BEH-2616 Job locations St Ann's Hospital St Anns Road London N15 3TH Job description Job responsibilities Responsibility for delivering regular reports in the following areas. This list is not exhaustive and will change and may increase over time as requirements change. National reporting requirements such as the Mental Health Services Data Set and other statutory and commissioning outputs, with additions, enhancements, and changes as appropriate Provision of information to support local reporting specifications set out by ICS and other partners as required, such as activity reporting, Payment by Results, and other commissioning requirements Provision of information to evidence improvements in clinical outcomes Provision of information to inform business planning and cash releasing efficiency savings Provision of information to improve data quality and completeness Provision of information to support the accurate reporting of Referral to Treatment and other related wait times reporting, ad hoc and FOIs Provision of information to support the costing process, both internal and for external purposes including annual reference costs Provision of information to support the contract performance management process specifically referrals data, outpatient, and inpatient flow Provision of information to support inpatient and community services performance management Provision of information to support Commissioning for quality and innovation payment framework (or CQUIN) targets Job description Job responsibilities Responsibility for delivering regular reports in the following areas. This list is not exhaustive and will change and may increase over time as requirements change. National reporting requirements such as the Mental Health Services Data Set and other statutory and commissioning outputs, with additions, enhancements, and changes as appropriate Provision of information to support local reporting specifications set out by ICS and other partners as required, such as activity reporting, Payment by Results, and other commissioning requirements Provision of information to evidence improvements in clinical outcomes Provision of information to inform business planning and cash releasing efficiency savings Provision of information to improve data quality and completeness Provision of information to support the accurate reporting of Referral to Treatment and other related wait times reporting, ad hoc and FOIs Provision of information to support the costing process, both internal and for external purposes including annual reference costs Provision of information to support the contract performance management process specifically referrals data, outpatient, and inpatient flow Provision of information to support inpatient and community services performance management Provision of information to support Commissioning for quality and innovation payment framework (or CQUIN) targets Person Specification Qualifications Essential Educated to degree level or equivalent significant/experience Desirable Membership ApHA / BCS etc Skills/ Abilities Essential High level of software skills, including SQL Server, PowerBI and Excel. Desirable Power BI or SQL Certification Experience/ Knowledge Essential Expert knowledge and understanding of NHS datasets such as the MHSDS Desirable Knowledge of NHS Systems, e.g. Clinical, Finance, HR Personal Qualities Essential Excellent verbal and written communication and interpersonal skills to influence and persuade staff in all roles and at all levels Desirable Ability to manage multiple complex problems in sometimes stressful environments. Person Specification Qualifications Essential Educated to degree level or equivalent significant/experience Desirable Membership ApHA / BCS etc Skills/ Abilities Essential High level of software skills, including SQL Server, PowerBI and Excel. Desirable Power BI or SQL Certification Experience/ Knowledge Essential Expert knowledge and understanding of NHS datasets such as the MHSDS Desirable Knowledge of NHS Systems, e.g. Clinical, Finance, HR Personal Qualities Essential Excellent verbal and written communication and interpersonal skills to influence and persuade staff in all roles and at all levels Desirable Ability to manage multiple complex problems in sometimes stressful environments. 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. Certificate of Sponsorship Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab). From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab). Additional information 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. Certificate of Sponsorship Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab). From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab). Employer details Employer name 306 North London NHS Foundation Trust Address St Ann's Hospital St Anns Road London N15 3TH Employer's website https://www.northlondonmentalhealth.nhs.uk/ (Opens in a new tab)