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 Data Engineers will support the data warehouse architect is the design 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 Data Warehouse Architect 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.
Leading the development of new pipelines and implementing new technologies in the Business Intelligence team, using tools such as SQL, Azure data factory and Azure stack modules including Databricks/Synapse Analytics, SSIS, 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. Data Engineers will develop 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 will supervise the Data Engineers, 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, T-SQL, SSRS, SSIS and PowerBI.
Job description
Job responsibilities
To be a subject matter expert. Data Engineers will develop 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 will supervise the Data Engineers, 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, T-SQL, SSRS, SSIS and PowerBI.
Person Specification
Certified in the use of Business Intelligence tools
Essential
- Relevant certification (Data Engineering, Azure, PowerBI etc.)
Microsoft BI Dev Stack software experience
Essential
- Significant experience working and developing with the Microsoft Azure stack.
Data Engineering experience
Essential
- Significant experience of developing and optimising ETL/ELT data warehousing solutions
- Developed and implemented development standards and processes across an Azure or similar environment
- Developed and trained junior staff in SQL, Azure, PowerBI or other technical skills.
Experience managing Projects
Essential
- Experience of managing and supervising data engineering projects involving multiple teams and systems.
Interpersonal Skills
Essential
- Demonstrates excellent interpersonal skills with proven experience of forming and maintaining internal and external relationships.
Person Specification
Certified in the use of Business Intelligence tools
Essential
- Relevant certification (Data Engineering, Azure, PowerBI etc.)
Microsoft BI Dev Stack software experience
Essential
- Significant experience working and developing with the Microsoft Azure stack.
Data Engineering experience
Essential
- Significant experience of developing and optimising ETL/ELT data warehousing solutions
- Developed and implemented development standards and processes across an Azure or similar environment
- Developed and trained junior staff in SQL, Azure, PowerBI or other technical skills.
Experience managing Projects
Essential
- Experience of managing and supervising data engineering projects involving multiple teams and systems.
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.
