Are you highly motivated, reliable and enthusiastic? Are you interested in working within a data driven NHS trust using data and subsequent analysis to improve service provision for you local community?

Due to recent expansion and as part of significant investment into Digital and Data Services at Lincolnshire Partnership NHS Foundation Trust (LPFT), various exciting opportunities have arisen to join the Data Services team.

We are seeking to recruit a reliable, organised and passionate individual to Data Services team as a Business Intellegence Analyst . The successful candidate will work on a wide range of reporting and analysis including statutory returns, national and local key performance indicators, and performance monitoring. This includes running reports and analysis of all Trust dats to include for example, Trust referral activity, RTT indicators, service waits, National returns and data from various clinical information systems.

Specialised technical skills and analytical skills are required for this post, along with knowledge and experience of working in an Information team, understanding Information Standards and performance targets

Main duties of the job

Handling and creating datasets by using business intelligence tools, raw data, SQL queries and data mining techniques to clean, process, interrogate, analyse, and visualise data in an effective and informative manner in the most efficient way possible.

Conducting expert and advanced analysis and develop methods to collect, collate and evaluate quantitative and qualitative highly complex and sensitive data using appropriate query tools for people team reporting and modelling.

Communicating and presenting complex and highly sensitive data and analysis effectively at all levels and to both internal and external stakeholders and sponsors, to both technical and non-technical audiences both verbally and in writing. Ensuring the information provided is accessible and understandable to a wide audience and conforms to high standards

Delivering timely and targeted suite of reports and dashboards in a robust method, which analyse trends over time, shows comparisons of data and encompasses appropriate statistical methods and forecasts of performance. Ensures the accurate delivery of all commentary which forms part of quality information.

Analyse complex and patient sensitive data to show Trust trends and identify and highlight any areas of significance.

Under supervision, develop complex predictive forecasting methodologies to inform and drive strategy and its deliverables. This may involve business and financial planning including formulation and development of options.

About us

Lincolnshire Partnership NHS Foundation Trust provides mental health services and a number of learning disability, autism and social care services in the county of Lincolnshire. Employing around 2,800 staff, and serving a population of over 766,000, our people lie at the heart of everything we do.

You could be part of a Trust rated by staff as one of the best mental health and learning disability trusts in England, in an area heralded as a fantastic place to live and work. We firmly believe the key to high quality care is a contented workforce. This is reflected in our Care Quality Commission rating of 'outstanding' for well-led and 'good' overall. In the most recent National NHS Staff Survey, our staff rated us as the number one trust nationally for staff morale and one of the top scoring NHS Trusts in the Midlands for being compassionate and inclusive. We're really proud of this!

We are also leading the way in transforming care, with multi-million-pound transformation of patient environments and radical redesign of community services.

This is the time to join and help redesign our services of the future. We offer options for flexible working and provide a wide range of training and promotion opportunities in all professions. We support and celebrate diversity, have active staff networks groups and are always looking at what more we can do to support our staff.

Job description

Job responsibilities

Handling and creating complex datasets by using business intelligence tools, raw data, SQL queries and data mining techniques to clean, process, interrogate, analyse, and visualise data in an effective and informative manner in the most efficient way possible.

Conducting expert and advanced analysis and develop methods to collect, collate and evaluate quantitative and qualitative highly complex and sensitive data using appropriate query tools for people team reporting and modelling.

The creation and maintenance of analysis, reports and dashboards that support delivery, functions and decision making across Lincolnshire Partnership NHS Foundation Trust, working with specific teams and liaising with all business areas as required.

Under supervision, develop complex predictive forecasting methodologies to inform and drive strategy and its deliverables. This may involve business and financial planning including formulation and development of options.

Communicating and presenting complex and highly sensitive data and analysis effectively at all levels and to both internal and external stakeholders and sponsors, to both technical and non-technical audiences both verbally and in writing. Ensuring the information provided is accessible and understandable to a wide audience and conforms to high standards

Delivering timely and targeted suite of reports and dashboards in a robust method, which analyse trends over time, shows comparisons of data and encompasses appropriate statistical methods and forecasts of performance. Ensures the accurate delivery of all commentary which forms part of quality information.

Respond to ad-hoc requests for information, including Freedom of Information (FOI) requests, as directed. Utilise available technologies and software to present the information in an appropriate format.

Analyse complex and patient sensitive data to show Trust trends and identify and highlight any areas of significance. Investigate any outlying areas using own initiative.

Develop and produce timely and accurate information and performance reports and analysis to support operational decision-making, resulting in provision of better care provided to service users utilising all available technologies and data analysis tools.

Whilst carrying out reporting, identify and investigate inconsistencies in data to improve data quality, which will enhance Trust performance.

Communicate reports to non-statisticians explaining the detail which may be complex, but in an easy to understand manner, using a range of techniques to convey the content.

This role will be required to liaise and work with other corporate departments to help develop a range of clinical and business analytical reports for all Divisions across the Trust as required.

Maintain complete confidentiality of sensitive information relating to patients, other members of staff in line with Caldicott and GDPR.

To provide other functions appropriate to the grade and role which may become necessary to meet the needs of the Business Intelligence Team.

Use of SQL daily to extract data from the Trusts Business Intelligence solution/data warehouse.

Frequent use of Trusts Patient Administration Systems (PAS), Electronic Patient Records (EPR) and other clinical information systems to assist in data analysis and investigation.

Reverse-engineer existing analyses and replicate the method and results

Participate in discussions determining which performance measures are appropriate and can turn business needs and goals into performance measures

Extract data from multiple sources and identify if the data is accurate and fit for purpose

Employ a number of problem solving techniques (e.g. root cause analysis) to identify the reason for unexpected problems with routines, and utilise a range of skills to solve these.

Person Specification

Qualifications

Essential

• Educated to degree level or equivalent level of experience of working in a Business Intelligence / information or performance or related area.
• Evidence of continuous professional development in the form of courses or similar in areas related to BI and management and communication.

Desirable

• Project Management qualification
• Qualification in data extraction, analysis or similar

Experience

Essential

• Experience of working with performance management systems and delivering improvement methodologies to a range of stakeholders
• Experience in the production of reports for management teams
• Experience with a range of clinical and information management systems
• Experience of working with senior managers in a range of challenging situations
• Experience of presenting information to colleagues and other stakeholders in a variety of formats
• Experience of training others in the use of systems and in other training or coaching environments

Desirable

• Experience of working in Mental Health

Skills

Essential

• Proficient in the use of Microsoft Office 365 Applications
• Microsoft SQL training or equivalent experience in SQL
• Preparing and writing of reports that can be presented to a variety of audiences
• Ability to analyse and interpret data and information and highlight areas for further investigation
• Excellent organisational/time management skills
• Ability to work in a structured and systematic manner but respond rapidly to changes in priorities
• Proven communication and interpersonal skills
• Able to adapt to rapid change in a positive way and support colleagues through such changes
• Able to work well under pressure while still delivering high quality work
• Good knowledge of NHS or working within a Performance led organisation or Public Body.
• Ability to work on own initiative and manage own time effectively to achieve deadlines and meet competing demands
• Ability to travel independently throughout the county without the use of public transport, to attend meetings and represent the team / organisation in different settings
• Ability to be flexible when and if required

Desirable

• Knowledge of using Reporting Service and/or other reporting tools including Power BI
• Knowledge of NHS Performance targets and data definitions

Special requirements

Essential

• Demonstrate Trust Values for example You will promote the relevant professional values at all times and demonstrate compassion for yourself and colleagues. You are able to demonstrate mindfulness of other people's pressures and priorities. You actively engage with members of the department in an enthusiastic but patient manner.

Employer details

Employer name

Lincolnshire Partnership NHS Foundation Trust

Address

Unit 9, The Point

Lions Way

Sleaford

NG34 8GG

Any attachments will be accessible after you click to apply.

274-10267-COR