Data Warehouse Developer, Band 5- Business Intelligence

at  Gloucestershire Hospitals NHS Foundation Trust

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.

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.

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.
Please see the attached job description and person specification for more information on the main responsibilities for this vacancy

• 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