Welwyn Garden City AL7 1BW, United Kingdom
Job description
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.
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.
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.
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.