Health Intelligence Systems Analyst Developer

Northampton General Hospital

This job is now closed

Job summary

Are you looking for your next challenge in digital?

We are pleased to be able to offer an exciting opportunity to join the Electronic Patient Record (EPR) Programme Team at Northampton General Hospital. In partnership with our chosen supplier, we have embarked on our digital excellence journey to implement a nationally-leading EPR system that will transform the quality of care for our patients and staff by having instantly accessible information using the latest mobile technology, reducing paper usage and utilising clinical decision support tools.

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 as part of the Trust Electronic Patient Record (EPR) Programme. As part of a dynamic and agile team that is committed to our Vision 'Dedicated to Excellence', you will have significant personal opportunities to grow and develop, as well as to tangibly impact how care is delivered in the future.

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.

Travel to the hospital site will be required.

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.

Date posted

02 April 2024

Pay scheme

Agenda for change

Band

Band 5

Salary

£28,407 to £34,581 a year per annum pro rate

Contract

Fixed term

Duration

2 years

Working pattern

Full-time, Flexible working

Reference number

254-6172534

Job locations

Northampton General Hospital

Cliftonville Road

Northampton

NN1 5BD

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/reporting packages 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.

Other Responsibilities

To develop, maintain and evolve various data management structures and routines to populate data models.
To develop and maintain real-time data feeds enabling real-time reporting.
To develop and maintain real-time reporting on the groups data landscape.
To create and load the necessary data into various data marts that may be beneficial for any improvement programme.
To review, optimize, and tune existing stored procedures ETL algorithms and functions, ensure better performance; monitor server processes, back up and restore databases.
To design, implement, and maintain full life cycle databases driven by feeds through FTP and websites and to provide data in XML to various websites.
To design, implement, and maintain the flow of data to Onix XML parser and X12 parser, transfer, and to process data in different formats.
To have a working knowledge and understanding of acute datasets.
To administer and maintain security and performance backups and recovery.
To lead on the development of Information Systems within the organisation utilising Microsoft T-SQL, SSIS and other business intelligence tools.
To communicate complex or sensitive information pertaining to data processing to a diverse. audience in an easily understandable manner.
To demonstrate good judgement about complex PBR and non PBR activities at the Trust.
To lead, design and develop data solutions to enable robust and timely analytics and reporting.
To proactively identify and resolve data quality issues in production systems where appropriate
To design, develop, test and implement automated data solutions to minimise manual intervention.
To support the Chief Data Architect in encouraging a practice and culture of continuous improvement.
To ensure that best practice is customary and adhered to in the department as well as ensuring that adequate documentation is created and maintained.
To liaise with information colleagues, internal and external, regarding data quality issues.
To support data capture from other sources external to the group.
To ensure that the data used for analysis is complete, correct and consistent
To be supportive of all data management activities required by the group and to lead in those areas where the Chief Data Architect thinks it appropriate.
To be able to frequently work with a high degree of intensity and concentration.
To ensure all new national guidelines around PBR are correctly processed and available
To communicate complex analytical matters to other professionals and advise accordingly.
To be able to work on own initiative, planning, organising and managing own workload. accordingly and reprioritising as necessary and taking advice from the Group Head of Health Intelligence.
To be aware of and comply with legislation and data quality policies and procedures, implementing these and proposing changes to working practices as a result of new policies, procedures or legislation.
To proactively engage with colleagues in the group and other key contacts to achieve a shared understanding of information requirements and support the development of effective working relationships.
To represent Health Intelligence at meetings as appropriate.
To support the Chief Data Architect in the maintenance of enterprise level conceptual, logical and physical data models for information provision.
The role is expected to provide mentoring to junior colleagues in the department. This will involve delivering specialist training
To undertake other duties as required by the Group Head of Health Intelligence.

Please see job description for further details

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/reporting packages 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.

Other Responsibilities

To develop, maintain and evolve various data management structures and routines to populate data models.
To develop and maintain real-time data feeds enabling real-time reporting.
To develop and maintain real-time reporting on the groups data landscape.
To create and load the necessary data into various data marts that may be beneficial for any improvement programme.
To review, optimize, and tune existing stored procedures ETL algorithms and functions, ensure better performance; monitor server processes, back up and restore databases.
To design, implement, and maintain full life cycle databases driven by feeds through FTP and websites and to provide data in XML to various websites.
To design, implement, and maintain the flow of data to Onix XML parser and X12 parser, transfer, and to process data in different formats.
To have a working knowledge and understanding of acute datasets.
To administer and maintain security and performance backups and recovery.
To lead on the development of Information Systems within the organisation utilising Microsoft T-SQL, SSIS and other business intelligence tools.
To communicate complex or sensitive information pertaining to data processing to a diverse. audience in an easily understandable manner.
To demonstrate good judgement about complex PBR and non PBR activities at the Trust.
To lead, design and develop data solutions to enable robust and timely analytics and reporting.
To proactively identify and resolve data quality issues in production systems where appropriate
To design, develop, test and implement automated data solutions to minimise manual intervention.
To support the Chief Data Architect in encouraging a practice and culture of continuous improvement.
To ensure that best practice is customary and adhered to in the department as well as ensuring that adequate documentation is created and maintained.
To liaise with information colleagues, internal and external, regarding data quality issues.
To support data capture from other sources external to the group.
To ensure that the data used for analysis is complete, correct and consistent
To be supportive of all data management activities required by the group and to lead in those areas where the Chief Data Architect thinks it appropriate.
To be able to frequently work with a high degree of intensity and concentration.
To ensure all new national guidelines around PBR are correctly processed and available
To communicate complex analytical matters to other professionals and advise accordingly.
To be able to work on own initiative, planning, organising and managing own workload. accordingly and reprioritising as necessary and taking advice from the Group Head of Health Intelligence.
To be aware of and comply with legislation and data quality policies and procedures, implementing these and proposing changes to working practices as a result of new policies, procedures or legislation.
To proactively engage with colleagues in the group and other key contacts to achieve a shared understanding of information requirements and support the development of effective working relationships.
To represent Health Intelligence at meetings as appropriate.
To support the Chief Data Architect in the maintenance of enterprise level conceptual, logical and physical data models for information provision.
The role is expected to provide mentoring to junior colleagues in the department. This will involve delivering specialist training
To undertake other duties as required by the Group Head of Health Intelligence.

Please see job description for further details

Person Specification

Education, Training & Qualifications

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

Knowledge & Experience

Essential

Knowledge of working with health information systems, with proven ability to keep fully informed about emerging technology
Substantial technical database Administration experience gained within a busy IT operations department
Good database management skills
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
Knowledge in all the areas covered by a data management department
Experience of the NHS environment
Knowledge of Microsoft Products
Knowledge of MS SQL Business Intelligence tools
Knowledge of NHS Information flows and requirements
Working knowledge and understanding of NHS policy and its relevance to commissioning and contracting
Experience of resolving urgent, complex technical problems in live systems in a structured and consistent manner and in a way that minimizes risk to systems, patients and staff
Demonstrate the ability to plan, organise and prioritise workload according to the demands of conflicting and unpredictable requests.
Responsibility for patient confidentiality issues, ensuring data protection act is adhered to
Good communication skills in order to provide and receive information which may be complex
Substantial recent experience of working in NHS Informatics/Performance management
Working knowledge and experience of building incremental, iterative and collaborative data models
Working knowledge and experience of creating functions in SQL
Working knowledge and experience of SQL Server SSIS

Desirable

Knowledge and experience of statutory reporting
Knowledge of NHS Data Definitions, Standards, Data Manual and statutory requirements.
Knowledge and experience of understanding user needs, seeking feedback and utilising user research methods to improve reporting, analytics and insight delivery
Working knowledge and experience of working with data quality teams to improve the quality of data at source
Knowledge of Freedom of Information Legislation, Data Protection Act etc
Knowledge of the Information Governance agenda
Highly developed specialist knowledge and understanding of Information Governance Toolkit especially in relation to Information Quality Assurance
Experience of staff management including personal development reviews and recruitment
Experience of delivering presentations to large and diverse groups
Experience of working within multi-disciplinary teams
Detailed knowledge and application of performance management tools and techniques and the development and use of balanced scorecards / dashboards
Experience of dealing with National NHS organisations such as the Department of Health and Social Care and CCGs
Experience of working within agile methodology
Knowledge and experience of populating a data model that supports a real-time dashboard for operational/clinical management
Working knowledge of decision-oriented data warehousing
Working knowledge of SSRS
Working knowledge and experience in R
Working knowledge and experienced in python
Experience in writing parameterised stored procedures
Working knowledge of Microsoft Azure environments
Working knowledge and experience of linear regression
Working knowledge of analytic functions in SQL
Working knowledge of integrating Power BI reports with multiple data sources
Working knowledge and experience of SPC charts, technical data models, writing DAX queries, creating calculations and measures, bespoke functions and integrating multiple data sources in Power BI

Skills

Essential

Ability to problem solve and identify/promote solutions
Ability to use professional judgement and advise others on best practice, national guidelines and legislation on Information Management
Ability to analyse, investigate and resolve complex problems and queries
Ability to create reports using appropriate profiling tools - to look at validity, completeness, integrity, coverage, accuracy and timeliness
Ability to focus in stressful situations and work effectively under pressure
Ability to manage a substantial area of work under own initiative
Ability to write extensive user stories
Ability to conceptualise data models/applications and communicate to a diverse stakeholder audience including non-technical colleagues
Ability to manage the data models of all the various layers
Ability to build incremental data models
Advance level proficiency the use of SQL Server Integration Systems (SSIS) and SQL Server Reporting Systems (SSRS)
Proficiency in Microsoft Office products including advanced skills in Microsoft Excel
Excellent skills in developing effective working relationships
Good eye for detail
Ability to present complex information to non-technical audiences
Experienced of developing reports in Power BI
Working knowledge and experience of query optimisation
Significant experience of writing SQL queries for reporting- complex correlated queries, subqueries
Significant experience of using SQL aggregate functions
Ability to compile and initiate audits and present findings
Skilled in SQL database design and maintenance
Advanced skills in Microsoft product range
Ability to communicate both in written and verbal forms with a wide range of disciplines
Ability to foster and maintain positive working and customer relationships
Ability to work in a confidential manner
Ability to respond effectively to changing priorities, to manage timeframes with the ability to meet deadlines
Excellent planning and organisational skills
Ability to think creatively and identify solutions to overcome problems
Ability to use recovery models in Microsoft SQL Server
Ability backup and restore databases

Desirable

Expert level proficiency in using SQL including complex correlated queries, triggers, functions, stored procedures, cursors, table value expressions
Skill in design of data warehouse and information visualisation platforms
Ability to use multiple statistical methods to generate insight
Ability to work with and influence senior colleagues using negotiation and persuasion skills
Ability to recognise own and others development needs and find appropriate solutions
Ability to design, develop, test and implement security models
Ability to manage alerts and notifications to provide assurance that automated processes were executed as they should
Ability to monitor SQL Server Infrastructure
Proven ability to mentor others

Key Competencies/ Personal Qualities & Attributes

Essential

Passionate and committed to bring our Dedicated to Excellence values to life, improving the way we work with each other, particularly focusing on empowerment, equality diversity and inclusion of our staff, patients and service users
Ability to work as part of a duty roster including weekends and public holidays
Ability to travel to the Northampton Hospital site and to other sites across the Group

Person Specification

Education, Training & Qualifications

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

Knowledge & Experience

Essential

Knowledge of working with health information systems, with proven ability to keep fully informed about emerging technology
Substantial technical database Administration experience gained within a busy IT operations department
Good database management skills
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
Knowledge in all the areas covered by a data management department
Experience of the NHS environment
Knowledge of Microsoft Products
Knowledge of MS SQL Business Intelligence tools
Knowledge of NHS Information flows and requirements
Working knowledge and understanding of NHS policy and its relevance to commissioning and contracting
Experience of resolving urgent, complex technical problems in live systems in a structured and consistent manner and in a way that minimizes risk to systems, patients and staff
Demonstrate the ability to plan, organise and prioritise workload according to the demands of conflicting and unpredictable requests.
Responsibility for patient confidentiality issues, ensuring data protection act is adhered to
Good communication skills in order to provide and receive information which may be complex
Substantial recent experience of working in NHS Informatics/Performance management
Working knowledge and experience of building incremental, iterative and collaborative data models
Working knowledge and experience of creating functions in SQL
Working knowledge and experience of SQL Server SSIS

Desirable

Knowledge and experience of statutory reporting
Knowledge of NHS Data Definitions, Standards, Data Manual and statutory requirements.
Knowledge and experience of understanding user needs, seeking feedback and utilising user research methods to improve reporting, analytics and insight delivery
Working knowledge and experience of working with data quality teams to improve the quality of data at source
Knowledge of Freedom of Information Legislation, Data Protection Act etc
Knowledge of the Information Governance agenda
Highly developed specialist knowledge and understanding of Information Governance Toolkit especially in relation to Information Quality Assurance
Experience of staff management including personal development reviews and recruitment
Experience of delivering presentations to large and diverse groups
Experience of working within multi-disciplinary teams
Detailed knowledge and application of performance management tools and techniques and the development and use of balanced scorecards / dashboards
Experience of dealing with National NHS organisations such as the Department of Health and Social Care and CCGs
Experience of working within agile methodology
Knowledge and experience of populating a data model that supports a real-time dashboard for operational/clinical management
Working knowledge of decision-oriented data warehousing
Working knowledge of SSRS
Working knowledge and experience in R
Working knowledge and experienced in python
Experience in writing parameterised stored procedures
Working knowledge of Microsoft Azure environments
Working knowledge and experience of linear regression
Working knowledge of analytic functions in SQL
Working knowledge of integrating Power BI reports with multiple data sources
Working knowledge and experience of SPC charts, technical data models, writing DAX queries, creating calculations and measures, bespoke functions and integrating multiple data sources in Power BI

Skills

Essential

Ability to problem solve and identify/promote solutions
Ability to use professional judgement and advise others on best practice, national guidelines and legislation on Information Management
Ability to analyse, investigate and resolve complex problems and queries
Ability to create reports using appropriate profiling tools - to look at validity, completeness, integrity, coverage, accuracy and timeliness
Ability to focus in stressful situations and work effectively under pressure
Ability to manage a substantial area of work under own initiative
Ability to write extensive user stories
Ability to conceptualise data models/applications and communicate to a diverse stakeholder audience including non-technical colleagues
Ability to manage the data models of all the various layers
Ability to build incremental data models
Advance level proficiency the use of SQL Server Integration Systems (SSIS) and SQL Server Reporting Systems (SSRS)
Proficiency in Microsoft Office products including advanced skills in Microsoft Excel
Excellent skills in developing effective working relationships
Good eye for detail
Ability to present complex information to non-technical audiences
Experienced of developing reports in Power BI
Working knowledge and experience of query optimisation
Significant experience of writing SQL queries for reporting- complex correlated queries, subqueries
Significant experience of using SQL aggregate functions
Ability to compile and initiate audits and present findings
Skilled in SQL database design and maintenance
Advanced skills in Microsoft product range
Ability to communicate both in written and verbal forms with a wide range of disciplines
Ability to foster and maintain positive working and customer relationships
Ability to work in a confidential manner
Ability to respond effectively to changing priorities, to manage timeframes with the ability to meet deadlines
Excellent planning and organisational skills
Ability to think creatively and identify solutions to overcome problems
Ability to use recovery models in Microsoft SQL Server
Ability backup and restore databases

Desirable

Expert level proficiency in using SQL including complex correlated queries, triggers, functions, stored procedures, cursors, table value expressions
Skill in design of data warehouse and information visualisation platforms
Ability to use multiple statistical methods to generate insight
Ability to work with and influence senior colleagues using negotiation and persuasion skills
Ability to recognise own and others development needs and find appropriate solutions
Ability to design, develop, test and implement security models
Ability to manage alerts and notifications to provide assurance that automated processes were executed as they should
Ability to monitor SQL Server Infrastructure
Proven ability to mentor others

Key Competencies/ Personal Qualities & Attributes

Essential

Passionate and committed to bring our Dedicated to Excellence values to life, improving the way we work with each other, particularly focusing on empowerment, equality diversity and inclusion of our staff, patients and service users
Ability to work as part of a duty roster including weekends and public holidays
Ability to travel to the Northampton Hospital site and to other sites across the Group

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.

Certificate of Sponsorship

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