Data Warehouse Developer

Job overview

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.

Main duties of the job

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.

Detailed job description and main responsibilities

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.