Data Warehouse Manager | Mid Cheshire Hospitals NHS Foundation Trust
| Posting date: | 12 September 2025 |
|---|---|
| Salary: | Not specified |
| Additional salary information: | £55,690 - £62,682 per annum |
| Hours: | Full time |
| Closing date: | 02 November 2025 |
| Location: | Crewe, CW1 6ZQ |
| Company: | Mid Cheshire Hospitals |
| Job type: | Permanent |
| Job reference: | 7421068/412-CORP-7421068 |
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
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.
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.
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.
This advert closes on Sunday 12 Oct 2025