Job summary
Mid Cheshire Hospitals NHS Foundation Trust is seeking an experienced and motivated Data Warehouse Manager to lead the delivery, support and proactive maintenance of the Trust's Data Warehouse. The role underpins the effective use of data, information, knowledge and technology to support and improve healthcare delivery.
The successful candidate will be responsible for developing and enhancing the Trust's Data Warehouse across both on premise and Microsoft Azure environments. The post holder will ensure solutions remain secure, reliable and innovative, while keeping abreast of emerging technologies and best practice to shape the future of the Trust's Business Intelligence capability
Main duties of the job
The main duties of the job include:
- Lead on the development and maintenance of the Trust's Data Warehouse, managing data feeds, databases, platform environment, system security, planning and technical documentation.
- Provide expertise in T-SQL, SQL Server and Microsoft Azure to support reporting and analytical needs across the Trust.
- Keep up to date with evolving data warehouse, cloud and database technologies, identifying opportunities to enhance the Trust's infrastructure and approach.
- Develop, support and monitor data extraction, transfer, staging and load processes, ensuring high-quality validated data.
- Configure, test and support authentication and security group permissions in line with Trust security policies.
- Develop documentation including configuration records, data flow mappings, SQL code and standard operating procedures.
- Manage and lead a small team, allocating tasks, appraising performance and supporting staff development.
About us
Mid Cheshire Hospitals NHS Foundation Trust provides a full range of local hospital and community services for people across East Cheshire (population 399K) and West Cheshire and Chester boroughs (population 357K).
The Trust provides high quality planned and unplanned/emergency care, cardiac and critical care as well as child health, maternity services, and intermediate care across our sites at Leighton Hospital in Crewe, Victoria Infirmary in Northwich, and Elmhurst Intermediate Care Centre in Winsford.
The Trust provides 500 beds and employs over 5,100 members of staff.
An extensive range of community services is provided across 26 medical centres and schools by our community arm, Central Cheshire Integrated Care Partnership, in collaboration with Cheshire and Wirral Partnership NHS FT and the South Cheshire and Vale Royal GP Alliance.
We have played, and continue to play, a proactive role in the development of Integrated Care plans across Cheshire & Merseyside and our local Cheshire East and Cheshire West Place-based systems. We believe, and it is the cornerstone of our five-year Trust Strategy, there is the opportunity to progress innovative, responsive and effective care in the best setting for the patient, be it in the hospital or out in the community.
At Mid Cheshire, our mission is to inspire hope and provide unparalleled care for the people and communities of Cheshire, helping them to enjoy life to the fullest.
Job description
Job responsibilities
The post holder will:
- Service Delivery
- Deliver and support a Trust-wide Data Warehouse for clinical and non-clinical systems.
- Adhere to IT change management processes and provide technical support to the Information Department.
- Database & Data Management
- Provision and maintain SQL databases on premise and in Azure.
- Undertake SQL upgrades, database tuning, log file management and incident response.
- Develop and monitor data extraction, data staging and load routines
- Implement and maintain data validation processes, data retention and archiving strategies.
- Security & Governance
- Configure and support authentication arrangements, group permissions and system access audit.
- Ensure patching, security reviews, threat reduction and secure data destruction in line with Trust policies.
- Planning, Technology & Documentation
- Keep up to date with developments in data warehouse technologies, Microsoft Azure and SQL Server, applying best practice to continuously improve services.
- Undertake capacity planning, proactive storage management and cost optimisation for cloud services.
- Lead on Trust-wide policies and procedures for data warehouse and database management systems.
- Produce and maintain documentation including technical specifications, system diagrams, SQL code and standard operating procedures.
- Leadership & Development
- Manage and develop a small team, motivating staff, allocating work, and supporting appraisals.
- Act as a role model and provide technical advice to colleagues.
Job description
Job responsibilities
The post holder will:
- Service Delivery
- Deliver and support a Trust-wide Data Warehouse for clinical and non-clinical systems.
- Adhere to IT change management processes and provide technical support to the Information Department.
- Database & Data Management
- Provision and maintain SQL databases on premise and in Azure.
- Undertake SQL upgrades, database tuning, log file management and incident response.
- Develop and monitor data extraction, data staging and load routines
- Implement and maintain data validation processes, data retention and archiving strategies.
- Security & Governance
- Configure and support authentication arrangements, group permissions and system access audit.
- Ensure patching, security reviews, threat reduction and secure data destruction in line with Trust policies.
- Planning, Technology & Documentation
- Keep up to date with developments in data warehouse technologies, Microsoft Azure and SQL Server, applying best practice to continuously improve services.
- Undertake capacity planning, proactive storage management and cost optimisation for cloud services.
- Lead on Trust-wide policies and procedures for data warehouse and database management systems.
- Produce and maintain documentation including technical specifications, system diagrams, SQL code and standard operating procedures.
- Leadership & Development
- Manage and develop a small team, motivating staff, allocating work, and supporting appraisals.
- Act as a role model and provide technical advice to colleagues.
Person Specification
Experience
Essential
- Extensive data extract, transfer/translate and load experience for a large data warehouse
- Experience of interpreting system log files;system performance monitoring and tuning
- Extensive knowledge of messaging technologies
- Extensive knowledge of Microsoft Azure and its data management offering
- Extensive knowledge of writing SQL and stored procedures and query tuning on high transaction systems.
- Knowledge of database mirroring using processes such as change data capture
- Knowledge of Business Intelligence systems and reporting tools such as Power BI
Desirable
- Knowledge of NHS and acute datasets
- Knowledge of patient and data flows in an hospital setting
- Knowledge of programming languages
Skills
Essential
- In-depth knowledge of SQL development/coding
- Working knowledge of NHS Information Governance requirements
- Excellent communication skills, both verbal and written
- Ability to produce good technical documentation including data flow maps
- Able to liaise with external system suppliers
- oExperience of assisting in hardware and operating system deployment for BI projects
Desirable
- Experience of working in an acute NHS trust
- Cloud technology management including platform as a service and infrastructure as a service models.
Qualifications
Essential
- oMicrosoft Certification (in SQL server/ Azure)
- oEducated to masters level in an Informatics related subject or equivalent experience
Person Specification
Experience
Essential
- Extensive data extract, transfer/translate and load experience for a large data warehouse
- Experience of interpreting system log files;system performance monitoring and tuning
- Extensive knowledge of messaging technologies
- Extensive knowledge of Microsoft Azure and its data management offering
- Extensive knowledge of writing SQL and stored procedures and query tuning on high transaction systems.
- Knowledge of database mirroring using processes such as change data capture
- Knowledge of Business Intelligence systems and reporting tools such as Power BI
Desirable
- Knowledge of NHS and acute datasets
- Knowledge of patient and data flows in an hospital setting
- Knowledge of programming languages
Skills
Essential
- In-depth knowledge of SQL development/coding
- Working knowledge of NHS Information Governance requirements
- Excellent communication skills, both verbal and written
- Ability to produce good technical documentation including data flow maps
- Able to liaise with external system suppliers
- oExperience of assisting in hardware and operating system deployment for BI projects
Desirable
- Experience of working in an acute NHS trust
- Cloud technology management including platform as a service and infrastructure as a service models.
Qualifications
Essential
- oMicrosoft Certification (in SQL server/ Azure)
- oEducated to masters level in an Informatics related subject or equivalent experience
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).
