Job summary
Junior data engineer x2 is required in the Information Solution for London (ISL) pa hosted service North East London ICB. You will assist in management of the data ingestion lifecycle working with the stakeholders, clinicians and other developers to build the data rules so the data will be presented in a useful and easy to use format for users.
This is a fix term contract for 12 months.
Main duties of the job
Engage with all stakeholders to identify requirements where appropriate and working directly with the team technical lead to agree the requirements, deliverables and timescales
Liaise with data quality and standards lead to build rules in the data processing which are likely to be highly complex
Help the developers to obtain quantitative and qualitative data on the healthcare dataset to analyse, determine and promote data driven decisions.
Proactively manage the key risks and issues associated with ensuring appropriate actions are taken to mitigate or respond.
About us
NHS North East London Integrated Care Board (ICB) was formed on 1 July 2022.
We are an exciting new organisation putting the needs of communities at the heart of our commissioning arrangements.
We are working with local people and partners across health, social care and the voluntary sector in innovative ways to improve health and wellbeing for all our communities. Our key priority in the next year will be to develop closer integrated and collaborative ways of working with all our partners to implement our Out of Hospital Strategy.
We can only do this with great staff who are encouraged and supported, which is why we invest in them, listen to them, make sure we are representative of our populations and that we foster their health and wellbeing.
Job description
Job responsibilities
Please see the attached Job Description and Person Specification for full duties and responsibilities.
Job description
Job responsibilities
Please see the attached Job Description and Person Specification for full duties and responsibilities.
Person Specification
Knowledge, training, qualifications and experience
Essential
- Educated to Degree level in relevant subject or equivalent level of experience X A/I
- Significant of experience of working autonomously at a similar level in specialist area - showing both theoretical and practical experience X A/I
- Significant evidence of continued professional development including project management or relevant experience
- Ability to work effectively as part of a multi-disciplinary team; providing leadership
- Experience of old Microsoft stack - SSIS, SQL, ETLs AND/OR Experience of Cloud ELT/ETL such as ADF, Matillion etc
- Proven track record of analysing source data, identifying DQ issues and working out the best way to ingest the data
- Demonstratable database design skills, familiarity with Kimball or Data Vault 2 principles
- Experience in writing Python and Azure Functions AND/OR previous experience of coding in languages like c#
- Experience of javascript for Snowflake Stored Procedures / command line/Powershell / a big data platform such as Snowflake or Databricks desirable
- Experience of loading data from various sources, knowledge of cloud and datalake security advantageous
- Highly Advanced SQL Server, SSIS or Data Factory
Communication skills
Essential
- Be able to communicate effectively both verbally and in writing complex, sensitive and / or contentious information and secure the agreement of cooperation of individuals or groups through well developed and persuasive negotiating skills
- Be able to demonstrate the presence, personal confidence, and commitment necessary to gain respect and confidence of colleagues
Analytical skills
Essential
- Be able to interpret and implement external legislation and guidance and to plan and organise complex activities and processes that involve degrees of uncertainty, and which may impact across the organisation
- Ability to provide and receive, convey and present highly complex, sensitive and/or contentious information to large groups, responding openly to questions to ensure full understanding and engagement
- High level critical thinking skills
Person Specification
Knowledge, training, qualifications and experience
Essential
- Educated to Degree level in relevant subject or equivalent level of experience X A/I
- Significant of experience of working autonomously at a similar level in specialist area - showing both theoretical and practical experience X A/I
- Significant evidence of continued professional development including project management or relevant experience
- Ability to work effectively as part of a multi-disciplinary team; providing leadership
- Experience of old Microsoft stack - SSIS, SQL, ETLs AND/OR Experience of Cloud ELT/ETL such as ADF, Matillion etc
- Proven track record of analysing source data, identifying DQ issues and working out the best way to ingest the data
- Demonstratable database design skills, familiarity with Kimball or Data Vault 2 principles
- Experience in writing Python and Azure Functions AND/OR previous experience of coding in languages like c#
- Experience of javascript for Snowflake Stored Procedures / command line/Powershell / a big data platform such as Snowflake or Databricks desirable
- Experience of loading data from various sources, knowledge of cloud and datalake security advantageous
- Highly Advanced SQL Server, SSIS or Data Factory
Communication skills
Essential
- Be able to communicate effectively both verbally and in writing complex, sensitive and / or contentious information and secure the agreement of cooperation of individuals or groups through well developed and persuasive negotiating skills
- Be able to demonstrate the presence, personal confidence, and commitment necessary to gain respect and confidence of colleagues
Analytical skills
Essential
- Be able to interpret and implement external legislation and guidance and to plan and organise complex activities and processes that involve degrees of uncertainty, and which may impact across the organisation
- Ability to provide and receive, convey and present highly complex, sensitive and/or contentious information to large groups, responding openly to questions to ensure full understanding and engagement
- High level critical thinking skills
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.