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

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
Documents to download
Further details / informal visits contact
- Name
- Jonathan Luff
- Job title
- Associate Director of Business Intelligence
- Email address
- [email protected]
- Telephone number
- 07585886847
List jobs with Great Western Hospitals NHS Foundation Trust in Administrative Services or all sectors