Job summary
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 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.
Specialised technical skills and analytical skills are required for this post, along with knowledge and experience of working in an Information team. Candidates must have strong communication and presentation skills.
We reserve the right to refuse applications if there is evidence to show that there has been significant input from Artificial Intelligence (AI) technology. Applications should be a true reflection of the applicants knowledge, skills and experience.
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,900 staff, and serving a population of over 768,400, 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. 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 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.Visitbeinlincolnshire.comto find out more.
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
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.
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
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.
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
- Good knowledge of NHS or working within a Performance led organisation or Public Body.
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
- Ability to travel independently throughout the county without the use of public transport, to attend meetings and represent the team / organisation in different settings
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
- Good knowledge of NHS or working within a Performance led organisation or Public Body.
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
- Ability to travel independently throughout the county without the use of public transport, to attend meetings and represent the team / organisation in different settings
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.
