Job summary
HCT require a Data Engineer to lead the building of the architecture to house a fully-fledged data warehouse environment. This will include developing appropriate ETL processes to ensure data is received from all the Trust's internal and external systems and liaising with the Trust's 3rd party suppliers to build an efficient system.
Main duties of the job
Develop the Trust's Data Warehouse as the primary source of all management information relating to patient activity and corporate functions, by the introduction of datasets or views of data, ensuring that NHS data standards are adhered to and tables within the system are structured so as to maximise interrogation speed.
About us
A big thank you for considering joining us at Hertfordshire Community NHS Trust
You'll find it a great place to work with many benefits offered to you as a member of our staff
We put our patients, their families and carers at the centre of our vision - Outstanding Services and Healthier Communities
Our staff are proud to be Innovative, Caring and Agile in their work to help achieve the Trust vision
We welcome diversity in our workforce and are interested in applicants from all backgrounds and ages
We don't want you to miss out so we'd like you to know that if we have a high level of interest in this role, the vacancy may close prior to the advertised closing date, so please make your application as soon as possible - Apply now
You've made a great decision to apply to join to HCT - we're looking forward to taking the next steps of the journey with you.
Job description
Job responsibilities
You will be responsible for designing T/SQL and SSIS ETL routines that adhere to an Enterprise data & information architecture. You will create data marts for end users, implementing ETL best practices, data modelling, error-handling, etc. You will also facilitate the development of effective BI requirements through a solid understanding of modern DW tools, techniques, and best practices. The ideal candidate will be able to assess organisational opportunities to integrate new and existing company systems into the DW platform as part of a long-term strategic roadmap and develop the Trusts Cloud based solutions.
Job description
Job responsibilities
You will be responsible for designing T/SQL and SSIS ETL routines that adhere to an Enterprise data & information architecture. You will create data marts for end users, implementing ETL best practices, data modelling, error-handling, etc. You will also facilitate the development of effective BI requirements through a solid understanding of modern DW tools, techniques, and best practices. The ideal candidate will be able to assess organisational opportunities to integrate new and existing company systems into the DW platform as part of a long-term strategic roadmap and develop the Trusts Cloud based solutions.
Person Specification
Technical
Essential
Desirable
Person Specification
Technical
Essential
Desirable
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).
