Job summary
This is an exciting opportunity for a Data Engineer to join our dynamic Imperial Clinical Analytics, Research & Evaluation (iCARE) team. As part of the iCARE NHS team, you will directly contribute to the delivery of a translational portfolio of projects within the Digital Health theme of the National Institute for Health and Care Research (NIHR) Imperial Biomedical Research Centre, and Paddington Life Sciences initiative, spanning translational data analytics, Artificial Intelligence and Real-World Evidence. You will be part of a data engineering team devlivering projects and interventions that make a genuine contribution to improving health at person and population level.
You will play an integral part in the further evolution of the Imperial Biomedical Research Centre's Azure based NHS Secure Data Environment. Working in our iCARE NHS data-engineering unit you will support the delivery and curation of huge volumes healthcare and other data using our advanced technology and systems.
Based in our brand new Digital Collaboration Space at St Mary's hospital you will work with world-class clinicians, data scientists, researchers, data engineers and informaticans to address priorities to respond to the needs and preferences of our patients, staff and local community towards social purpose and care equity during the ongoing digital transformation of the NHS.
Main duties of the job
As a Data Engineer, you will play an important role in the further evolution of the Imperial Biomedical Research Centre's Secure Data Environment Imperial Clinical Analytics, Research & Evaluation (iCARE) team. Specifically, you will be part of a team responsible for providing a data engineering service that supports the development of data pipelines of curated and structured databases for direct care, operational decision making and research, using routinely captured patient data and analytics tools for our internal and external stakeholders. The role will specifically support the Director's strategy for prioritising the most immediate areas for development in Digital Health.
About us
At Imperial College Healthcare you can achieve extraordinary things with extraordinary people, working with leading clinicians pushing boundaries in patient care.
Become part of a vibrant team living our values - expert, kind, collaborative and aspirational. You'll get an experience like no other and will fast forward your career.
Benefits include career development, flexible working and wellbeing, staff recognition scheme. Make use of optional benefits including Cycle to Work, car lease schemes, season ticket loan or membership options for onsite leisure facilities.
We are committed to equal opportunities and improving the working lives of our staff and will consider applications to work flexibly, part time or job share. Please talk to us at interview. .
Job description
Job responsibilities
The full job description provides an overview of the key tasks and responsibilities of the role and the person specification outlines the qualifications, skills, experience and knowledge required.For both overviews please view the Job Description attachment with the job advert.
Job description
Job responsibilities
The full job description provides an overview of the key tasks and responsibilities of the role and the person specification outlines the qualifications, skills, experience and knowledge required.For both overviews please view the Job Description attachment with the job advert.
Person Specification
Education/ Qualifications
Essential
- oDegree in relevant field
- oPrince II
- oITIL certification
Desirable
- oMasters in IT
- oBusiness Objects
Experience
Essential
- oSignificant experience in Data Warehouse development and Maintenance
- oDatabase management and administration experience
- oExperience of working with very large datasets (ideally NHS or healthcare)
- oIT Project Management knowledge and experience
Desirable
- oDeveloping SSIS packages
- oUse of SQL server 2014 - 2019
- oExperience Metadata management and documentation
- oExperience of NHS (or other healthcare) systems and processes
Skills/Knowledge/ Abilities
Essential
- oStrong knowledge of either Snowflake, SSIS, ADF, or DBT
- oKnowledge of different data types, structured and unstructured including XML, JSON
- oAdvanced SQL knowledge Good knowledge of data modelling, database structures and process
- oGood understanding of technology and systems applications
- oETL (Extract, Transform, and Load) knowledge
- oAbility to process multi
- oExcellent oral and written skills
- oGood presentation skills to allow effective communication during meetings, conferences, workshops and seminars
- oAbility to communicate effectively to ensure that complex technical requirements can be understood by non-technical audiences
Desirable
- oGood Knowledge of NHS data structures, coding systems and data dictionary
- oAgile project management
- oSoftware development frameworks and version control
- oOLAP Technology
- oKnowledge of data warehouse
- oKnowledge of QlikView/tableau or similar
Person Specification
Education/ Qualifications
Essential
- oDegree in relevant field
- oPrince II
- oITIL certification
Desirable
- oMasters in IT
- oBusiness Objects
Experience
Essential
- oSignificant experience in Data Warehouse development and Maintenance
- oDatabase management and administration experience
- oExperience of working with very large datasets (ideally NHS or healthcare)
- oIT Project Management knowledge and experience
Desirable
- oDeveloping SSIS packages
- oUse of SQL server 2014 - 2019
- oExperience Metadata management and documentation
- oExperience of NHS (or other healthcare) systems and processes
Skills/Knowledge/ Abilities
Essential
- oStrong knowledge of either Snowflake, SSIS, ADF, or DBT
- oKnowledge of different data types, structured and unstructured including XML, JSON
- oAdvanced SQL knowledge Good knowledge of data modelling, database structures and process
- oGood understanding of technology and systems applications
- oETL (Extract, Transform, and Load) knowledge
- oAbility to process multi
- oExcellent oral and written skills
- oGood presentation skills to allow effective communication during meetings, conferences, workshops and seminars
- oAbility to communicate effectively to ensure that complex technical requirements can be understood by non-technical audiences
Desirable
- oGood Knowledge of NHS data structures, coding systems and data dictionary
- oAgile project management
- oSoftware development frameworks and version control
- oOLAP Technology
- oKnowledge of data warehouse
- oKnowledge of QlikView/tableau or similar
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).
