Senior Data Warehouse Analyst
This job is now closed
Job summary
We are in the process of transforming the way we use data to drive improvement in the NHS. We want to hear from people who are passionate about optimising the accuracy of reports through continuous data quality and reporting methodology improvement.
Main duties of the job
We are looking to recruit an enthusiastic individual with experience in data extraction and analysis, as Senior Data Warehouse Analyst within our Data Warehousing Team. The post holder will work to relevant NHS Data Dictionary standards, NHS Financial Standards and local data definitions to meet the reporting needs of the Trust.
Main responsibilities:
- Administration of the Data Warehouse to enable and fulfil the clinical and corporate reporting requirements of the Trust
- Ensuring that data is managed and optimised within the Data Warehouse
- Assisting with the completion of returns such as external benchmarking network submissions.
About us
Midlands Partnership University NHS Foundation Trust is an award winning organisation with over 9000 employees. We're one of the largest integrated Health and Social Care providers, covering services across North & South Staffordshire, Shropshire, Hampshire, Buckinghamshire, Isle of Wight and Essex.
We pride ourselves on the services provided to support with the well-being of all of our employees both physically and mentally and offer counselling support and lifestyle information. We encourage career development provided by in house training programs and coaching support.
As part of our strong commitment to equality, diversity and inclusion, we welcome applications from candidates who meet the specific criteria, regardless of race, gender, religion, sexual orientation, age, physical and/or mental disability or offending background.
Details
Date posted
29 September 2023
Pay scheme
Agenda for change
Band
Band 7
Salary
£43,742 to £50,056 a year per annum
Contract
Fixed term
Duration
14 months
Working pattern
Full-time, Flexible working, Home or remote working
Reference number
301-SP-23-5551910-A
Job locations
St George's Hospital / Longton Cottage Hospital
Stafford / Stoke on Trent
ST16 3SR
Job description
Job responsibilities
KEY DUTIES AND RESPONSIBILITIES:
Design and implement Extraction, Transformation and Loading (ETL) procedures for intake of data from clinical and corporate systems, as well as ensure data is verified and quality is checked.
Optimize ETL procedures between the clinical and corporate systems and the Data Warehouse
Perform the design and extension of data marts, metadata, and data models
Support Application development as necessary in development of the in-house systems through configuration change requests and permissions management via an access control framework.
Be knowledgeable about a range of information query tools and languages
Support as required the Head of Data Architecture in investigating new methods of data manipulation and the most appropriate methods for ETL
Continuously maintain and enhance existing stored procedures, queries and reports
Develop clinical, operational and performance Data Warehouse reports
Analyses, interprets and resolves highly complex information problems where there is no precedent and where other leading opinions may conflict
Adapt, design and improve systems used to store and disseminate information
Troubleshoot errors and problems with databases and extracts
Ensure that documentation related to the Data Warehouse architecture, codes, ETL process and Data Warehouse reports is kept up-to-date and maintained in a version control system
Ensure that any changes in systems data sets are properly managed in the ETL process
Develop test scenarios to test any changes affecting the Data Warehouse
Ensure the systematic documentation of all test issues following the internal testing process and ensure that all issues are reported
Support where needed the resolving of errors in the output of reports generated from the Data Warehouse
Reporting
To develop the performance and information analysis function, producing new reports, enhancing the skills of internal clients so they can extract their own reports, and participating in change management processes.
To work with the Business Intelligence team in providing high quality, accurate, validated and timely reports to internal stakeholders.
Support reporting solutions that enable stakeholders to quickly identify risks, trends and concerns, in order to make decisions with confidence and speed.
Contribute to reporting solutions, which provide operational services with intelligence concerning performance measures.
To provide statistical analysis and profiles of trends within patient and Trust performance information, highlighting variances from the norm, and share this knowledge with Trust managers and others, to support decision making and performance improvement.
To proactively review specialty or procedure based activity within Divisions, drawing appropriate attention to areas that may have a current or future impact on the performance of the Trust.
Provide support for Trust staff on their use of new and existing information applications in the effective use of the reporting systems and appropriate use of information.
To undertake detailed, complex investigation into sensitive areas, taking the lead in undertaking projects from inception to completion
Interpret information, highlighting trends and / or inconsistencies and undertake ad hoc data analysis to investigate any issues highlighted
Support the team in providing training and support on dashboards developed by the team
Support service improvement through the provision of accurate information, using analytical techniques to assess data quality and cleanse large volumes of highly complex datasets.
To interpret data requirements from non-technical staff, into technical specifications for the activity reporting systems. Interpret highly complex database processes and standards in a simplified manner for non-technical staff.
Benchmarking
To lead on the development and provision of benchmarking activity data within the Trust.
To develop benchmarking data, systems and reporting processes in readiness for the NHSI Model Hospital for non-acute services.
To assist in the production of regular benchmarking information to the Trust Board, the Finance & Performance Committee and Operational Forums.
Service/People Management
To provide a data warehouse function to BI, IM&T, Corporate and Clinical Services
Provide line management, support and training for members of the Data Warehouse Team including performance management when this may be required.
To promote and participate in the process of sharing knowledge of reporting, database and querying techniques, data standards and changes between team members.
Develop a good understanding of the Clinical Directorates and monitor and support their data quality processes, working closely with managers and key players to ensure all activity is captured and reported correctly.
Provide guidance to operational staff to ensure adherence to local and national data standards, including data dictionary and PbR guidance.
Support the development of front line staff so all operational managers are able to perform their own basic data quality analysis for their departments activity
Decisions and judgements
Analyses, investigates and resolves activity queries and discrepancies from managers and teams, including the use of complex calculations.
Involves explanations for information trends and movements. This includes providing reports, advice and recommendations to budget managers to enable informed business decisions.
Attend and provides advice within meetings with clinical and non-clinical budget managers, based upon experience and expertise in Trust performance.
Ability to prioritise and plan own work, work in an organised fashion, and cope with the pressures of ensuring continual deadlines are met is essential.
Communication and relationships
Discuss routine and complex performance issues by telephone, e-mail, in writing and meeting with colleagues, managers and teams. Relaying technical information to non-finance persons therefore requiring highly developed and effective communication skills.
Discusses sometimes contentious and sensitive information that requires tact and persuasion.
To advise clinical and managerial staff of technical options available and make recommendations to address data quality and performance issues.
To make formal and informal presentations to both finance and non-finance colleagues.
To provide specialist advice, guidance and support to non-technical staff in the interpretation and analysis of performance related activity.
Attend regional and national conferences and represent the Trust on working groups as appropriate.
Have a good knowledge of Payment by Results and Care Clustering and ensure that any changes to activity reporting are undertaken with an impact analysis on income and explicitly communicated to colleagues in Finance.
To advise the appropriate manager of issues with data such as changes to trends or unusual levels of activity.
Adhere to Trust Information Governance Policy; particularly with regard to data security and patient confidentiality
The post holder will be required to work with staff within the finance department. They will need to work closely with divisional staff, including senior management and clinicians.
To contribute as required, to working groups developing performance, information, or Information Governance policies, and to volunteer suggested improvements.
To raise awareness within the BI/ DW function of new guidance or legislation relating to data collection and submission, and of new performance analysis tools that may enhance the teams service to the Trust.
To assist in maintaining awareness of all changes within the NHS and the Trust that may affect the collection, use and distribution of information.
Physical demands of the job
Requires the ability to maintain and analyse highly complex patient related activity and information through appropriate database and reporting tools.
A high level of concentration is required on a daily basis for long periods of time. Additionally, unanticipated fluctuations in demand may require highly intense periods of activity within a complex and dynamic environment. There may be frequent interruptions to answer queries from staff and customers.
Requires a high level of experience and skilled use of IT systems and equipment. The post holder will be required to utilise highly developed keyboard skills in the manipulation and analysis of information and developing reports.
Delivery of complex analytical documents to short deadlines.
Requirement for light physical effort including a combination of sitting, standing and walking as required.
There will be occasional exposure to emotional circumstances when dealing with staff performance and disciplinary issues.
The post holder will be office based and will be required to attend meetings across the Trusts geography including National representation.
The post holder maybe asked to work from home for extended periods to support infection control.
Job description
Job responsibilities
KEY DUTIES AND RESPONSIBILITIES:
Design and implement Extraction, Transformation and Loading (ETL) procedures for intake of data from clinical and corporate systems, as well as ensure data is verified and quality is checked.
Optimize ETL procedures between the clinical and corporate systems and the Data Warehouse
Perform the design and extension of data marts, metadata, and data models
Support Application development as necessary in development of the in-house systems through configuration change requests and permissions management via an access control framework.
Be knowledgeable about a range of information query tools and languages
Support as required the Head of Data Architecture in investigating new methods of data manipulation and the most appropriate methods for ETL
Continuously maintain and enhance existing stored procedures, queries and reports
Develop clinical, operational and performance Data Warehouse reports
Analyses, interprets and resolves highly complex information problems where there is no precedent and where other leading opinions may conflict
Adapt, design and improve systems used to store and disseminate information
Troubleshoot errors and problems with databases and extracts
Ensure that documentation related to the Data Warehouse architecture, codes, ETL process and Data Warehouse reports is kept up-to-date and maintained in a version control system
Ensure that any changes in systems data sets are properly managed in the ETL process
Develop test scenarios to test any changes affecting the Data Warehouse
Ensure the systematic documentation of all test issues following the internal testing process and ensure that all issues are reported
Support where needed the resolving of errors in the output of reports generated from the Data Warehouse
Reporting
To develop the performance and information analysis function, producing new reports, enhancing the skills of internal clients so they can extract their own reports, and participating in change management processes.
To work with the Business Intelligence team in providing high quality, accurate, validated and timely reports to internal stakeholders.
Support reporting solutions that enable stakeholders to quickly identify risks, trends and concerns, in order to make decisions with confidence and speed.
Contribute to reporting solutions, which provide operational services with intelligence concerning performance measures.
To provide statistical analysis and profiles of trends within patient and Trust performance information, highlighting variances from the norm, and share this knowledge with Trust managers and others, to support decision making and performance improvement.
To proactively review specialty or procedure based activity within Divisions, drawing appropriate attention to areas that may have a current or future impact on the performance of the Trust.
Provide support for Trust staff on their use of new and existing information applications in the effective use of the reporting systems and appropriate use of information.
To undertake detailed, complex investigation into sensitive areas, taking the lead in undertaking projects from inception to completion
Interpret information, highlighting trends and / or inconsistencies and undertake ad hoc data analysis to investigate any issues highlighted
Support the team in providing training and support on dashboards developed by the team
Support service improvement through the provision of accurate information, using analytical techniques to assess data quality and cleanse large volumes of highly complex datasets.
To interpret data requirements from non-technical staff, into technical specifications for the activity reporting systems. Interpret highly complex database processes and standards in a simplified manner for non-technical staff.
Benchmarking
To lead on the development and provision of benchmarking activity data within the Trust.
To develop benchmarking data, systems and reporting processes in readiness for the NHSI Model Hospital for non-acute services.
To assist in the production of regular benchmarking information to the Trust Board, the Finance & Performance Committee and Operational Forums.
Service/People Management
To provide a data warehouse function to BI, IM&T, Corporate and Clinical Services
Provide line management, support and training for members of the Data Warehouse Team including performance management when this may be required.
To promote and participate in the process of sharing knowledge of reporting, database and querying techniques, data standards and changes between team members.
Develop a good understanding of the Clinical Directorates and monitor and support their data quality processes, working closely with managers and key players to ensure all activity is captured and reported correctly.
Provide guidance to operational staff to ensure adherence to local and national data standards, including data dictionary and PbR guidance.
Support the development of front line staff so all operational managers are able to perform their own basic data quality analysis for their departments activity
Decisions and judgements
Analyses, investigates and resolves activity queries and discrepancies from managers and teams, including the use of complex calculations.
Involves explanations for information trends and movements. This includes providing reports, advice and recommendations to budget managers to enable informed business decisions.
Attend and provides advice within meetings with clinical and non-clinical budget managers, based upon experience and expertise in Trust performance.
Ability to prioritise and plan own work, work in an organised fashion, and cope with the pressures of ensuring continual deadlines are met is essential.
Communication and relationships
Discuss routine and complex performance issues by telephone, e-mail, in writing and meeting with colleagues, managers and teams. Relaying technical information to non-finance persons therefore requiring highly developed and effective communication skills.
Discusses sometimes contentious and sensitive information that requires tact and persuasion.
To advise clinical and managerial staff of technical options available and make recommendations to address data quality and performance issues.
To make formal and informal presentations to both finance and non-finance colleagues.
To provide specialist advice, guidance and support to non-technical staff in the interpretation and analysis of performance related activity.
Attend regional and national conferences and represent the Trust on working groups as appropriate.
Have a good knowledge of Payment by Results and Care Clustering and ensure that any changes to activity reporting are undertaken with an impact analysis on income and explicitly communicated to colleagues in Finance.
To advise the appropriate manager of issues with data such as changes to trends or unusual levels of activity.
Adhere to Trust Information Governance Policy; particularly with regard to data security and patient confidentiality
The post holder will be required to work with staff within the finance department. They will need to work closely with divisional staff, including senior management and clinicians.
To contribute as required, to working groups developing performance, information, or Information Governance policies, and to volunteer suggested improvements.
To raise awareness within the BI/ DW function of new guidance or legislation relating to data collection and submission, and of new performance analysis tools that may enhance the teams service to the Trust.
To assist in maintaining awareness of all changes within the NHS and the Trust that may affect the collection, use and distribution of information.
Physical demands of the job
Requires the ability to maintain and analyse highly complex patient related activity and information through appropriate database and reporting tools.
A high level of concentration is required on a daily basis for long periods of time. Additionally, unanticipated fluctuations in demand may require highly intense periods of activity within a complex and dynamic environment. There may be frequent interruptions to answer queries from staff and customers.
Requires a high level of experience and skilled use of IT systems and equipment. The post holder will be required to utilise highly developed keyboard skills in the manipulation and analysis of information and developing reports.
Delivery of complex analytical documents to short deadlines.
Requirement for light physical effort including a combination of sitting, standing and walking as required.
There will be occasional exposure to emotional circumstances when dealing with staff performance and disciplinary issues.
The post holder will be office based and will be required to attend meetings across the Trusts geography including National representation.
The post holder maybe asked to work from home for extended periods to support infection control.
Person Specification
Qualifications and Training
Essential
- Qualifications and Training (Person Specification found in JD document attached)
Desirable
- Qualifications and Training (Person Specification found in JD document attached)
Experience
Essential
- Experience (Person Specification found in JD document attached)
Desirable
- Experience (Person Specification found in JD document attached)
Skills, Knowledge, and Abilities
Essential
- Skills, Knowledge and Abilities (Person Specification found in JD document attached)
Desirable
- Skills, Knowledge and Abilities (Person Specification found in JD document attached)
Person Specification
Qualifications and Training
Essential
- Qualifications and Training (Person Specification found in JD document attached)
Desirable
- Qualifications and Training (Person Specification found in JD document attached)
Experience
Essential
- Experience (Person Specification found in JD document attached)
Desirable
- Experience (Person Specification found in JD document attached)
Skills, Knowledge, and Abilities
Essential
- Skills, Knowledge and Abilities (Person Specification found in JD document attached)
Desirable
- Skills, Knowledge and Abilities (Person Specification found in JD document attached)
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
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).
Employer details
Employer name
Midlands Partnership NHS Foundation Trust
Address
St George's Hospital / Longton Cottage Hospital
Stafford / Stoke on Trent
ST16 3SR
Employer's website
Employer details
Employer name
Midlands Partnership NHS Foundation Trust
Address
St George's Hospital / Longton Cottage Hospital
Stafford / Stoke on Trent
ST16 3SR
Employer's website
Employer contact details
For questions about the job, contact:
Details
Date posted
29 September 2023
Pay scheme
Agenda for change
Band
Band 7
Salary
£43,742 to £50,056 a year per annum
Contract
Fixed term
Duration
14 months
Working pattern
Full-time, Flexible working, Home or remote working
Reference number
301-SP-23-5551910-A
Job locations
St George's Hospital / Longton Cottage Hospital
Stafford / Stoke on Trent
ST16 3SR
Supporting documents
Privacy notice
Midlands Partnership NHS Foundation Trust's privacy notice (opens in a new tab)