Job summary
We are looking for a dedicated, enthusiastic, and dynamic individual to join the Trust's Data Warehouse development team.
Working under general direction and using your own discretion to identify and respond to complex issues and assignments, you will be expected to work with the Head of Information Systems and Data Warehouse to ensure best use of resources and to provide support to colleagues in the team and associated areas.
You will be involved in decision making around resource allocation and the delivery of work packages to meet Trust priorities and local and national timeframes.
Previous Applicants Need Not Apply
Main duties of the job
- Support the management of all aspects of Data Administration within the Trust (Acute and Community).
- Using MS SQL, Visual Studio and other database packages, develop and document the Trust data warehouse to a professional standard.
- Where data is NOT available within a corporately supported system (Cerner Millennium, RIO etc.), ensuring that a data extract process is developed, tested, documented and data is fed into the Data Warehouse as required.
- Understand the Commissioning environment and the role of the Data Warehouse as the main data source for Income Recovery.
- Form a deep understanding of wider customer and organizational needs
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
- Support the management of all aspects of Data Administration within the Trust (Acute and Community).
- Demonstrating excellent communication skills, forming a deep understanding of wider customer and organizational needs.
- Develop and document the Trust data warehouse to a professional standard.
- Where data is NOT available within a corporately supported system (Cerner Millennium, RIO etc.), ensuring that a data extract process is developed, tested, documented and data is fed into the Data Warehouse as required.
- Understand the Commissioning environment and the role of the Data Warehouse as the main data source for Income Recovery.
- 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.
- 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.
- Manage the on-going development and local support of the Data Warehouse solution to meet the Trusts ever growing need for data.
- 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
Job description
Job responsibilities
- Support the management of all aspects of Data Administration within the Trust (Acute and Community).
- Demonstrating excellent communication skills, forming a deep understanding of wider customer and organizational needs.
- Develop and document the Trust data warehouse to a professional standard.
- Where data is NOT available within a corporately supported system (Cerner Millennium, RIO etc.), ensuring that a data extract process is developed, tested, documented and data is fed into the Data Warehouse as required.
- Understand the Commissioning environment and the role of the Data Warehouse as the main data source for Income Recovery.
- 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.
- 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.
- Manage the on-going development and local support of the Data Warehouse solution to meet the Trusts ever growing need for data.
- 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
Person Specification
Training & Qualifications
Essential
- Master's level qualification or extensive equivalent experience in a similar role within an NHS Acute Trust
- Other IT Qualification e.g. Microsoft certification
Desirable
- Project Management qualification
Experience
Essential
- Extensive experience working in Data Management within the NHS
- Evidence of expert SQL Programming skills.
- Evidence of extensive experience with Data Warehousing in terms of design, structure, and technologies.
- Evidence of co-ordinating projects and taking ownership of large bodies of work.
- In-depth understanding of the NHS information flows, hospital systems, and applications
- Managing a Pay and Non pay budget
- Experience of delivering Management Information requirements (data extracts, reports, and data sets) to meet contractual deadlines
- Experience of managing SUS submission process and extracting data for SUS validation purposes
Desirable
- Experience of working Cerner Millennium data
- Developing a Data Warehouse across a multi-site NHS Acute Trust
- Working knowledge of Azure stack
- Significant experience of managing staff
- Managing Supplier relationships
- Monitoring compliance with SLA (Service Level Agreement) conditions
Person Specification
Training & Qualifications
Essential
- Master's level qualification or extensive equivalent experience in a similar role within an NHS Acute Trust
- Other IT Qualification e.g. Microsoft certification
Desirable
- Project Management qualification
Experience
Essential
- Extensive experience working in Data Management within the NHS
- Evidence of expert SQL Programming skills.
- Evidence of extensive experience with Data Warehousing in terms of design, structure, and technologies.
- Evidence of co-ordinating projects and taking ownership of large bodies of work.
- In-depth understanding of the NHS information flows, hospital systems, and applications
- Managing a Pay and Non pay budget
- Experience of delivering Management Information requirements (data extracts, reports, and data sets) to meet contractual deadlines
- Experience of managing SUS submission process and extracting data for SUS validation purposes
Desirable
- Experience of working Cerner Millennium data
- Developing a Data Warehouse across a multi-site NHS Acute Trust
- Working knowledge of Azure stack
- Significant experience of managing staff
- Managing Supplier relationships
- Monitoring compliance with SLA (Service Level Agreement) conditions
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.
