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 Business Support 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, 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 analysis and develop methods to collect, collate and evaluate quantitative and qualitative 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.
Under supervision, assist with the development of predictive forecasting methodologies to inform and drive strategy and its deliverables.
Communicating and presenting relevant and 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
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 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 analysis and develop methods to collect, collate and evaluate quantitative and qualitative 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,
Under supervision, assist with the development of predictive forecasting methodologies to inform and drive strategy and its deliverables.
Communicating and presenting relevant and 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.
Understand whether data is fit for purpose and can sense check data and analysis
Recognise basic issues of data quality and can take action with guidance to prevent or counteract them
Perform data extraction and manipulation under guidance
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.
Maintain regular reporting requirements utilising all available technologies and data analysis tools.
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.
Understand the importance of performance measurement to the business and its objective
Job description
Job responsibilities
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 analysis and develop methods to collect, collate and evaluate quantitative and qualitative 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,
Under supervision, assist with the development of predictive forecasting methodologies to inform and drive strategy and its deliverables.
Communicating and presenting relevant and 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.
Understand whether data is fit for purpose and can sense check data and analysis
Recognise basic issues of data quality and can take action with guidance to prevent or counteract them
Perform data extraction and manipulation under guidance
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.
Maintain regular reporting requirements utilising all available technologies and data analysis tools.
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.
Understand the importance of performance measurement to the business and its objective
Person Specification
Qualifications
Essential
- Educated to A level standard or equivalent experience
- English - level 2 or above
- Maths - level 2 and above
- Computer Literacy
Desirable
Experience
Essential
- Experience in all aspects of office administration, systems and processes.
- Experience of working with data which is transmitted and stored electronically.
- Working knowledge and experience of one or more of the following - finance related work, payroll, customer service environment, complaints, training or human resources.
- Experience of liaising with other staff and outside organisations together with the ability to deal with queries.
- Experience of working with staff at all levels.
Desirable
- Experience of NHS, Public Sector, or large organisation
- Experience of working within an Information or performance Department
Skills
Essential
- Knowledge and proven skills in using SQL
- Excellent knowledge and proven skills in using Excel.
- Considerable knowledge and proven skills in using other Office 365 packages
- Ability to produce and present complex information in a clear and professional manner.
- Experience of producing data whilst adhering to specific technical guidance and definitions.
- Appreciation of security and confidentiality within the NHS in relation to patient sensitive information.
- Proficient in the use of Microsoft Office 365 Applications
- Knowledge of data analysis and associated software/computer systems acquired through diploma or equivalent experience/qualification.
- Ability to use initiative to identify issues, resolve problems or concerns and to know when to refer onwards.
- Able to focus on own work in a busy environment. Able to communicate clearly by email, on the telephone and face to face
- Able to use existing skills/knowledge to complete unfamiliar tasks e.g. use of additional/new data base modules, setting up meetings.
- Able to utilise new technology and apply it to a range of tasks
- Ability to prioritise own workload and change priorities to meet the needs of the wider BI Team.
- To be flexible in approach to work and skills/training needs, updating as needed.
- To be methodical, accurate, and able to work systematically with attention to detail striving towards 100% accuracy particularly in respect of data entry.
- Ability to maintain confidentiality and follow/understand Trust policies and procedures.
Person Specification
Qualifications
Essential
- Educated to A level standard or equivalent experience
- English - level 2 or above
- Maths - level 2 and above
- Computer Literacy
Desirable
Experience
Essential
- Experience in all aspects of office administration, systems and processes.
- Experience of working with data which is transmitted and stored electronically.
- Working knowledge and experience of one or more of the following - finance related work, payroll, customer service environment, complaints, training or human resources.
- Experience of liaising with other staff and outside organisations together with the ability to deal with queries.
- Experience of working with staff at all levels.
Desirable
- Experience of NHS, Public Sector, or large organisation
- Experience of working within an Information or performance Department
Skills
Essential
- Knowledge and proven skills in using SQL
- Excellent knowledge and proven skills in using Excel.
- Considerable knowledge and proven skills in using other Office 365 packages
- Ability to produce and present complex information in a clear and professional manner.
- Experience of producing data whilst adhering to specific technical guidance and definitions.
- Appreciation of security and confidentiality within the NHS in relation to patient sensitive information.
- Proficient in the use of Microsoft Office 365 Applications
- Knowledge of data analysis and associated software/computer systems acquired through diploma or equivalent experience/qualification.
- Ability to use initiative to identify issues, resolve problems or concerns and to know when to refer onwards.
- Able to focus on own work in a busy environment. Able to communicate clearly by email, on the telephone and face to face
- Able to use existing skills/knowledge to complete unfamiliar tasks e.g. use of additional/new data base modules, setting up meetings.
- Able to utilise new technology and apply it to a range of tasks
- Ability to prioritise own workload and change priorities to meet the needs of the wider BI Team.
- To be flexible in approach to work and skills/training needs, updating as needed.
- To be methodical, accurate, and able to work systematically with attention to detail striving towards 100% accuracy particularly in respect of data entry.
- Ability to maintain confidentiality and follow/understand Trust policies and procedures.
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.
