Data Warehouse Implementation Lead

Job overview

We have embarked on a programme to implement a single Electronic Patient Record (EPR) as part of the NHS digital health ongoing initiative across the Norfolk and Waveney Acute Hospital Collaborative (NWAHC). The collaborative is made up of three acute hospitals in Norfolk and Waveney;

• James Paget University Hospitals NHS Foundation Trust (JPUH)
• Norfolk and Norwich University Hospitals NHS Foundation Trust (NNUH)
• The Queen Elizabeth Hospital King's Lynn NHS Foundation Trust (QEH)

This is a unique opportunity to contribute your skills and expertise to create a meaningful impact on the health and well-being of individuals throughout Norfolk and Waveney. We are dedicated to advancing our digital capabilities in alignment with our long-term strategic goals, ensuring a high standard of patient care and safety for our diverse communities.

The acute hospitals in Norfolk are a vital part of the health and social care system. Our digital mission is an essential part of our transformation into a post-modern healthcare system.

Main duties of the job

The Data Warehouse Implementation Lead will have extensive experience in data warehousing development, SQL Server Management Studio and data architecture. They will be responsible for the delivery of the Meditech data warehouse strategy, development, and management within the EPR Core Informatics team and manages the team of developers, leading them in the analysis, requirements, design, development, testing, enhancement, documentation, and ongoing support of development and reporting requests.  They will need to work closely with the three Trust’s data warehouse and technical teams to support their continuity of reporting, taking account of their local needs when developing any plans.

#tag words Data warehouse development, data warehouse architecture, SSMS, SQL developer

Detailed job description and main responsibilities

• Leads the discussions with stakeholders to understand extremely complex reporting needs across multiple existing systems and sites. Applies Meditech build and design expertise to analyse current business practices to enable full documentation and provide the recommended reporting solutions.
• The role will be the lead on advice, guidance, and insight into the correct application of NHS data dictionary and rules within the data warehouse environment to ensure maximum compliance within the Meditech build, data integration, data warehouse development and retention of legacy systems and associate data flows and data warehouses. Insight into the NHS, its reporting requirements and the data are therefore essential.
• This is a key team management role within the EPR Business Intelligence Team. They will work with the members of the three trust’s Informatics teams, EPR team and clinical and operational management teams to ensure a consistent approach to the implementation of the trust’s digital and information reporting strategy.