ETL Developer

Band: NHS Agenda for Change Band 7Hours: 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.Please note this vacancy is only open to applications from Isle of Wight NHS Trust and Portsmouth Hospitals University NHS Trust. 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.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.Job SummaryThe 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.For further details please see enclosed Job DescriptionQualifications : EssentialDegree level qualification or equivalent in ICT or related field or appropriate relevant experienceSpecialist IT qualification covering database and software engineering (e.g. Microsoft certification)ITIL Foundation CertificateExperienceEssentialSignificant experience of information handling and data management gained in a work environment.Significant experience of developing a  data warehouse and managing complex dataExperience of writing SQL queries in a real world environmentExperience of system implementation management and supportExperience of software developmentProject management experienceExperience of Scrum methodology and Agile processesExperience of NHS practices and informationKnowledgeEssential Excellent knowledge and understanding of healthcare data and processesExcellent knowledge in relational database design and implementationExcellent knowledge in SQLExcellent 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 veterans status colour religion disability sexual orientation and beliefs.Remote Work : NoEmployment Type : Full-time Key Skills SQL,Pentaho,PL/SQL,Microsoft SQL Server,SSIS,Informatica,Shell Scripting,T Sql,Teradata,Data Modeling,Data Warehouse,Oracle Experience: years Vacancy: 1