Job summary
It is said that in today's modern world data is a richer resource than oil.
As Healthcare becomes more complex, there is an ever growing need to understand and interpret large data sets to provide insight and support decision makers, ensuring we serve our communities in the most efficient and effective way. Businesses thrive by making the best use of their data, and the Norfolk and Waveney Integrated Care Board are no exception to this.
The Business Intelligence team is at the forefront of this. You will work with your colleagues to drive our analytical capabilities to supporting population Health Management as well as performance and demand reporting to all business areas.
At the heart of this strategy is the development of an Azure Data Lake and structured Data Warehouse. The Junior Data Engineers will support the Head of Data Engineering and the Senior Data Engineer with the support and implementation of this data architecture and will support the wider Business Intelligence team in the more efficient and effective use of data.
Main duties of the job
To be responsible for supporting the Head of Data Engineering and wider BI team in the design, development expansion and maintenance of the ICB 'data warehouse', Azure Data Lake and Business Intelligence (BI) systems, acting as a deputy where required.
To assist in developing the data assets and capabilities of the Business Intelligence team using tools such as SQL, Azure data factory and Azure stack modules including Databricks/Synapse Analytics and Power BI.
About us
You will be working in a small centralised team supporting the Integrated care Board (ICB) but with close collaboration with all our Health and social care partners across Norfolk and Suffolk.
The work is varied, dynamic and interesting, with an excellent team environment. The team now largely work from home with occasional requirements to attend the office, but agile working is available. There are flexible working opportunities.
Job description
Job responsibilities
To be a subject matter expert. The Junior Data Engineers will provide support and deliver training for informaticians. This will include technical training on BI software and languages as well as requirements gathering, specification design and implementation. They may supervise other informatics colleagues, managing their workload and supporting their development.
Undertake complex technical work liaising with system owners and specialists in designing the data warehouse to ensure that it meets the needs of all users. Ensure that thorough documentation and change control processes are in place and are accessible and maintained. Proactively manage the integrity and quality of data within the data warehouse: investigating, raising and resolving issues with the system owners where necessary
To work with informatics colleagues to develop and implement new information reports, flows and systems that meet the operational and strategic needs of the Trust and their stakeholders. Undertake the specification, design and implementation of technical reports using systems such as, but not limited to, SQL Server, Azure Data Factory/Synapse Analytics/Data Bricks and PowerBI.
Job description
Job responsibilities
To be a subject matter expert. The Junior Data Engineers will provide support and deliver training for informaticians. This will include technical training on BI software and languages as well as requirements gathering, specification design and implementation. They may supervise other informatics colleagues, managing their workload and supporting their development.
Undertake complex technical work liaising with system owners and specialists in designing the data warehouse to ensure that it meets the needs of all users. Ensure that thorough documentation and change control processes are in place and are accessible and maintained. Proactively manage the integrity and quality of data within the data warehouse: investigating, raising and resolving issues with the system owners where necessary
To work with informatics colleagues to develop and implement new information reports, flows and systems that meet the operational and strategic needs of the Trust and their stakeholders. Undertake the specification, design and implementation of technical reports using systems such as, but not limited to, SQL Server, Azure Data Factory/Synapse Analytics/Data Bricks and PowerBI.
Person Specification
Data Engineering tools
Essential
- Experience in (Microsoft) Data Engineering tools, for example SQL Server, Azure Synapse/Data Factory, SSIS
Developing ETL Solutions and Data Modelling
Essential
- Experience of working with a data warehouse
- Experience of ETL processes and technologies
- Experience of Data modelling techniques
Data Quality and Metadata Management
Essential
- Experience in handling data quality issues (identification, resolving or reporting)
- Experience in the creation and/or management of metadata repositories
Interpersonal Skills
Essential
- Demonstrates excellent interpersonal skills with proven experience of forming and maintaining internal and external relationships.
Person Specification
Data Engineering tools
Essential
- Experience in (Microsoft) Data Engineering tools, for example SQL Server, Azure Synapse/Data Factory, SSIS
Developing ETL Solutions and Data Modelling
Essential
- Experience of working with a data warehouse
- Experience of ETL processes and technologies
- Experience of Data modelling techniques
Data Quality and Metadata Management
Essential
- Experience in handling data quality issues (identification, resolving or reporting)
- Experience in the creation and/or management of metadata repositories
Interpersonal Skills
Essential
- Demonstrates excellent interpersonal skills with proven experience of forming and maintaining internal and external relationships.
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.
