Job summary
Lewisham and Greenwich NHS Trust is wholly committed to maintaining our leading position in the use of information technology to support the delivery of high quality patient care to the people of Lewisham and Greenwich.
We operate two hospitals with a modern network, hospital information system, PACS, and a wide range of supporting IT systems.
An exciting opportunity has arisen in our Information Directorate for a Band 8a Deputy Head of Information Systems on a 9 month Fixed Term Contract. You will work with the Head of Information Systems and Data Warehouse to support all aspects of the data administration and Data Warehouse function across the Trust.
Main duties of the job
You will use a wide range of applications and tools to facilitate your daily tasks, including Microsoft SQL Server 2019, Microsoft Visual Studio, VB.Net, and Microsoft Office products, as well as the IQVIA ETL application.
About us
Our people are our greatest asset. When we feel supported and happy at work, this positivity reaches those very people we are here for, the patients. Engaged employees perform at their best and our Equality, Diversity & Inclusion (EDI) initiatives contribute to cultivate a culture of engagement. We have four staff networks, a corporate EDI Team and a suite of programmes and events which aim to insert the 5 aspirations:
- Improving representation at senior levels of staff with disabilities, from black, Asian, and ethnic minorities background, identify as LGBTQ+ and women, through improved recruitment and leadership development
- Widening access (anchor institution) and employability
- Improving the experience of staff with disability
- Improving the EDI literacy and confidence of trust staff through training and development
- Making equalities mainstream
Job description
Job responsibilities
KEY RESPONSIBILITIES
- Strategy & Policy
- Ensure the Data Warehouse and associated Information Systems are able to meet the data processing and data provision needed to support the Trust strategic objectives.
- Supporting colleague to ensure that a robust and comprehensive Data Quality is in place across the whole organisation, based on current and as required new guidelines and national policy.
- Work with colleagues with IT / EPR Team to develop a Data Extract strategy to support the move to a whole Trust EPR solution.
- Operational
- Engage in the development and on-going maintenance of a Trust wide Data Warehouse solution, building on current provision whilst ensuring that the solution meets the Trust strategic direction.
- Manage the Data Warehouse Developer to design, build and develop further automated processes for data extracts and data reporting.
- Manage the on-going development and local support of the Data Warehouse solution.
- Support the development of any processes necessary to convert legacy data into formats that meet the nationally and locally required formats to allow them to be loaded into the Data Warehouse solution.
- Develop and manage the data production schedules with the Trust Business Intelligence teams to ensure that required deadlines are met.
- Manage the on-going development and maintenance of required processes regarding the production of routine reports (automated), data storage requirements (volume and housekeeping) and data retrieval processes.
- Ensure the required processes and policies are in place to support the operational management of the Data Warehouse and the staff managing it.
- Working with the wider team to ensure that the data required for Commissioning purposes (CDS, SUS, other patient level datasets) is complete, submitted regularly in line with national and local timescales.
- Ensure that Trusts data definitions are in line with the NHS Data Dictionary and Data Manual, that definitions are used consistently across areas and systems and that data is collected (and hence available for reporting purposes) in a timely manner.
- Financial and Physical Resources
- Engage in the preparation of Business Cases as required to support projects of system developments.
- Work within the Trusts Standing Financial Instructions at all time
- Workforce Management
- Manage staff within the section according to Trust policy and procedures at all times
- Manage any performance or sickness issues of staff in accordance with Trust policy and procedures.
- Manage the recruitment of staff as enquired.
- Ensure staff within the section meet KSF / PDR requirements, that all staff have a PDR in place setting out performance and delivery objectives that also meet the departmental and Trust objectives.
- Planning, Organisation and Development
- Represent the Department / Trust at internal and external meetings as required.
- Attend training and User Groups at external locations as required
- Undertake appropriate professional development associated with the post.
Job description
Job responsibilities
KEY RESPONSIBILITIES
- Strategy & Policy
- Ensure the Data Warehouse and associated Information Systems are able to meet the data processing and data provision needed to support the Trust strategic objectives.
- Supporting colleague to ensure that a robust and comprehensive Data Quality is in place across the whole organisation, based on current and as required new guidelines and national policy.
- Work with colleagues with IT / EPR Team to develop a Data Extract strategy to support the move to a whole Trust EPR solution.
- Operational
- Engage in the development and on-going maintenance of a Trust wide Data Warehouse solution, building on current provision whilst ensuring that the solution meets the Trust strategic direction.
- Manage the Data Warehouse Developer to design, build and develop further automated processes for data extracts and data reporting.
- Manage the on-going development and local support of the Data Warehouse solution.
- Support the development of any processes necessary to convert legacy data into formats that meet the nationally and locally required formats to allow them to be loaded into the Data Warehouse solution.
- Develop and manage the data production schedules with the Trust Business Intelligence teams to ensure that required deadlines are met.
- Manage the on-going development and maintenance of required processes regarding the production of routine reports (automated), data storage requirements (volume and housekeeping) and data retrieval processes.
- Ensure the required processes and policies are in place to support the operational management of the Data Warehouse and the staff managing it.
- Working with the wider team to ensure that the data required for Commissioning purposes (CDS, SUS, other patient level datasets) is complete, submitted regularly in line with national and local timescales.
- Ensure that Trusts data definitions are in line with the NHS Data Dictionary and Data Manual, that definitions are used consistently across areas and systems and that data is collected (and hence available for reporting purposes) in a timely manner.
- Financial and Physical Resources
- Engage in the preparation of Business Cases as required to support projects of system developments.
- Work within the Trusts Standing Financial Instructions at all time
- Workforce Management
- Manage staff within the section according to Trust policy and procedures at all times
- Manage any performance or sickness issues of staff in accordance with Trust policy and procedures.
- Manage the recruitment of staff as enquired.
- Ensure staff within the section meet KSF / PDR requirements, that all staff have a PDR in place setting out performance and delivery objectives that also meet the departmental and Trust objectives.
- Planning, Organisation and Development
- Represent the Department / Trust at internal and external meetings as required.
- Attend training and User Groups at external locations as required
- Undertake appropriate professional development associated with the post.
Person Specification
Qualifications
Essential
- Degree in Maths or Computer related subject.
- Significant experience in data warehouse development role
Desirable
- Project Management qualification
- Master level degree in Maths or Computer related subject.
Experience
Essential
- Extensive experience of working in data management within the NHS
- Extensive experience of relational database management MS 2016/2019/2022
- Extensive experience of Visual Studio (SSIS)
- Writing professional presentation reports.
- Managing SUS submission process.
Desirable
- Developing a data warehouse across a multi-site NHS acute Trust
- Experience OF managing staff.
- Managing supplier relationships.
Knowledge
Essential
- Advanced knowledge of Microsoft products inc. Office, SQL, VS(SSIS)
- Understanding database theory
- Data Protection Act and other statutory regulations.
Desirable
- NHS Data change process ISNs
- Understanding NHS PbR and HRGs
- Business Cases preparation.
Person Specification
Qualifications
Essential
- Degree in Maths or Computer related subject.
- Significant experience in data warehouse development role
Desirable
- Project Management qualification
- Master level degree in Maths or Computer related subject.
Experience
Essential
- Extensive experience of working in data management within the NHS
- Extensive experience of relational database management MS 2016/2019/2022
- Extensive experience of Visual Studio (SSIS)
- Writing professional presentation reports.
- Managing SUS submission process.
Desirable
- Developing a data warehouse across a multi-site NHS acute Trust
- Experience OF managing staff.
- Managing supplier relationships.
Knowledge
Essential
- Advanced knowledge of Microsoft products inc. Office, SQL, VS(SSIS)
- Understanding database theory
- Data Protection Act and other statutory regulations.
Desirable
- NHS Data change process ISNs
- Understanding NHS PbR and HRGs
- Business Cases preparation.
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).
