Job summary
This is a hybrid position combining on-site and home working as required.
Interviews will be face to face at the Northampton site.
The Systems Analyst/Developer will support, create and populate data models, data marts, data warehouses and their maintenance to enable Health Intelligence to provide effective decision support and enable strategic planning.
The post holder will require experience in data warehouses, data marts and OLAP models together with a working knowledge and experience of ETL design, development and testing. Additionally, the post holder will require experience of stakeholder engagement and technical requirement engineering for data warehousing.
This is a backend role as well as a stakeholder engagement role that brings together the data needs for all respective data domains along their conformed dimensional designs to enable the eventual build of an enterprise data warehouse. It is expected that the postholder will learn and adopt new data warehousing methods as deemed appropriate and beneficial for the group.
Main duties of the job
One of the postholder's primary responsibilities will be to support the population of data models to support the analytic/insight needs of the group. It is therefore expected that the post holder will work in conjunction with colleagues cross the team to transform business requirements into technical concepts so that effective data models can be built to serve the analytic/insight needs of the group.
This will involve integrating data from many disparate sources while implementing best of breed design principles to capture and store the data for expedient analysis and future reporting. This function is an evolving function and it is not expected that all requirements will be documented upfront.
The postholder will be expected to follow through on good governance around change control. Additionally, change control guidance will need to be rigorously adhered to ensure that existing reports and analysis do not incur unintentional detrimental consequences as a result of any change initiatives/improvements. It is expected that the postholder will have some experience/exposure in identifying analytics and reporting dependencies within any existing data structure.
About us
Northampton General Hospital is one of the largest employers in the area and we are on an exciting journey. All of our divisions are committed to doing things better, with more efficiency as we update, modernise, and advance. We have also entered into a Group Model with neighbouring Kettering General Hospital NHS Foundation Trust 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. As an organisation, we value how we communicate and promote our vacancies to all communities.
We are a Defence positive trust, supporting our reservists, veterans, spouses and partners.
The Hospital Group encourages applications from people who identify from all protected groups, especially those from BAME, Disabled and LGBTQ+ backgrounds as these are underrepresented in our hospitals.
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 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
Service and Business Management
Supports the capture, transformation and loading of data. Ensures this activity is undertaken in a timely manner in order to facilitate and support the submission of information for monitoring Trust activity as well as statutory/contractual returns.
Supports the groups data management function.
Supports the data capture, storage and retrieval for the group and groups initiatives from a data perspective.
Proactively supports the transformation to cloud-based infrastructure
Proactively engages with colleagues and other key contacts to achieve a shared understanding of requirements and to support the development of effective working relationships.
Provides advice and expertise on data capture, transformation, loading and retrieval.
Supports the management of projects to develop and implement data collection processes and produces information to meet defined reporting and information requirements. Interrogates information systems using database query tools/reportingpackages and creates complex queries to meet specific information requests.
Supports the development of innovative ways of integrating complex information so that it is clear and understandable to an analyst with appropriate documentation
Develops and implements training/facilitation packages on data sources and definitions, ensuring content and methods of delivery are appropriate for the analyst at various levels.
Implements processes to investigate data errors, identifying and analysing sources of variations or errors in information reports, monitoring and auditing data quality and working with services to improve the quality and integrity of the information in the Trusts Patient Administration System (PAS) with significant impact on patient care and Trust finances.
Sources information and keeps up-to-date on new data sources to support benchmarking and project work.
Regularly undertakes audits of ETL processes and data models.
Ensures information is processed in accordance with Information Governance Policy.
Continuously develops and improves knowledge and skills in a range of data models and development/architectural methodologies
Proactively develops and maintains effective liaison and communication with key stakeholders to ensure all relevant data is captured to enable analytics for decision support and planning.
Develops collaborative partnerships and effective working relationships with colleagues in other teams/directorates and healthcare organisations to deliver a cohesive approach to data management in the county.
Undertakes other tasks as required by the Chief Data Architect and Group Head of Health Intelligence
Job description
Job responsibilities
Service and Business Management
Supports the capture, transformation and loading of data. Ensures this activity is undertaken in a timely manner in order to facilitate and support the submission of information for monitoring Trust activity as well as statutory/contractual returns.
Supports the groups data management function.
Supports the data capture, storage and retrieval for the group and groups initiatives from a data perspective.
Proactively supports the transformation to cloud-based infrastructure
Proactively engages with colleagues and other key contacts to achieve a shared understanding of requirements and to support the development of effective working relationships.
Provides advice and expertise on data capture, transformation, loading and retrieval.
Supports the management of projects to develop and implement data collection processes and produces information to meet defined reporting and information requirements. Interrogates information systems using database query tools/reportingpackages and creates complex queries to meet specific information requests.
Supports the development of innovative ways of integrating complex information so that it is clear and understandable to an analyst with appropriate documentation
Develops and implements training/facilitation packages on data sources and definitions, ensuring content and methods of delivery are appropriate for the analyst at various levels.
Implements processes to investigate data errors, identifying and analysing sources of variations or errors in information reports, monitoring and auditing data quality and working with services to improve the quality and integrity of the information in the Trusts Patient Administration System (PAS) with significant impact on patient care and Trust finances.
Sources information and keeps up-to-date on new data sources to support benchmarking and project work.
Regularly undertakes audits of ETL processes and data models.
Ensures information is processed in accordance with Information Governance Policy.
Continuously develops and improves knowledge and skills in a range of data models and development/architectural methodologies
Proactively develops and maintains effective liaison and communication with key stakeholders to ensure all relevant data is captured to enable analytics for decision support and planning.
Develops collaborative partnerships and effective working relationships with colleagues in other teams/directorates and healthcare organisations to deliver a cohesive approach to data management in the county.
Undertakes other tasks as required by the Chief Data Architect and Group Head of Health Intelligence
Person Specification
Skills
Essential
- Ability to analyse, investigate and resolve complex problems and queries.
- Advance level proficiency the use of SQL Server Integration Systems (SSIS) and SQL Server Reporting Systems (SSRS)
Desirable
- Skill in design of data warehouse and information visualisation platforms
- Expert level proficiency in using SQL including complex correlated queries, triggers, functions, stored procedures, cursors, table value expressions
Knowledge and Experience
Essential
- Experience of troubleshooting technical and performance problems with SQL Server architectures.
- Has demonstrable experience/ability in the analysis of complex user and systems requirements and the translation of these requirements into the successful design, build, and implementation of information systems.
- Knowledge and experience of using staging, integration, presentation and semantic layers in the production of analytics and dashboard creation
- Demonstrate the ability to plan, organise and prioritise workload according to the demands of conflicting and unpredictable requests.
Desirable
- Knowledge and experience of statutory reporting
- Detailed knowledge and application of performance management tools and techniques and the development and use of balanced scorecards / dashboards.
Education
Essential
- Educated to degree level in a numerate/ quantitative discipline with a degree or equivalent experience and competencies and extensive relevant senior experience.
- Evidence of continuing professional development
Desirable
- Management qualifications.
- IT, Information or statistical qualification
Person Specification
Skills
Essential
- Ability to analyse, investigate and resolve complex problems and queries.
- Advance level proficiency the use of SQL Server Integration Systems (SSIS) and SQL Server Reporting Systems (SSRS)
Desirable
- Skill in design of data warehouse and information visualisation platforms
- Expert level proficiency in using SQL including complex correlated queries, triggers, functions, stored procedures, cursors, table value expressions
Knowledge and Experience
Essential
- Experience of troubleshooting technical and performance problems with SQL Server architectures.
- Has demonstrable experience/ability in the analysis of complex user and systems requirements and the translation of these requirements into the successful design, build, and implementation of information systems.
- Knowledge and experience of using staging, integration, presentation and semantic layers in the production of analytics and dashboard creation
- Demonstrate the ability to plan, organise and prioritise workload according to the demands of conflicting and unpredictable requests.
Desirable
- Knowledge and experience of statutory reporting
- Detailed knowledge and application of performance management tools and techniques and the development and use of balanced scorecards / dashboards.
Education
Essential
- Educated to degree level in a numerate/ quantitative discipline with a degree or equivalent experience and competencies and extensive relevant senior experience.
- Evidence of continuing professional development
Desirable
- Management qualifications.
- IT, Information or statistical qualification
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).
