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 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