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.
You will get to work on number of exciting projects, with the DW&DE and other teams in the department. 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 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 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.
The post holder represents 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.
The post holder represents 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).
