Care Coordination Solution Data Support Engineer

Moorfields Eye Hospital NHS Foundation Trust is the leading provider of eye health services in the UK and a world-class centre of excellence for ophthalmic research and education. We have a reputation, developed over two centuries, for providing the highest quality of ophthalmic care. Our 2,500 staff are committed to sustaining and building on our pioneering legacy and ensuring we remain at the cutting edge of developments in ophthalmology.

The Care Coordination Solution (CCS) is a module designed as part of the development of the Federated Data Platform. The Inpatient and Referral To Treatment (RTT) elements of that module are being implemented into the trust as part of a workstream designed to improve patient flow and patient experience.

The Trust are seeking an experienced Data Support Engineer to support the implementation of a seamlessly integrated patient record system.

This role is part time and partially remote - hours available are 18 per week and the depaertment aere flexible which days are worked.

Key duties:

• Build the appropriate data tables, in an SQL environment, to capture the data required for the successful operation of the Care Coordination System. All scripting should be structured and clearly commented, to ensure scalability and transferability for potential future development.
• Ensure regular refreshes of the data tables as a minimum daily working towards an hourly data refresh using near live data. Be instrumental in the development of the methodology for data transfer to the new system i.e. which data can be automated, and which must be manually entered.
• Develop a testing methodology and mechanism to ensure that the data being transferred for use within the CCS system is accurate and complete
• Manage the day-to-day resource availability of internal staff required to support the data warehouse element of the CCS project. Ensure the work completed is of sufficient standard, accuracy and completeness required to meet the project timescales and provide appropriate supervision if this is not achieved.
• Plan, implement and monitor the staffing and resource requirements from external agencies including NHSE and Palantir. Ensure sufficient resources from external companies are available in line with the project plan.

A full Job description for this role is available on request.

Please contatc us with a full detailed CV which clearly identifies your experience in:

• The use MS-SQL, SSRS and Data Warehouse functions.
• Significant experience in similar environment or system
• Extensive familiarity with complex computerised data warehouse structures.
• Experience of designing, coding, testing and implementation of efficient and robust database schemas.
• Extensive experience of SQL Database Administrator tools and utilities including advanced scripting and basic coding.