Job summary
The Great Western Hospital NHS Foundation Trust is excited to offer an opportunity for an ambitious individual to join our Data and Informatics team as a Data Warehouse Specialist Developer.
We are looking for a dynamic, forward thinking individual to work closely with the Data Architect to maintain and develop the Trust Data Warehouse and BI architecture including performance, maintainability and scalability along with a secure, governed and well architected data infrastructure.
This role will act as a technical expert to users both within the department and to other departments around the Trust in the following key areas:
- Microsoft SQL Server (T-SQL, SSIS, SSRS, SSAS)
- Data Warehousing Architectures
- Microsoft Power BI
- PostgreSQL
To be successful in this role you will have a real eye for detail, an analytical mind-set, excellent communication skills and a willingness to adapt your approach with our stakeholders and interpret requirements with the enthusiasm to get the job done to the highest standards.
Experience of working with NHS data is essential for this role.
Main duties of the job
Responsible for the maintenance and development of the Data Warehouse and BI architecture including performance, maintainability and scalability along with a secure, governed and well architected data infrastructure.
Act as a technical expert to users both within the department and to other departments around the Trust in the following key areas:
- Microsoft SQL Server (T-SQL, SSIS, SSRS, SSAS)
- Data Warehousing Architectures
- Microsoft Power BI
- PostgreSQL
This is an exciting time to join our Data and Informatics team, increasing demand on services means that healthcare in Swindon and Wiltshire is changing and being an integrated acute and community Foundation Trust means that we are at the forefront of the most exciting transformation the sector has seen.
We are seeking to fundamentally change the way we do things whilst always keeping the patient at the centre of everything we do. High quality information and analysis is at the core of this, so that our change is intelligent and evidence-based. The aim is not just to serve the local people - it's to offer outstanding services in appropriate care settings that exceed expectations.
About us
Our STAR values - Service, Teamwork, Ambition and Respect - are a golden thread running through everything we do. These values serve as a guiding principle, driving us towards our vision of delivering great joined up services to our local community. Whether at home, in the community, or within the hospital, our goal is to empower individuals to lead independent and healthier lives.
Job description
Job responsibilities
Data Warehouse & BI
- The post holder is responsible for the adaptation, support and development of the technologies and processes supporting the safe use of the Trust Data Warehouse & BI Platform (a major trust wide information system). Ensuring accurate data flows to support Trust Financial Reporting, Income Recovery, National Data Submissions and Internal reporting requirements.
- Provision of technical advice on all Data Warehousing and BI solutions within the Trust.
- To deputise for the Data Architect in all areas relating to support and maintenance of the Data Warehouse and related systems.
- Analyses, investigates and resolves complex queries, where there are a number of options; analyses user requirements which may require configuration of software and hardware
- Works to achieve agreed objectives and has freedom to do this in own way, working within broad professional policies; advises without reference to manager. Acts as a lead specialist in own area.
- Implements IM&T policies for own area and contributes to changes in BI policies and procedures for new reporting processes and BI delivery solutions which will impact throughout the Trust with responsibility to ensure written documentation is created and maintained
- Provides expert guidance and recommendations and will specify the best course of action to be taken where multiple options may exist, ensuring potential risk to patient care is kept to a minimum
- Responsible for managing the operations of delivery and storage of patient and staff identifiable information held within Trust developed BI solutions and the Data Warehouse. They are responsible for ensuring that the data is accurate, relevant, secure, auditable, and that data is suitably anonymised for use in BI solutions.
- Responsible for the speedy resolution of all non-routine problems with the Trust Data Warehouse, Integration Engine and BI solutions. This involves directly supporting the IT Service Desk, Support Analysts and the Trusts senior managers and requires a proven ability to control and manage crisis and disaster situations.
Reporting
- To provide technical and practical support to members of the Information Services team as required, relating to all aspects of SQL development and the Data Warehouse environment.
- To provide support and advice to ad hoc requesters of information, in developing suitable report formats to meet their requirements.
- To work with other team members to ensure that all information supplied to customers is of the highest possible quality (completeness, accuracy), and to work at all times towards improving data quality in Trust Data Warehouse.
- To work with other members of both Informatics Services team, and with other stakeholders, to ensure that potential benefits of the data Warehouse in improvements in accuracy or timeliness of information or at a reduction in workload associated with the process are fully realized.
- To maintain a good understanding of the NHS Data Standards and Information Publications.
SUS and SLAM
- Responsible for the creation, development and operational maintenance of the SUS and SLAM processes ensuring the information is accurate and within the national tolerance limits for reconciliation purposes.
- Ensure there is a robust SUS/SLAM reconciliation process, proactively investigating any variance to provide assurance on data quality and consistency in both tariff and activity.
- Ensure SUS and HES reports are submitted in a timely fashion.
- Lead on ensuring there are validation reports for SUS, HES and SLAM by developing and maintaining a BI dashboard for SUS/SLAM/business plan as part of overall BI agenda
- Work closely with contracting to response to any queries raised in conjunction with the wider Information Services team. These can be contentious and opinions may conflict.
Communication and Relationships Skills
- The post holder must have the skills and experience to receive, interpret and communicate highly complex service related matters, at the highest level. This may be internal, external, written and/or verbal.
- Be able to communicate clearly and concisely to a wide range of groups at all levels throughout the Trust, e.g. business cases, national initiatives and Facilities Directorate issues
- The post holder will be required to communicate orally and in writing to the Trust Board and its delegated committees.
Patient/Client Care
- There may be incidental patient contact when users are trained, the BI solution is installed or during the planning cycle
Responsibilities for People or Training
- Responsible for delivering specialist training to other staff and organisations in all aspects of the Data Warehouse technical environment.
- Co-ordinates day to day allocation of work for junior team members
- Acts as key mentor to junior staff assessing abilities identifying any training / development needs.
Other Factors
- This role requires the ability to juggle complex issues whilst dealing with demands from Executive Directors, Clinicians and Senior Managers
- The role requires flexibility in approach with working hours with occasional evening and weekend working being required
- The role requires communication with external contacts of high profile
- High levels of concentration and mental effort required whilst handling frequent interruptions to answer complex queries from stakeholders and staff members
- The role is appropriate for flexible home working arrangements under some circumstances, to be determined by the BI Architect. There is a requirement to use VDU equipment more or less continuously on most days
Job description
Job responsibilities
Data Warehouse & BI
- The post holder is responsible for the adaptation, support and development of the technologies and processes supporting the safe use of the Trust Data Warehouse & BI Platform (a major trust wide information system). Ensuring accurate data flows to support Trust Financial Reporting, Income Recovery, National Data Submissions and Internal reporting requirements.
- Provision of technical advice on all Data Warehousing and BI solutions within the Trust.
- To deputise for the Data Architect in all areas relating to support and maintenance of the Data Warehouse and related systems.
- Analyses, investigates and resolves complex queries, where there are a number of options; analyses user requirements which may require configuration of software and hardware
- Works to achieve agreed objectives and has freedom to do this in own way, working within broad professional policies; advises without reference to manager. Acts as a lead specialist in own area.
- Implements IM&T policies for own area and contributes to changes in BI policies and procedures for new reporting processes and BI delivery solutions which will impact throughout the Trust with responsibility to ensure written documentation is created and maintained
- Provides expert guidance and recommendations and will specify the best course of action to be taken where multiple options may exist, ensuring potential risk to patient care is kept to a minimum
- Responsible for managing the operations of delivery and storage of patient and staff identifiable information held within Trust developed BI solutions and the Data Warehouse. They are responsible for ensuring that the data is accurate, relevant, secure, auditable, and that data is suitably anonymised for use in BI solutions.
- Responsible for the speedy resolution of all non-routine problems with the Trust Data Warehouse, Integration Engine and BI solutions. This involves directly supporting the IT Service Desk, Support Analysts and the Trusts senior managers and requires a proven ability to control and manage crisis and disaster situations.
Reporting
- To provide technical and practical support to members of the Information Services team as required, relating to all aspects of SQL development and the Data Warehouse environment.
- To provide support and advice to ad hoc requesters of information, in developing suitable report formats to meet their requirements.
- To work with other team members to ensure that all information supplied to customers is of the highest possible quality (completeness, accuracy), and to work at all times towards improving data quality in Trust Data Warehouse.
- To work with other members of both Informatics Services team, and with other stakeholders, to ensure that potential benefits of the data Warehouse in improvements in accuracy or timeliness of information or at a reduction in workload associated with the process are fully realized.
- To maintain a good understanding of the NHS Data Standards and Information Publications.
SUS and SLAM
- Responsible for the creation, development and operational maintenance of the SUS and SLAM processes ensuring the information is accurate and within the national tolerance limits for reconciliation purposes.
- Ensure there is a robust SUS/SLAM reconciliation process, proactively investigating any variance to provide assurance on data quality and consistency in both tariff and activity.
- Ensure SUS and HES reports are submitted in a timely fashion.
- Lead on ensuring there are validation reports for SUS, HES and SLAM by developing and maintaining a BI dashboard for SUS/SLAM/business plan as part of overall BI agenda
- Work closely with contracting to response to any queries raised in conjunction with the wider Information Services team. These can be contentious and opinions may conflict.
Communication and Relationships Skills
- The post holder must have the skills and experience to receive, interpret and communicate highly complex service related matters, at the highest level. This may be internal, external, written and/or verbal.
- Be able to communicate clearly and concisely to a wide range of groups at all levels throughout the Trust, e.g. business cases, national initiatives and Facilities Directorate issues
- The post holder will be required to communicate orally and in writing to the Trust Board and its delegated committees.
Patient/Client Care
- There may be incidental patient contact when users are trained, the BI solution is installed or during the planning cycle
Responsibilities for People or Training
- Responsible for delivering specialist training to other staff and organisations in all aspects of the Data Warehouse technical environment.
- Co-ordinates day to day allocation of work for junior team members
- Acts as key mentor to junior staff assessing abilities identifying any training / development needs.
Other Factors
- This role requires the ability to juggle complex issues whilst dealing with demands from Executive Directors, Clinicians and Senior Managers
- The role requires flexibility in approach with working hours with occasional evening and weekend working being required
- The role requires communication with external contacts of high profile
- High levels of concentration and mental effort required whilst handling frequent interruptions to answer complex queries from stakeholders and staff members
- The role is appropriate for flexible home working arrangements under some circumstances, to be determined by the BI Architect. There is a requirement to use VDU equipment more or less continuously on most days
Person Specification
Qualifications
Essential
- oThe post holder must be educated to degree level in a relevant subject or have an equivalent level of experience in a similar field.
Desirable
- oFurther education level qualification in Information Technology, informatics or similar.
Experience
Essential
- Significant experience of working in a Data Warehouse or Informatics environment within the NHS
- Significant development experience with SQL (including T-SQL, SSIS, SSRS & SSAS), or PostgreSQL
- Experience of working with and reporting to a wide range of stakeholders.
- Experience of mentoring and developing technical staff
Desirable
- Experience in Microsoft Power BI Architecture & report development
- Experience with Azure Data Architecture technologies.
Knowledge
Essential
- Expert specialist knowledge of Data Warehousing techniques and principles.
- Expert specialist knowledge of either Microsoft SQL server, including SSIS, SSRS & SSAS or PostgreSQL.
- Ability to discuss complex technical and business process issues in terms appropriate to technical and non-technical.
- Skilled and experienced in interpreting and communicating highly complex service-related matters, at the highest level with both internal and external stakeholders (written and verbal).
Desirable
- Clear understanding of NHS patient activity information, statutory data requirements, data definitions and performance measures
- Knowledge of NHS datasets and specialised coding structures (eg CDS, OPCS4, ICD10, HRG)
Person Specification
Qualifications
Essential
- oThe post holder must be educated to degree level in a relevant subject or have an equivalent level of experience in a similar field.
Desirable
- oFurther education level qualification in Information Technology, informatics or similar.
Experience
Essential
- Significant experience of working in a Data Warehouse or Informatics environment within the NHS
- Significant development experience with SQL (including T-SQL, SSIS, SSRS & SSAS), or PostgreSQL
- Experience of working with and reporting to a wide range of stakeholders.
- Experience of mentoring and developing technical staff
Desirable
- Experience in Microsoft Power BI Architecture & report development
- Experience with Azure Data Architecture technologies.
Knowledge
Essential
- Expert specialist knowledge of Data Warehousing techniques and principles.
- Expert specialist knowledge of either Microsoft SQL server, including SSIS, SSRS & SSAS or PostgreSQL.
- Ability to discuss complex technical and business process issues in terms appropriate to technical and non-technical.
- Skilled and experienced in interpreting and communicating highly complex service-related matters, at the highest level with both internal and external stakeholders (written and verbal).
Desirable
- Clear understanding of NHS patient activity information, statutory data requirements, data definitions and performance measures
- Knowledge of NHS datasets and specialised coding structures (eg CDS, OPCS4, ICD10, HRG)
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).
