Job summary
The role is key to fulfilling the Finance and Business Intelligence directorate responsibility of creating an environment of efficient, effective, robust data on all aspects of performance to ensure that LCHS meets it national, regional and local reporting obligations and can continuously improve services for patients and populations through insight.
This post will have clear line of site to the patient in creating this essential foundation and environment for insight to inform decision making. This is a key foundation for delivering the 5-year FBI Strategy including creating insight to drive great care close to home.
The role will be part of a team with responsibility for providing technical solutions through development and maintenance of a trust wide Data Warehouse, and work towards delivering a consistent, technical solution for the integration of data from a myriad of clinical information systems. They will contribute to the directorate achieving its strategic objective of automation.
Main duties of the job
Lincolnshire Community Health Service requires all staff to safeguard children, young people and adults. All staff are required to access the organisational policies, also the LocalSafeguarding Children Board and the Local Safeguarding Adults Board policies and procedures that underpin the safeguarding agenda. The safeguarding policies to be followed are found at
www.lincolnshirecommunityhealthservices.nhs.uk and www.lincolnshire.gov.uk
LCHS policies, procedures and guideline - It is a condition of your employment that as an employee you are expected to adhere to our policies, procedures and guidelines. These can all be found on the Trust's website. Responsible for providing specialist support, training and guidance on areas of data warehouse expertise such as database design concepts and reporting and analysis methods.
About us
Lincolnshire Community Health Services NHS Trust is in the top 25 per cent of all community trusts for overall staff engagement in the 2021 NHS National Staff Survey.
At LCHS, we know diversity fosters creativity and innovation. We are committed to equality of opportunity, to being fair and inclusive, and to being a place where all belong. We therefore particularly encourage applications from candidates who are likely to be underrepresented in LCHS' workforce.
LCHS recognises the increasing demand for more flexibility in working practices in order to accommodate the personal goals and commitments that employees experience at different stages during their working lives. Flexible working opportunities such as part-time working, compressed hours, job shares, and hybrid working models can help staff to balance their personal and work commitments. Arrangements can be put in place if it can be shown that the needs of the individual can be balanced with those of the service and the impact on other team members, enabling the Trust to recruit and retain skilled staff, raise staff morale, reduce absenteeism and respond to changing service needs more effectively.
We are an ambassador of a learning culture that will support the right individual to progress in their chosen career through an 'earn while you learn' apprenticeship programme. Visit our Learning and Development page to find out more https://www.lincolnshirecommunityhealthservices.nhs.uk/join-us/learning-and-dev
Job description
Job responsibilities
Work towards being responsible for working with the team to continually automate by identifying areas of need/opportunity and helping to develop and implement solutions, and streamline procedures for extracting and processing regular data.
Work towards training others on information gathering and analysis, and to develop datasets to support national reporting requirements, standards and timeframes.
Work towards being the analytical lead and make recommendations about the performance of specific complex queries, including proposing, developing and introducing new systems for reporting and training.
Work towards leading in the analysis and interpretation of activity and information produced and manipulate raw data in order to present information in a format suitable to a variety of internal and external audiences to demonstrate the Trusts activity and performance
To advise, in conjunction with others, on data quality within the organisation; recommend changes and new reports in areas identified as critical to the organisation.
Work towards developing effective reporting and management tools to inform the LCHS on the Key Performance Indicators and information analysis.
To proactively review changes in the NHS data collection measures and new guidance and returns, and work towards identifying areas of risk to the organisation.
In conjunction with FBI colleagues, particularly in the operational area, work towards supporting the collation and submission of statutory returns and other organisation reports, ensuring accuracy and disseminating useful conclusions and information.
Work towards leading on the NHS Data Model and Dictionary for England and assist other team members to develop a working knowledge.
Work towards designing, developing and implementing LCHS wide processes, to support the flow of information and the delivery of targets
Work towards dealing with agreed as well as unpredictable, ad hoc requests using varied datasets, from all levels including senior leaders to achieve organisational objectives.
Job description
Job responsibilities
Work towards being responsible for working with the team to continually automate by identifying areas of need/opportunity and helping to develop and implement solutions, and streamline procedures for extracting and processing regular data.
Work towards training others on information gathering and analysis, and to develop datasets to support national reporting requirements, standards and timeframes.
Work towards being the analytical lead and make recommendations about the performance of specific complex queries, including proposing, developing and introducing new systems for reporting and training.
Work towards leading in the analysis and interpretation of activity and information produced and manipulate raw data in order to present information in a format suitable to a variety of internal and external audiences to demonstrate the Trusts activity and performance
To advise, in conjunction with others, on data quality within the organisation; recommend changes and new reports in areas identified as critical to the organisation.
Work towards developing effective reporting and management tools to inform the LCHS on the Key Performance Indicators and information analysis.
To proactively review changes in the NHS data collection measures and new guidance and returns, and work towards identifying areas of risk to the organisation.
In conjunction with FBI colleagues, particularly in the operational area, work towards supporting the collation and submission of statutory returns and other organisation reports, ensuring accuracy and disseminating useful conclusions and information.
Work towards leading on the NHS Data Model and Dictionary for England and assist other team members to develop a working knowledge.
Work towards designing, developing and implementing LCHS wide processes, to support the flow of information and the delivery of targets
Work towards dealing with agreed as well as unpredictable, ad hoc requests using varied datasets, from all levels including senior leaders to achieve organisational objectives.
Person Specification
Qualifications
Essential
- oDegree level qualification or equivalent qualification/experience
- oEvidence of recent relevant CPD
- oSpecialist knowledge in a relevant field
Skills
Essential
- oBe able to work autonomously and under pressure to meet strict deadlines.
- oTechnically skilled working towards an advanced level with specialised technical skills including SQL Server, report building, MS Excel, analytical skills and a knowledge of displaying information visually, e.g. dashboards.
- oAbility to demonstrate pragmatic decision making when evaluating data and trends
- oDemonstrates accountability and ownership of work duties and activities and carries them out with accuracy, integrity, and customer focus
- oA high degree of customer service focus including with clinicians, senior leaders, external stakeholders
Knowledge
Essential
- Working towards IT literacy to an expert level including proven knowledge and skills in Microsoft Database environments (SQL), Business intelligence systems (e.g. Qlikview), and systems programming languages gained through courses
- Working towards gaining knowledge of mandatory reports, performance metrics, NHS currency and activity.
- Working towards gaining extensive knowledge and experience of working in an information team, understanding Information Standards, Performance Targets, dataset production to Data Dictionary standards and SLA monitoring
Desirable
- oHave in depth knowledge of large data structures ideally NHS information systems.
- Knowledge of the NHS Data Dictionary and an understanding of NHS performance indicators and quality standards and an understanding of national tariff and payments by results.
Experience
Essential
- Experience in statistical analysis and presentation techniques and have a solid understanding of research methodologies and data validation techniques.
- Contract management experience and associated data flows
- Experience of working with NHS data sets, advanced SQL and query writing skills, experience of using Power BI and DAX Scripting or equivalent.
Specific Requirements
Essential
- Ability to travel across the county Excellent interpersonal skills including verbal and written communication and presentation skills
Person Specification
Qualifications
Essential
- oDegree level qualification or equivalent qualification/experience
- oEvidence of recent relevant CPD
- oSpecialist knowledge in a relevant field
Skills
Essential
- oBe able to work autonomously and under pressure to meet strict deadlines.
- oTechnically skilled working towards an advanced level with specialised technical skills including SQL Server, report building, MS Excel, analytical skills and a knowledge of displaying information visually, e.g. dashboards.
- oAbility to demonstrate pragmatic decision making when evaluating data and trends
- oDemonstrates accountability and ownership of work duties and activities and carries them out with accuracy, integrity, and customer focus
- oA high degree of customer service focus including with clinicians, senior leaders, external stakeholders
Knowledge
Essential
- Working towards IT literacy to an expert level including proven knowledge and skills in Microsoft Database environments (SQL), Business intelligence systems (e.g. Qlikview), and systems programming languages gained through courses
- Working towards gaining knowledge of mandatory reports, performance metrics, NHS currency and activity.
- Working towards gaining extensive knowledge and experience of working in an information team, understanding Information Standards, Performance Targets, dataset production to Data Dictionary standards and SLA monitoring
Desirable
- oHave in depth knowledge of large data structures ideally NHS information systems.
- Knowledge of the NHS Data Dictionary and an understanding of NHS performance indicators and quality standards and an understanding of national tariff and payments by results.
Experience
Essential
- Experience in statistical analysis and presentation techniques and have a solid understanding of research methodologies and data validation techniques.
- Contract management experience and associated data flows
- Experience of working with NHS data sets, advanced SQL and query writing skills, experience of using Power BI and DAX Scripting or equivalent.
Specific Requirements
Essential
- Ability to travel across the county Excellent interpersonal skills including verbal and written communication and presentation skills
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).
