Company Description
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 Description
Band: NHS Agenda for Change Band 7
Hours: Full-time 37.5 hours per week
Contract Type: Permanent
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.
We’re looking for a skilled ETL Developer to join our Data Management function. You’ll 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.
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 Trust’s 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 Trust’s 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 customer’s 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.
For further details, please see enclosed Job Description
Qualifications
Essential
- 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
Essential
- 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
- Project management experience
- Experience of Scrum methodology and Agile processes
- Experience of NHS practices and information
Knowledge
Essential
- Excellent knowledge and understanding of healthcare data and processes
- Excellent knowledge in relational database design and implementation
- Excellent knowledge in SQL
- Excellent knowledge of Trust based technologies (as appropriate to position)
Additional Information
The health and wellbeing of our staff is at the forefront of everything we do. We are proud to be able to offer our staff some fantastic benefits including our on-site Nursery, access to our free Beach Hut for those long summer days, our on-site Wellness Centre including a gym and a swimming pool, access to our fantastic staff networks including LGBTQ, Race Equality and DisAbility, and awards ceremonies to recognise your achievements. We believe we can offer support to all of our staff when they need it the most.
We welcome the unique contributions that you can bring in terms of your education, opinions, culture, ethnicity, race, sex, gender identity and expression, nation of origin, age, languages spoken, veteran’s status, colour, religion, disability, sexual orientation, and beliefs.