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:
* 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.
Key Areas of Focus:
* Database & Data Management: provision and maintenance of SQL databases on premise and in Azure, SQL upgrades, database tuning, log file management and incident response.
* Security & Governance: configuration and support of authentication arrangements, group permissions and system access audit, ensuring patching, security reviews, threat reduction and secure data destruction in line with Trust policies.
* Planning, Technology & Documentation: keeping up to date with developments in data warehouse technologies, Microsoft Azure and SQL Server, applying best practice to continuously improve services, undertaking capacity planning, proactive storage management and cost optimisation for cloud services.
* Leadership & Development: managing and developing a small team, motivating staff, allocating work, and supporting appraisals, acting as a role model and providing technical advice to colleagues.
Mid Cheshire Hospitals NHS Foundation Trust provides a full range of local hospital and community services for people across East Cheshire and West Cheshire and Chester boroughs. 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.
We are an equal opportunities employer and welcome applications from all sections of the community. Please let us know if you require an adjustment to our recruitment process.
#J-18808-Ljbffr