Senior BI Analyst

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.

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

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

• 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

• Educated to degree level or equivalent significant/experience

• Membership ApHA / BCS etc

Skills/ Abilities

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

• Power BI or SQL Certification

Experience/ Knowledge

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

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

Personal Qualities

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

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