NHS
Data Warehouse Developer
This job is now closed
Job Description
- Req#: C9292-24-0063?language=en&page=909&sort=publicationDateDesc
- Data warehouse development
- NHS data experience
- extensive SQL server experience
- Quality assurance experience
- SUS experience
- Detailed knowledge of relational database (SQL, MYSQL)
- Developed in at least one of C# .NET, VB.NET or ASP.et
- Presenting skills
- Stakeholder or project management
- Educated to degree level in computer related discipline
- Data warehouse development
- NHS data experience
- extensive SQL server experience
- Quality assurance experience
- SUS experience
- Detailed knowledge of relational database (SQL, MYSQL)
- Developed in at least one of C# .NET, VB.NET or ASP.et
- Presenting skills
- Stakeholder or project management
- Educated to degree level in computer related discipline
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.
Date posted
26 January 2024
Pay scheme
Agenda for change
Band
Band 6
Salary
£35,392 to £42,618 a year Per Annum
Contract
Secondment
Working pattern
Full-time, Flexible working, Home or remote working
Reference number
292-5962200-CORP
Job locations
Harlow
Harlow
CM17 9NA
Job descriptionJob 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 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 SpecificationPerson Specification
Experience
Essential
Desirable
Skills
Essential
Desirable
Qalifications
Essential
Experience
Essential
Desirable
Skills
Essential
Desirable
Qalifications
Essential
Additional informationDisclosure 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.
Certificate of Sponsorship
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).
Certificate of Sponsorship
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).
Employer details
Employer name
The Princess Alexandra Hospital NHS Trust
Address
Harlow
Harlow
CM17 9NA
Employer's website
https://www.pah.nhs.uk (Opens in a new tab)
Employer details
Employer name
The Princess Alexandra Hospital NHS Trust
Address
Harlow
Harlow
CM17 9NA
Employer's website
https://www.pah.nhs.uk (Opens in a new tab)
About the company
National Health Service (NHS) is the umbrella term for the publicly-funded healthcare systems of the United Kingdom (UK). The founding principles were that services should be comprehensive, universal and free at the point of delivery—a health service based on clinical need, not ability to pay. Each service provides a comprehensive range of health services, free at the point of use for people ordinarily resident in the United Kingdom apart from dental treatment and optical care.