Senior Data Warehouse Research Analyst & Developer
This job is now closed
Job summary
This new role is responsible for the management and upskilling of other designated team members to provide resilience in the design, configuration, embedding and operation of the research technologies in use. Supporting both research and innovation pathways, the post holder will also feed into project design and delivery to ensure the proposed solutions are sufficiently resourced to meet the expressed and implicit needs of the service.
Main duties of the job
Administration of the Data Warehouse to enable and fulfil the data management requirements of the Trust
Ensuring that data is managed and optimised within the Data Warehouse
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
21 July 2023
Pay scheme
Agenda for change
Band
Band 7
Salary
£43,742 to £50,056 a year per annum
Contract
Fixed term
Duration
12 months
Working pattern
Full-time, Part-time, Flexible working, Home or remote working
Reference number
301-SP-23-5481415
Job locations
St George's Hospital
Stafford / Stoke on Trent
ST16 3SR
Job description
Job responsibilities
Provide Application development as necessary in development of the in-house systems to support the delivery of research projects
Support the R&I function in advising on grant submissions and queries
To be a source of expertise for all digital research, working across the portfolio of studies and projects adopted and undertaken by the Trust
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 security and ETL procedures between the Data Warehouse and Research environments
Perform the design and extension of data marts, metadata, and data models
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
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
To attend meetings on behalf of Application Development and /or Information and Contracting Team as required.
ReportingTo 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 Research 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.
Application DevelopmentResponsible for the design and implementation of technical architectures to meet R&I requirements.
Anticipate, plan and communicate change requirements to the various HIS infrastructure BAU technical support units to be able to cope with changes in advance of requirements.
Establish and maintain Technical Design Authority processes for new implementations and changes to the IT infrastructure relating to Integration.
Provide overall technical ownership of the integration and ERP architecture, which includes any in-house or third party applications or systems, on an ongoing basis.
Ensure that solutions are designed to operate effectively and have the best balance of economical, efficiency, security and resilience considerations to fit with requirements. Services should be standardised and scalable as much as possible but may need to be customised for particular requirements.
Document, cost and describe the benefits of options and proposed solutions to key stakeholders that may include internal departments, customers and 3rd party providers.
Define specifications of requirements and evaluate supplier responses for procurements.
Work with key suppliers and technology providers to ensure full optimisation of new technologies for the environment and ensure that learning is disseminated across nominated team members
Specify acceptance test requirements and participate in acceptance testing/deployment activities. Provide assurance that delivered solutions meet the design specification requirements.
Provide clear and concise handover documentation where appropriate for use by other departments.
To undertake training in appropriate incumbent integration and ERP technologies and to research and make recommendations regarding future technologies to support the integration agenda. To cascade and support upskilling of junior staff to ensure resilience across the function.
Process management
To continually document the processes associated with the practical integration of systems,
To be responsible for maintaining all project documentation and ensuring format consistency across different system integration models. To support the development of an organisational IM&T knowledge base.
To ensure processes and reports are modified when changes are made to integration specifications in order that they can be communicated.
Systems Analysis and Design
To support the Head of Application Development with the development of information & performance strategies & frameworks and in mapping information needs and identifying and implementing possible system and technical operational solutions
To support the Information and Data Warehousing function to ensure that the developed integration architecture is consistent, documented and supports the internal and external reporting agenda.
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.
Decisions and judgements
- Analyses, investigates and resolves activity queries and discrepancies from managers and teams, including the use of complex calculations.
- 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
Discusses sometimes contentious and sensitive information that requires tact and persuasion.
To advise staff of technical options available and make recommendations to address data quality and performance issues.
To make formal and informal presentations to research and educational 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.
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 from Research and Innovation Dept and Keele University. They will need to work closely with staff, including academics 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 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
Provide Application development as necessary in development of the in-house systems to support the delivery of research projects
Support the R&I function in advising on grant submissions and queries
To be a source of expertise for all digital research, working across the portfolio of studies and projects adopted and undertaken by the Trust
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 security and ETL procedures between the Data Warehouse and Research environments
Perform the design and extension of data marts, metadata, and data models
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
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
To attend meetings on behalf of Application Development and /or Information and Contracting Team as required.
ReportingTo 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 Research 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.
Application DevelopmentResponsible for the design and implementation of technical architectures to meet R&I requirements.
Anticipate, plan and communicate change requirements to the various HIS infrastructure BAU technical support units to be able to cope with changes in advance of requirements.
Establish and maintain Technical Design Authority processes for new implementations and changes to the IT infrastructure relating to Integration.
Provide overall technical ownership of the integration and ERP architecture, which includes any in-house or third party applications or systems, on an ongoing basis.
Ensure that solutions are designed to operate effectively and have the best balance of economical, efficiency, security and resilience considerations to fit with requirements. Services should be standardised and scalable as much as possible but may need to be customised for particular requirements.
Document, cost and describe the benefits of options and proposed solutions to key stakeholders that may include internal departments, customers and 3rd party providers.
Define specifications of requirements and evaluate supplier responses for procurements.
Work with key suppliers and technology providers to ensure full optimisation of new technologies for the environment and ensure that learning is disseminated across nominated team members
Specify acceptance test requirements and participate in acceptance testing/deployment activities. Provide assurance that delivered solutions meet the design specification requirements.
Provide clear and concise handover documentation where appropriate for use by other departments.
To undertake training in appropriate incumbent integration and ERP technologies and to research and make recommendations regarding future technologies to support the integration agenda. To cascade and support upskilling of junior staff to ensure resilience across the function.
Process management
To continually document the processes associated with the practical integration of systems,
To be responsible for maintaining all project documentation and ensuring format consistency across different system integration models. To support the development of an organisational IM&T knowledge base.
To ensure processes and reports are modified when changes are made to integration specifications in order that they can be communicated.
Systems Analysis and Design
To support the Head of Application Development with the development of information & performance strategies & frameworks and in mapping information needs and identifying and implementing possible system and technical operational solutions
To support the Information and Data Warehousing function to ensure that the developed integration architecture is consistent, documented and supports the internal and external reporting agenda.
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.
Decisions and judgements
- Analyses, investigates and resolves activity queries and discrepancies from managers and teams, including the use of complex calculations.
- 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
Discusses sometimes contentious and sensitive information that requires tact and persuasion.
To advise staff of technical options available and make recommendations to address data quality and performance issues.
To make formal and informal presentations to research and educational 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.
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 from Research and Innovation Dept and Keele University. They will need to work closely with staff, including academics 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 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)
Personal Attributes
Essential
- Personal Attributes (Person Specification found in JD document attached)
Desirable
- Personal Attributes (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)
Personal Attributes
Essential
- Personal Attributes (Person Specification found in JD document attached)
Desirable
- Personal Attributes (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
Stafford / Stoke on Trent
ST16 3SR
Employer's website
Employer details
Employer name
Midlands Partnership NHS Foundation Trust
Address
St George's Hospital
Stafford / Stoke on Trent
ST16 3SR
Employer's website
Employer contact details
For questions about the job, contact:
Details
Date posted
21 July 2023
Pay scheme
Agenda for change
Band
Band 7
Salary
£43,742 to £50,056 a year per annum
Contract
Fixed term
Duration
12 months
Working pattern
Full-time, Part-time, Flexible working, Home or remote working
Reference number
301-SP-23-5481415
Job locations
St George's Hospital
Stafford / Stoke on Trent
ST16 3SR
Supporting documents
Privacy notice
Midlands Partnership NHS Foundation Trust's privacy notice (opens in a new tab)