Data Warehouse Specialist Developer | Great Western Hospitals NHS Foundation Trust

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 tomaintain 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. 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. 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. 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 Trust's 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., 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
  
  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., Disability Confident
About Disability Confident A Disability Confident employer will generally offer an interview to any applicant that declares they have a disability and meets the minimum criteria for the job as defined by the employer. It is important to note that in certain recruitment situations such as high-volume, seasonal and high-peak times, the employer may wish to limit the overall numbers of interviews offered to both disabled people and non-disabled people. For more details please go to Disability Confident.