Job summary
We're looking for a skilled and driven Data Development Manager to join us at University Hospitals of Northamptonshire (UHN). You will lead a team responsible for providing the central data platform which supports data analytics, national reporting and operational service delivery across UHN.
We have recently implemented a new Azure data warehouse across UHN and are in the process of decommissioning the legacy on-premise warehouses at each site in the coming months. We're also early adopters of the Federated Data Platform and contribute to the future direction of the data model that underpins it.
We are predominantly a remote team so fully support remote and flexible working. We do however have team meetings once a month which are hosted on site depending on their content and there may be other times where an on-site presence is required to support stakeholders, particularly in a leadership role.
Main duties of the job
The Data Development Manager will lead a team responsible for providing the central platform which supports data analytics, national reporting and operational service delivery across University Hospitals of Northamptonshire (UHN).
The team are responsible for end-to-end data provision, ensuring that data is acquired in an efficient and complete manner before transforming it and provisioning back to users in a transparent and well documented fashion.
The post holder will manage the appropriate design, governance and monitoring of Extract, Transform and Load (ETL) processes, and will work with colleagues across Health Intelligence and beyond to ensure the data available supports high quality analytics and robust clinical and operational reporting.
The role comes with full responsibility for the management and professional development of the team, and it is expected that the post holder will be a technical subject matter expert in this field to provide appropriate coaching and mentorship where required.
As a key part of the Health Intelligence leadership team, the post holder will be expected to build and maintain strong working relationships across a number of disciplines and teams and to represent the whole of Health Intelligence when required.
About us
**Please submit your application as soon as possible as we reserve the right to close any adverts before the closing date once we have received sufficient applications**
Kettering General Hospital NHS Foundation Trust is one of the largest employers in the area and we are on an exciting journey. All our divisions are committed to doing things better, with more efficiency as we update, modernise, and advance. We have also entered a Group Model with neighbouring Northampton General Hospital NHSTrust and become University Hospitals of Northamptonshire.
Our Excellence Values
- Compassion
- Accountability
- Respect
- Integrity
- Courage
We want to recruit the best people to deliver our services across the University Hospitals of Northamptonshire and help to unleash everyone's full potential.
The Hospital Group encourages applications from people who identify from all protected groups. We understand that we need to work with colleagues from diverse backgrounds and make sure the environment they work in is inclusive and collaborative.
We recognise the valuable contribution that the Armed Forces community make to our organisation. We have signed the Armed Forces Covenant and achieved Silver Award under the Armed Forces Employer Recognition Scheme.
We have active Networks that promote and support colleagues from all backgrounds. This ensures everyone feels supported and has a sense of belonging working for Kettering and Northampton General Hospitals.
Job description
Job responsibilities
Responsible for the overall management of the Trusts Data Warehouse and the team which support it.
Responsible for end-to-end data provision, ensuring that data is acquired in an efficient and complete manner before transforming it and provisioning back to users in a transparent and well documented fashion.
Develop and oversee highly complex Extract, Transform and Load (ETL) processes and manage Azure SQL (and legacy Microsoft SQL server/Oracle) databases.
To be the lead technical expert and provide highly specialist technical support and advice for the existing set of database applications.
Ensure the Trust submits accurate and timely national returns such as the ECDS and CDS, which is the published record of the Trusts activity and the mechanism by which it receives its income.
Develop and maintain technical standard operating procedures used by the Data Warehouse team and ensure they are followed.
Manage the Data Warehouse system architecture, assess whether data items/tables are correct, ensure data anomalies identified are investigated and instigate corrective action where required.
Develop and automate quality assurance procedures, establish audit trails for each item of data being held & reported in the warehouse to enable data validation tests to be applied.
Ensure version control framework is applied to the Data Warehouse.
Manage the system administration of the Data Warehouse and Trusts business intelligence reporting systems as required, e.g. manage access rights of users giving them role-based access rights to certain data only, setting up groups and managing licenses; be a principle point of contact to solve reporting system problems.
Support and contribute to the development of the Federated Data Platform canonical data model and rollout of products across UHN by ensuring availability of data.
Ensure appropriate security controls are in place for access to data and that appropriate data security policy is adhered to within the team.
Ensure information is processed in accordance with Information Governance Policy.
Support the process of options appraisals, procurement and implementation of new technologies/products used to implement the Data Warehouse.
Pro-actively review new and emerging technologies and their potential benefit to the Trust, and where relevant develop business cases for these technologies.
Provide and analyse complex and sensitive datasets to support the wider Health Intelligence teams delivery.
Advise key internal customers/stakeholders on management and storage of datasets and analysis tools available to them.
Support the documented change control process and ensure it is constantly adhered to for all changes.
Conform to the changes in national payment mechanisms and support the development of information systems necessary to fulfil any requirements resulting from that guidance.
Assist the management of necessary changes within the data warehouse and the Trusts Electronic Patient Records (EPRs), liaising with system experts and the internal applications team throughout the systems life cycle to ensure that the warehouse is synchronised with the frequent changes/updates within the EPR.
Develop and provision appropriate tools to support data collection processes which sit outside of core clinical systems and allow them to be stored in the Trusts DWH.
To analyse highly complex issues and using a number of different sources such as patient clinical records, clinical information systems, demographic systems and external sources, interpret the information to determine correct outcomes using judgement when information is not clearly defined.
Developing collaborative partnerships and effective working relationships with colleagues in other teams/directorates and healthcare organisations to deliver a cohesive approach to the provision and use of information.
Working with senior colleagues in shaping strategy and policy for the Health Intelligence team, promoting a culture of evidence-based decision making.
Representing the Health Intelligence Team at high profile and sensitive meetings, contributing to outcomes and maintaining the reputation of the department
Job description
Job responsibilities
Responsible for the overall management of the Trusts Data Warehouse and the team which support it.
Responsible for end-to-end data provision, ensuring that data is acquired in an efficient and complete manner before transforming it and provisioning back to users in a transparent and well documented fashion.
Develop and oversee highly complex Extract, Transform and Load (ETL) processes and manage Azure SQL (and legacy Microsoft SQL server/Oracle) databases.
To be the lead technical expert and provide highly specialist technical support and advice for the existing set of database applications.
Ensure the Trust submits accurate and timely national returns such as the ECDS and CDS, which is the published record of the Trusts activity and the mechanism by which it receives its income.
Develop and maintain technical standard operating procedures used by the Data Warehouse team and ensure they are followed.
Manage the Data Warehouse system architecture, assess whether data items/tables are correct, ensure data anomalies identified are investigated and instigate corrective action where required.
Develop and automate quality assurance procedures, establish audit trails for each item of data being held & reported in the warehouse to enable data validation tests to be applied.
Ensure version control framework is applied to the Data Warehouse.
Manage the system administration of the Data Warehouse and Trusts business intelligence reporting systems as required, e.g. manage access rights of users giving them role-based access rights to certain data only, setting up groups and managing licenses; be a principle point of contact to solve reporting system problems.
Support and contribute to the development of the Federated Data Platform canonical data model and rollout of products across UHN by ensuring availability of data.
Ensure appropriate security controls are in place for access to data and that appropriate data security policy is adhered to within the team.
Ensure information is processed in accordance with Information Governance Policy.
Support the process of options appraisals, procurement and implementation of new technologies/products used to implement the Data Warehouse.
Pro-actively review new and emerging technologies and their potential benefit to the Trust, and where relevant develop business cases for these technologies.
Provide and analyse complex and sensitive datasets to support the wider Health Intelligence teams delivery.
Advise key internal customers/stakeholders on management and storage of datasets and analysis tools available to them.
Support the documented change control process and ensure it is constantly adhered to for all changes.
Conform to the changes in national payment mechanisms and support the development of information systems necessary to fulfil any requirements resulting from that guidance.
Assist the management of necessary changes within the data warehouse and the Trusts Electronic Patient Records (EPRs), liaising with system experts and the internal applications team throughout the systems life cycle to ensure that the warehouse is synchronised with the frequent changes/updates within the EPR.
Develop and provision appropriate tools to support data collection processes which sit outside of core clinical systems and allow them to be stored in the Trusts DWH.
To analyse highly complex issues and using a number of different sources such as patient clinical records, clinical information systems, demographic systems and external sources, interpret the information to determine correct outcomes using judgement when information is not clearly defined.
Developing collaborative partnerships and effective working relationships with colleagues in other teams/directorates and healthcare organisations to deliver a cohesive approach to the provision and use of information.
Working with senior colleagues in shaping strategy and policy for the Health Intelligence team, promoting a culture of evidence-based decision making.
Representing the Health Intelligence Team at high profile and sensitive meetings, contributing to outcomes and maintaining the reputation of the department
Person Specification
Education & Quals
Essential
- Educated to Masters level or equivalent level of education, training or experience.
- Evidence of continuing professional development
- Management qualifications or demonstrable experience
Knowledge & Experience
Essential
- Experience of running complex data / data warehouse services, leading the design, deployment and operating of mission-critical services
- Substantial experience designing, developing, and maintaining ETL pipelines using tools such as SSIS, Azure Data Factory, Informatica, or equivalent.
- Proven experience in ensuring new developments and data structures align with an established data model and adhere to agreed design principles.
- Knowledge of using different data architecture layers (i.e. staging, integration, presentation and semantic layers) in the production of analytics and dashboard creation.
- Database administration experience gained within a busy digital operations department.
- Knowledge of NHS data definitions, standards, data manual and statutory requirements.
- Supervision and direct line management of teams - including (but not limited to) - recruitment, capability and performance, training, leadership, motivation, sickness absence
Skills Pt1
Essential
- Ability to write complex T-SQL for data transformation, analysis and reporting
- Ability to support the Microsoft Azure data platform, including Azure SQL Database, Azure Data Factory instead of Microsoft SQL toolset
- Ability to rigorously maintain a robust documentation suite, including standard operating procedures and a target data model and design principles.
Skills Pt2
Essential
- Ability to manage a substantial area of work under own initiative
- Ability to plan and prioritise own workload, liaise and negotiate with 'customers' to agree and adjust work plans
- Ability to present complex information to non-technical audiences
Person Specification
Education & Quals
Essential
- Educated to Masters level or equivalent level of education, training or experience.
- Evidence of continuing professional development
- Management qualifications or demonstrable experience
Knowledge & Experience
Essential
- Experience of running complex data / data warehouse services, leading the design, deployment and operating of mission-critical services
- Substantial experience designing, developing, and maintaining ETL pipelines using tools such as SSIS, Azure Data Factory, Informatica, or equivalent.
- Proven experience in ensuring new developments and data structures align with an established data model and adhere to agreed design principles.
- Knowledge of using different data architecture layers (i.e. staging, integration, presentation and semantic layers) in the production of analytics and dashboard creation.
- Database administration experience gained within a busy digital operations department.
- Knowledge of NHS data definitions, standards, data manual and statutory requirements.
- Supervision and direct line management of teams - including (but not limited to) - recruitment, capability and performance, training, leadership, motivation, sickness absence
Skills Pt1
Essential
- Ability to write complex T-SQL for data transformation, analysis and reporting
- Ability to support the Microsoft Azure data platform, including Azure SQL Database, Azure Data Factory instead of Microsoft SQL toolset
- Ability to rigorously maintain a robust documentation suite, including standard operating procedures and a target data model and design principles.
Skills Pt2
Essential
- Ability to manage a substantial area of work under own initiative
- Ability to plan and prioritise own workload, liaise and negotiate with 'customers' to agree and adjust work plans
- Ability to present complex information to non-technical audiences
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).
