Job Description

This is a 12 month opportunity to join our Informatics team at PAH



The post holder will be part of the team developing and rolling out a robust

integrated Data Warehouse, developing scripts to extract, transform and load data from information systems across the Trust.



One area in particular which is vital to the Trust and its income is the SUS/CDS integration with SLAM. This role is key to ensuring delivery of data and information to support billing and forecasting, and to enable the identification of issues that may compromise this goal. This role, therefore, will involve developing a close working relationship with colleagues in our Finance department.



This is an exciting time for PAHT. Over the next five years we are on a digital transformation journey, leading us to our brand new hospital . You'll be part of the team supporting our organisation in a diverse and challenging role; a role which can make a significant difference to our patients, staff and the future direction of our services.



Our people demonstrate energy and commitment towards improving the care and experiences provided to our patients and the drive to be an 'outstanding' organisation.



It's never been a better time to join us.



Liaise with third party suppliers and staff across all levels of the Trust in the

planning, design and development of highly complex software system

solutions.

Migrate data marts and incorporate into the Data Warehouse. Working with core EPR Supplier, develop iterative ETL scripts to load data into our Data Warehouse. Take an active role within the team developing a Data Warehouse Schema and ETL timetable that will enable real time reporting. Work with the key contacts to develop the Data Warehouse through design and understanding of the EPR Schema, Trust interface and messaging engines to enable seamless integration. Work with and support colleagues in the team to ensure analysts are fully

supported and informed on use of the Data Warehouse for maximum

benefit.