Job summary
The Healthcare Analytics department within Mid and South Essex NHS Foundation Trust is looking for a Data Warehouse Developer to join the Data Warehouse and Data Engineering Team(DW&DE).
This is a fantastic opportunity for a dynamic and enthusiastic individual who has experience in a similar role and and wants to join a highly progressive team with ample opportunities to learn and grow.
You will have experience of managing multiple data warehouses and to manage the support, maintenance and development of the group and site data warehouses and associated feeds and ETL processes. Excellent technical knowledge across both on-premise and Cloud based technologies is a key requirement alongside proven management skills.
You will provide Business as Usual management support to the data warehouse team as well as representing the team in all BAU related projects . The role is currently available as remote working only subject to the post holder having suitable work space.
Main duties of the job
The Data Warehousing and Data Engineering function is responsible for the implementation, maintenance and on-going development of the on-premises trust data warehouses and Cloud based group data warehouse including the development of new data feeds to support new projects. Main duties include:
- Analyse highly detailed and complex information methodically to ensure clarity, especially in situations with no precedent and varying contentious opinions.
- Act as an enabler to the team to ensure all system failures are resolved or escalated in a timely manner and all interested parties are kept informed as to progress.
- Assist the Head of department in developing effective data management strategies and processes meet with the overarching Data Strategy and organisational and service delivery objectives.
About us
Mid and South Essex NHS Foundation Trust is now one of the largest trusts in the country, serving a population of 1.2 million people. Our newly formed Trust, comprising acute hospital sites at Broomfield in Chelmsford, Basildon and Southend, is determined to provide the best health services for its local population. We are a well-led, high-performing and innovative organisation working in the best interests of the people we serve.
With a workforce of approximately 15,000 staff, we can now do more and go further in delivering health services to our local communities.
Our ambition is to deliver excellent local and specialist services, to improve the health and well-being of our patients, and provide a vibrant place for staff to develop, innovate and build careers.
The Data Warehouse and Data Engineering team is a welcoming, experienced and supportive team. There are clear and documented processes to help the team members navigate through the various requirements of their roles. To support home working there are daily huddles to understand priorities for the day, key achievements and successes to be celebrated and opportunity to raise any issues or identify where support is required.
There is lots of opportunity to support transformational work such as the implementation of a new Electronic Patient Record system as well as shaping the future of the service with enhanced automation and technical improvements.
Job description
Job responsibilities
The Healthcare Analytics department is part of the Planning and Performance Directorate. The department is responsible for providing an effective analytics service to the Trust and is split into three main functions:
- Analysis & Reporting
- Data Warehousing and Data Engineering
- Commissioning Information
Each of the three functions is led by a MSE Head of service.
The Data Warehousing and Data Engineering function is responsible for the implementation, maintenance and on-going development of the on-premises trust data warehouses and our Azure SQLMI group data warehouse including the development of new data feeds, troubleshooting and maintenance. The Data Engineering function is responsible for the development, build, testing and maintenance of Power BI data models. These products include forecasting, bench-marking, alerts, and triggers to inform users and prompt actions.
As the Deputy Head of Data Warehousing & Data Engineering (BAU) the role will provide expertise and leadership to the data warehouse team for its BAU activities, releasing other senior staff to work on the UEPR project. The role will support the team to maintain and develop the group and site data warehouses and associated feeds and ETL processes. This includes managing critical BAU projects such as system implementations and changes to data feeds due to upgrades to Medway and Lorenzo. The post holder will provide expertise to support staff in troubleshooting whilst engaging with stakeholders at all levels to understand business needs, provide expert knowledge and specialist analytical advice.
The post holder represents the Healthcare Analytics department in internal and external meetings at a senior level providing technical expertise and offering advice and guidance. They will also act as enabler to the team to ensure all system failures are resolved or escalated in a timely manner and all interested parties are kept informed as to progress
Job description
Job responsibilities
The Healthcare Analytics department is part of the Planning and Performance Directorate. The department is responsible for providing an effective analytics service to the Trust and is split into three main functions:
- Analysis & Reporting
- Data Warehousing and Data Engineering
- Commissioning Information
Each of the three functions is led by a MSE Head of service.
The Data Warehousing and Data Engineering function is responsible for the implementation, maintenance and on-going development of the on-premises trust data warehouses and our Azure SQLMI group data warehouse including the development of new data feeds, troubleshooting and maintenance. The Data Engineering function is responsible for the development, build, testing and maintenance of Power BI data models. These products include forecasting, bench-marking, alerts, and triggers to inform users and prompt actions.
As the Deputy Head of Data Warehousing & Data Engineering (BAU) the role will provide expertise and leadership to the data warehouse team for its BAU activities, releasing other senior staff to work on the UEPR project. The role will support the team to maintain and develop the group and site data warehouses and associated feeds and ETL processes. This includes managing critical BAU projects such as system implementations and changes to data feeds due to upgrades to Medway and Lorenzo. The post holder will provide expertise to support staff in troubleshooting whilst engaging with stakeholders at all levels to understand business needs, provide expert knowledge and specialist analytical advice.
The post holder represents the Healthcare Analytics department in internal and external meetings at a senior level providing technical expertise and offering advice and guidance. They will also act as enabler to the team to ensure all system failures are resolved or escalated in a timely manner and all interested parties are kept informed as to progress
Person Specification
Qualifications
Essential
- Masters degree level qualification or equivalent experience
Desirable
- Information Management Qualification
Experience
Essential
- Expert level understanding of data warehousing design and data transformation
- Range of Data Warehouse platforms to include Azure, SQLMI and SQL Servers
- Highly developed automation skills using Visual Studio
Desirable
- Strong knowledge of industry best practices around data architecture
Job Related Skills
Essential
- Highly developed team leading skills, amiable approach able to get the best from others
- Ability to clearly communicate complex ideas to a non technical audience
Personal Skills
Essential
- Exceptional interpersonal skills and the ability to forge effective professional relationships
- Strong organisational management skills
Desirable
Person Specification
Qualifications
Essential
- Masters degree level qualification or equivalent experience
Desirable
- Information Management Qualification
Experience
Essential
- Expert level understanding of data warehousing design and data transformation
- Range of Data Warehouse platforms to include Azure, SQLMI and SQL Servers
- Highly developed automation skills using Visual Studio
Desirable
- Strong knowledge of industry best practices around data architecture
Job Related Skills
Essential
- Highly developed team leading skills, amiable approach able to get the best from others
- Ability to clearly communicate complex ideas to a non technical audience
Personal Skills
Essential
- Exceptional interpersonal skills and the ability to forge effective professional relationships
- Strong organisational management skills
Desirable
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).
