Data analyst

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 Data 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 data to include for example, Trust referral activity, RTT indicators, service waits, National returns and data from various clinical information systems.


We reserve the right to refuse applications if there is evidence to show that there has been significant input from Artificial Intelligence (AI) technology. 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. 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.


This may involve business and financial planning including formulation and development of options.
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. You could be part of a Trust rated by staff as one of the best mental health and learning disability trusts in England. 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 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.


Whether you're taking the first exciting steps in your career, itching for a new challenge or searching for a better place to raise a family, Lincolnshire has arange of rewarding health and social care careers in a county that's friendly, fascinating, affordable and brimming with everything you need to live a happy life . 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.


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


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


You can extract data from multiple sources for your work and can 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.
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.

Project Management qualification
Qualification in data extraction, analysis or similar

Experience of working with performance management systems and delivering improvement methodologies to a range of stakeholders
Experience of working with senior managers in a range of challenging situations
Experience of training others in the use of systems and in other training or coaching environments

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
Good knowledge of NHS or working within a Performance led organisation or Public Body.

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

Ability to travel independently throughout the county without the use of public transport, to attend meetings and represent the team / organisation in different settings


Lincolnshire Partnership NHS Foundation Trust
Unit 9 The Point