Data Warehouse Specialist Developer

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 highly desirable but candidates without a previous NHS background will be considered provided they can demonstrate significant technical proficiency in the above toolsets.

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

About us

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.

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

---