ETL Developer

Location: Base location either at St Marys Hospital, Parkhurst Road, Newport, Isle of Wight, PO30 5TG, or Building 4000, Lakeside, North Harbour, Cosham, Portsmouth, PO6 3EN. Across site travel will be required, the frequency of which will be agreed locally.

Our Analytics team is part of the Single Corporate Service for Isle of Wight NHS Trust and Portsmouth Hospitals University NHS Trust. The teams vision is To provide a high performing analytics and information service, enabling our Trusts to be information led in delivering excellence.

Main duties of the job

Were looking for a skilled ETL Developer to join our Data Management function. Youll play a key role in designing, developing, and maintaining ETL processes that support our enterprise data warehouse and business intelligence platforms. So if you are passionate about data and its power to transform healthcare and you thrive on solving complex problems and building robust data pipelines, we want you on our team.

About us

Our vision for Single Corporate Services Isle of Wight NHS Trust (IWT) and Portsmouth Hospitals University NHS Trust (PHU) have a shared vision of a single corporate service across our two organisations, supported by a single set of identical systems and processes, under joint leadership, to drive significant efficiencies, improve employee experience, and return time to patient care.

Why are we changing the way we deliver Corporate Services?

Working as a partnership, both IWT and PHU have a shared vision for excellence in care for our patients and communities; with a set of strategic aims underpinning how we will achieve this. The creation of a single corporate service is essential for us to support our clinical and operational services, and our wider transformation programme.

The single corporate service is delivered across both organisation. For leaders managing staff across multi-site locations, you will need to be visible and provide in person leadership. The arrangements and frequency will be agreed locally.

Job responsibilities

Job Summary

• The post holder will be required to work in a team responsible for the development, maintenance and performance of the Data Warehouse. Examples of tasks include the development and maintenance of ETL processes, data cleansing routines, indexing and reporting datasets.
• Engage with customers to understand their information and reporting requirements. Design and deliver changes and new datasets into the Trusts data warehouse environment and make this available in an easy to use format to meet the need of our customers.
• Create attractive and high quality initial set of standard reports and dashboards as part of the delivery of new data into the data warehouse and Trust reporting systems.
• Promote report and dashboard creation best practices. Encourage and challenge users to do more with the information and tools available to empower them to gain new and better insight into their data.
• Train and support users of the Trusts reporting solution to improve access and use of Trust information.
• Support the robotic process automation design process and responsibility for building the solutions to replace repetitive tasks by enabling the integration of existing systems which will free up administration and clinical time for other duties and patient care.
• Responsible for ensuring that the quality and technical approach taken is aligned with the Digital Strategy and IT Design Authority principles and ensure that solutions meet the customers goals and objectives which in turn improve the quality of the services delivered by the hospital.
• Responsible for the daily monitoring of services provided by the Data Management Function to ensure the reliable and consistent availability of information for Trust operational and performance reporting. Resolve issues and communicate with key stakeholders when problems are encountered.

Person Specification

Qualifications

• Degree level qualification or equivalent in ICT or related field or appropriate relevant experience
• Specialist IT qualification covering database and software engineering (e.g. Microsoft certification)
• ITIL Foundation Certificate

Experience

• Significant experience of information handling and data management gained in a work environment.
• Significant experience of developing a data warehouse and managing complex data
• Experience of writing SQL queries in a real world environment
• Experience of system implementation, management and support
• Experience of software development
• Experience of Scrum methodology and Agile processes
• Experience of NHS practices and information

Disclosure and Barring Service Check

This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.

#J-18808-Ljbffr