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 databases and support the maintenance and development of the group and site data warehouses and associated feeds and ETL processes. Good knowledge of SQL server and T-SQL including programming and BI Stack is necessary. Additionally any exposure to Oracle Millenium EPR or the Federated Data Platform will be beneficial.
Mid and South Essex along with its partners across the Integrated Care System in Mental and Community Health are embarking on an ambitious and exciting 'first of type' EPR deployment which will see a single Unified Electronic Patient Record system (EPR) implemented across all care settings. You will get an opportunity to work on this and a number of other exciting projects and business as usual support , within the DW&DE team. 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 split into three distinct and highly skilled teams. The Data Warehouse team is responsible for the implementation, maintenance and on-going development of the on-premises trust data warehouse including the development of new data feeds. Main duties include:
- Actively contribute to the build, management & maintenance of complete data warehouse infrastructure.
- Develop and maintain a detailed working knowledge of the technical content of source systems to inform the design and on-going development of data warehouse.
- Validate data, identify trends and anomalies and use expertise to judge the potential significance and recommend corrective action
- Working closely with the sub-teams of Data Warehousing and Data Engineering team as well as other teams in the Healthcare Analytics department to ensure the continual development and redesign of processes to maximise accuracy and efficiency and reduce the requirement for manual processes.
- Support third party data suppliers in developing specifications that are congruent with the trust's enterprise data architecture.
- Develop and maintain an in-depth knowledge of NHS data flows, datasets, information availability, scope, reliability and data quality issues. This includes a thorough understanding of the NHS data dictionary and knowledge of guidance for specific returns.
About us
Mid and South Essex NHS Foundation Trust is now one of the largest in the country, with a workforce of approximately 15,000 who serve a population of 1.2 million people.
We work together, and in conjunction with MSE Health and Care Partnership, to deliver excellent local and specialist services, to improve the health and wellbeing of our patients in a compassionate way, and provide a respectful, but vibrant place for staff to develop, innovate and build careers.
From facilities through to consultant specialists we want to be the best, to achieve this we need to recruit not just those who are the finest in their field but also those who have the potential to be. Yes, experience is important but so is outlook - if you are dynamic, forward-thinking and enthusiastic we want you to join us.
We not only offer you a good working environment with flexible working opportunities, but also the opportunity to develop your career with access to appropriate training for your job and the support to succeed and 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 split into three distinct and highly skilled teams. The Data Warehouse team is responsible for the implementation, maintenance and on-going development of the on-premises trust data warehouse including the development of new data feeds, Azure data warehouse team is responsible for day-to-day maintenance of the Azure ETL and Azure sqldb as well as development work undertaken on Azure. The Data Engineering (DE) team is responsible for the development, build, testing and maintenance of Power BI data models. These products include forecasting, benchmarking, alerts, and triggers to inform users and prompt actions.
As a data warehouse developer, the role will work in the data warehouse team and supports the maintenance and development of the group and site data warehouses and associated feeds and ETL processes. This includes managing changes to data feeds due to upgrades to Medway and Lorenzo. The post holder ensures the integrity of data and creates and maintains flat tables tosupport reporting and the production of datasets on a regular basis, prioritising work and allocating resources to deliver high quality work to agreed specification and within agreed timeline. The role will also undertake new developments and deployment in SQL DWH. The data warehouse team will work closely (as a sub-team) with the Azure Data team on day-to-day basis.
You will represent the Healthcare Analytics department in internal and external meetings providing technical expertise and offering advice and guidance.
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 split into three distinct and highly skilled teams. The Data Warehouse team is responsible for the implementation, maintenance and on-going development of the on-premises trust data warehouse including the development of new data feeds, Azure data warehouse team is responsible for day-to-day maintenance of the Azure ETL and Azure sqldb as well as development work undertaken on Azure. The Data Engineering (DE) team is responsible for the development, build, testing and maintenance of Power BI data models. These products include forecasting, benchmarking, alerts, and triggers to inform users and prompt actions.
As a data warehouse developer, the role will work in the data warehouse team and supports the maintenance and development of the group and site data warehouses and associated feeds and ETL processes. This includes managing changes to data feeds due to upgrades to Medway and Lorenzo. The post holder ensures the integrity of data and creates and maintains flat tables tosupport reporting and the production of datasets on a regular basis, prioritising work and allocating resources to deliver high quality work to agreed specification and within agreed timeline. The role will also undertake new developments and deployment in SQL DWH. The data warehouse team will work closely (as a sub-team) with the Azure Data team on day-to-day basis.
You will represent the Healthcare Analytics department in internal and external meetings providing technical expertise and offering advice and guidance.
Person Specification
Qualifications
Essential
- Minimum degree level qualification or equivalent experience
Desirable
- Information Management Qualification
Experience
Essential
- Experience of Data warehouse design and maintenance
- Strong SQL & SSIS, SSRS technical skills
- Experience of working in an NHS information environment in an information management role
- Experience of writing SQL queries and complex stored procedures
Desirable
- Any Cloud based Datawarehouse solutions is a plus (Nice to have)
- Knowledge of Data Protection and Data Quality issues
Job Related Skills
Essential
- Thorough understanding of NHS data definitions and reporting requirements
- Able to successfully implement/support change and service improvement
- Ability to clearly communicate complex ideas to a non technical audience
Personal Skills
Essential
- Strong organisational management skills
- Ability to forge effective professional relationships
Desirable
Person Specification
Qualifications
Essential
- Minimum degree level qualification or equivalent experience
Desirable
- Information Management Qualification
Experience
Essential
- Experience of Data warehouse design and maintenance
- Strong SQL & SSIS, SSRS technical skills
- Experience of working in an NHS information environment in an information management role
- Experience of writing SQL queries and complex stored procedures
Desirable
- Any Cloud based Datawarehouse solutions is a plus (Nice to have)
- Knowledge of Data Protection and Data Quality issues
Job Related Skills
Essential
- Thorough understanding of NHS data definitions and reporting requirements
- Able to successfully implement/support change and service improvement
- Ability to clearly communicate complex ideas to a non technical audience
Personal Skills
Essential
- Strong organisational management skills
- Ability to forge effective professional relationships
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).
