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