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 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

• Masters degree or equivalent professional qualification or equivalent relevant training and experience.

Desirable

• Degree in relevant fields e.g. computer science, coding, informatics, analysis
• Evidence of continued personal development.

Experience

Essential

• Significant experience in an Senior Developer role.
• Demonstrable experience working in an NHS Acute/Community Trust information setting or at a Senior Developer role in other settings.
• Demonstrable experience of the maintenance and development of the Data Warehouse and BI architecture including performance, maintainability and scalability
• Experience acting as a technical expert to users both within the department and to other departments around the Trust

Desirable

• Experience delivering specialist training to other staff and organisations in all aspects of the Data Warehouse technical environment.
• Experience acting as key mentor to junior staff assessing abilities identifying any training / development needs.

Knowledge

Essential

• Expert knowledge of the NHS Data Manual, Information Standards, data flows and statistical returns gained through demonstrable experience in an NHS data role or evidence of ability to take on similar technical details elsewhere
• Expert knowledge of Microsoft SQL Server (T-SQL, SSIS, SSRS, SSAS), PowerBI and Data Warehouseing Architectures
• Ability to deal effectively with a range of queries from Directors, Managers, project leads and clinical staff.
• Ability to communicate complex (potentially contentious or sensitive) analytical issues to data literate persons or groups at various levels.
• Excellent written and verbal communication skills

Desirable

• Technical Knowledge of PostreSQL

Qualifications

Essential

• Masters degree or equivalent professional qualification or equivalent relevant training and experience.

Desirable

• Degree in relevant fields e.g. computer science, coding, informatics, analysis
• Evidence of continued personal development.

Experience

Essential

• Significant experience in an Senior Developer role.
• Demonstrable experience working in an NHS Acute/Community Trust information setting or at a Senior Developer role in other settings.
• Demonstrable experience of the maintenance and development of the Data Warehouse and BI architecture including performance, maintainability and scalability
• Experience acting as a technical expert to users both within the department and to other departments around the Trust

Desirable

• Experience delivering specialist training to other staff and organisations in all aspects of the Data Warehouse technical environment.
• Experience acting as key mentor to junior staff assessing abilities identifying any training / development needs.

Knowledge

Essential

• Expert knowledge of the NHS Data Manual, Information Standards, data flows and statistical returns gained through demonstrable experience in an NHS data role or evidence of ability to take on similar technical details elsewhere
• Expert knowledge of Microsoft SQL Server (T-SQL, SSIS, SSRS, SSAS), PowerBI and Data Warehouseing Architectures
• Ability to deal effectively with a range of queries from Directors, Managers, project leads and clinical staff.
• Ability to communicate complex (potentially contentious or sensitive) analytical issues to data literate persons or groups at various levels.
• Excellent written and verbal communication skills

Desirable

• Technical Knowledge of PostreSQL

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).

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

Great Western Hospitals NHS Foundation Trust

Address

Great Western Hospital

Marlborough Road

Swindon

SN3 6BB

Employer's website

https://www.gwh.nhs.uk/ (Opens in a new tab)