Senior BI Analyst

This job is brought to you by Jobs/Redefined, the UK's leading over-50s age inclusive jobs board.

Thank you for your interest for the North London NHS Foundation Trust (NLFT), it is an exciting time to join us and being part of our journey to improve mental health care across North London and deliver excellent services to our local people. We will achieve this through the North London Way, as we:

• Collaborate at every level by living our Values to create the right conditions for us all to work together.
• Develop our new Trust culture, to help make our new Trust a great place to work and to receive great care.
• Empower our teams to lead the planned improvements in our services, by skilling them and giving them the tools to make the changes.
• Focus on delivering excellence at every level to improve our performance and ensure consistently high-quality care across all our services.
• Ensure that research, Quality Improvement, and technology lead the way and are embedded in our services.
• Take a trauma informed approach to everything we do

We proactively welcome diversity in our workforce and pride ourselves on being an inclusive employer. We aim to recruit from our local communities and provide opportunities to all including apprenticeships, veterans, care leavers and more.

The North London Way to deliver, Better Mental Health, Better Lives, Better Communities.

Our trust website is: https://www.northlondonmentalhealth.nhs.uk/

Job overview

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
• 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.

Working for our organisation

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:

1. We will provide consistently high-quality care closer to home.
2. With our partners in North London and each borough we will ensure equity of outcome for all
3. We will offer great places to work, providing staff with supportive environment to deliver outstanding care.
4. 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.

Detailed job description and main 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 criteria

• Educated to degree level or equivalent significant/experience

Desirable criteria

• Membership ApHA / BCS etc

Skills/ Abilities

Essential criteria

• High level of software skills, including SQL Server, PowerBI and Excel.

Desirable criteria

• Power BI or SQL Certification

Experience/ Knowledge

Essential criteria

• Expert knowledge and understanding of NHS datasets such as the MHSDS

Desirable criteria

• Knowledge of NHS Systems, e.g. Clinical, Finance, HR

Personal Qualities

Essential criteria

• Excellent verbal and written communication and interpersonal skills to influence and persuade staff in all roles and at all levels

Desirable criteria

• Ability to manage multiple complex problems in sometimes stressful environments.

References will be required to cover your last 3 years of employment/training. One has to be from your current or most recent employer and the others from your previous employer. The references should be from persons with management responsibility or HR.

If you have been unemployed for a period of four years or more, please give the details of your last employer and one character referee of your choice (not members of your family). If more applicable, references will be requested from your teacher or head of faculty. Please ensure you provide full contact details.

Vacancies that are advertised as Fixed Term Contracts will also be available as secondment opportunities for substantive internal staff.

Please be aware that your documents eg. Passport/NI Card, will be electronically scanned using Home Office accredited Verification System.

Due to the high number of applications that are received for some posts, we will close vacancies before the stated closing date once the first 50 applications are received. Therefore, please apply as soon as possible.

All non-medical posts with the Trust are subject to a probationary period of six months, during which time you will be required to demonstrate to the Trust's satisfaction, your suitability for the position in which you will be employed.

Should you not hear from us within three working weeks of the closing date for this post, then regretfully in this instance, you have not been shortlisted.

By applying for this role, you accept in the event you are successful that your personal data may be transferred from the Trust to another NHS organisation where your employment transfers within the NHS. This is in accordance with the streamlining programme which is aimed at improving efficiencies within the NHS both to make costs savings for NHS organisations but also to save you time when your employment transfers.

Employer certification / accreditation badges

Applicant requirements

The postholder will have access to vulnerable people in the course of their normal duties and as such this post is subject to the Rehabilitation of Offenders Act 1974 (Exceptions) Order 1975 (Amendment) (England and Wales) Order 2020 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service to check for any previous criminal convictions.

Documents to download

• Senior BI Analyst (PDF, 432.4KB)
• NLFT Functional Requirements (PDF, 536.5KB)