Senior BI Analyst

Job Summary

The post holder will be part of a 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 how 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

• Interpret complex and routine information requests from across the Trust in line with national and local requirements.
• 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.
• Work to automate and delegate routine delivery of report outputs where appropriate.
• Develop the BI and information systems to ensure all routine information outputs are delivered on time and quality assured before dissemination and publication.
• Lead on the delivery of changes to the corporate reporting system using appropriate technical and project management methodologies.
• 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.
• 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.
• 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 a supportive environment to deliver outstanding care.
• We will be more effective as an organisation by pioneering research, quality improvement and technology.

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.

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. #J-18808-Ljbffr