Skip to main content

This job has expired

Data Warehouse Developer, Band 5- Business Intelligence

Employer
Gloucestershire Hospitals NHS Foundation Trust
Location
Cheltenham
Salary
£28,407 to £34,581 per annum
Closing date
31 May 2024

View more

Profession
Other Health Profession
Grade
Band 5
Contract Type
Permanent
Hours
Full Time
Working as part of our multi-award winning Business Intelligence Team, our Data Team are responsible for creating and maintaining the Trust's Data Warehouse which allows the Analytical Team to provide intelligence and insight to facilitate planning and delivery of our acute services. The Data Team have recently completed project to redevelop the Data Warehouse, so this jobholder will be joining at a very exciting time contributing to further developments. The Data Warehouse Developer will work to develop, modify and maintain data processing scripts, ensure the successful running of the data warehouse and be involved in submitting and maintaining national submissions.

Previous applicants within the past 6 months do not need to apply

Main duties of the job

You will work to develop, modify and maintain data processing in a role whose main duties included:

- To provide expertise in collecting, integrating, and optimising data using SQL and other database technologies where appropriate.

- To design and implement data flows using SQL Integration Services (SSIS) enabling the automated update of key datasets.

- To work in support of analysts and users of the data warehouse to ensure that access and performance are assured and that changes are managed to meet their requirements.

- To work with highly sensitive patient data, ensuring appropriate steps are taken at all times to comply with confidentiality and data protection requirements.

- To work with data warehouse managers in agreeing task priorities and to resolve any clashes in deadlines.

- To work to develop an expert understanding in the Trusts datasets, their significance to the organisation and how their use could be extended.

- To have a good understanding of the importance of national submissions, such as PLICS, SUS, MSDS etc and keep up to date with any national requirements.

- To be an active participant in team and project meetings and promote ideas and approaches that could be applied.

About us

An exciting opportunity to join the expanding Business Intelligence department and become a member of a skilled, knowledgeable and enthusiastic team. Significant investment has been made into the systems and software used within BI and their rapid development is changing the reach and influence that our team is having within the Trust and our partner organisations in the Gloucestershire health system.

The team benefits from the wide range of specialist staff members, with roles from patient system configuration and testing to database development and healthcare analytics. This diversity makes the department a dynamic, challenging and rewarding place to work and one in which new skills and understanding can flourish.

Each member of the team is supported, developed and encouraged to play a part in the continual development of our department. We foster an environment where our new starters can bring forward their ideas and share their experience as we tackle the challenges and demands that our Trust faces through its commitment in delivering outstanding patient care.

Job description

Job responsibilities

Please see the attached job description and person specification for more information on the main responsibilities for this vacancy.

Person Specification

Qualifications

Essential

  • Bachelor Degree or equivalent educational level


Experience

Essential

  • Ability to work under pressure and deliver to timescales/deadlines
  • Attention to detail
  • Write processing documentation and reports


Knowledge/ Skills

Essential

  • Good understanding of relational databases, specifically Microsoft SQL
  • Excellent data extraction, management and processing skills.
  • Detailed understanding of the importance of data quality and the ability to report and manage issues in processing


Desirable

  • An understanding of the Microsoft Business Intelligence Development Studio, specifically SSIS
  • In depth knowledge and understanding of NHS Data Dictionary including datasets, data standards and data modeling concepts


Employer details

Employer name

Gloucestershire Hospitals NHS Foundation Trust

Address

Cheltenham General Hospital

Cheltenham

GL53 7AN

Any attachments will be accessible after you click to apply.

318-24-COR-R12237-B

Get job alerts

Create a job alert and receive personalised job recommendations straight to your inbox.

Create alert