Skip to main content

This site is independent of the NHS and the Department of Health.

Please wait, loading

Job summary

Main area
Business Intelligence
Grade
Band 7
Contract
Fixed term: 6 months (N/A)
Hours
  • Full time
  • Flexible working
  • Home or remote working
37.5 hours per week
Job ref
249-7325254
Employer
Great Western Hospitals NHS Foundation Trust
Employer type
NHS
Site
Great Western Hospital
Town
Swindon
Salary
£47,810 - £54,710 per annum pro rata
Salary period
Yearly
Closing
03/08/2025 08:00

Employer heading

Great Western Hospitals NHS Foundation Trust logo

Data Warehouse Specialist Developer - PACS/RIS

Band 7

Great Western Hospitals NHS Foundation Trust is a unique organisation, serving as the sole integrated provider in the Bath and North East Somerset, Swindon, and Wiltshire system. Our scope extends beyond boundaries as we oversee adult community services in Swindon and provide acute care from the Great Western Hospital. 

Our 5,500 staff have 1.2m patient contacts a year, with 13,000 operations carried out in our Theatres, around 4,000 babies born, and our emergency attendances are now well over 100,000 per year. Those numbers only tell part of our story about what an exciting time it is to join Great Western Hospitals.

We are cultivating a culture that fosters our ambitions, prioritising equality, diversion, inclusion, wellbeing, and leadership. We aim to create an environment where every member of our team can truly thrive.

The Trust is a Disability Confident Employer; all applicants who have a disability can opt to be considered under the guaranteed interview scheme, which means that, providing they meet the minimum essential criteria for the post, they will be offered an interview. We are also proudly accredited as a Veteran Aware organisation and have signed The Armed Forces Covenant.

If we receive a high volume of applications, we may close adverts prior to the published closing date. Therefore, we advise you to complete and submit your application as soon as possible.

Job overview

Data Warehouse Specialist Developer - PACS/RIS (6 Month Secondment/Fixed Term)

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 on a Fixed Term Contract to support the implementation of the new PACS & RIS systems.  

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

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

Working for our organisation

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.

Detailed job description and main responsibilities

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

Please see attached full Job Description 

Person specification

Qualifications

Essential criteria
  • Masters degree or equivalent professional qualification or equivalent relevant training and experience.
Desirable criteria
  • Degree in relevant fields e.g. computer science, coding, informatics, analysis
  • Evidence of continued personal development.

Experience

Essential criteria
  • 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 criteria
  • 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 criteria
  • 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 criteria
  • Technical Knowledge of PostreSQL

Employer certification / accreditation badges

NHS Pastoral Care Quality AwardVeteran AwareApprenticeships logoNo smoking policyPositive about disabled peopleAge positiveDisability confident leaderInvestors in People: Goldhttps://www.gov.uk/government/publications/kickstart-scheme-employer-resources/kickstart-scheme-brand-guidelinesStonewall equality policy. Equality and justice for lesbians, gay men, bisexual and trans people.Step into healthArmed Forces Covenant

Documents to download

Apply online now

Further details / informal visits contact

Name
Jonathan Luff
Job title
Associate Director of Business Intelligence
Email address
[email protected]
Telephone number
07585886847
Apply online nowAlert me to similar vacancies