Job summary
The post holder will be part of the team developing and rolling out a robustintegrated 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.
About us
This is an exciting time for PAHT. Over the next five years we are on a digital transformation journey, leading us to ourbrand 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.
Job description
Job responsibilities
Liaise with third party suppliers and staff across all levels of the Trust in theplanning, design and development of highly complex software systemsolutions. 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 fullysupported and informed on use of the Data Warehouse for maximumbenefit.
Job description
Job responsibilities
Liaise with third party suppliers and staff across all levels of the Trust in theplanning, design and development of highly complex software systemsolutions. 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 fullysupported and informed on use of the Data Warehouse for maximumbenefit.
Person Specification
Experience
Essential
- Data warehouse development
- NHS data experience
- extensive SQL server experience
- Quality assurance experience
Desirable
Skills
Essential
- Detailed knowledge of relational database (SQL, MYSQL)
- Developed in at least one of C# .NET, VB.NET or ASP.et
- Presenting skills
Desirable
- Stakeholder or project management
Qalifications
Essential
- Educated to degree level in computer related discipline
Person Specification
Experience
Essential
- Data warehouse development
- NHS data experience
- extensive SQL server experience
- Quality assurance experience
Desirable
Skills
Essential
- Detailed knowledge of relational database (SQL, MYSQL)
- Developed in at least one of C# .NET, VB.NET or ASP.et
- Presenting skills
Desirable
- Stakeholder or project management
Qalifications
Essential
- Educated to degree level in computer related discipline
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
Additional information
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
