DUTIES AND RESPONSIBILITIES Develop and maintain complex data transfer pipelines from source systems to the Trust Data Warehouse and Data Marts. Analyse and interpret requirements and specifications from the Business Intelligence Analysts to inform data construct design, development and assurance processes. Support the appropriate data warehousing design and software development methodologies agreed for use within the team. Produce detailed technical specifications and documentation for the support, maintenance, monitoring and quality assurances of ETL processes. Investigate, support, correct and prevent issues relating to existing Trust developed data reporting systems and processes, identifying issues and implementing resolutions in a timely manner. Participate in the sprint planning process to determine durations and any dependencies with planned development work. Develop test plans, and supporting test data, for the developed services in order to validate their stable and maintainable operation against requirements. Ensure that skills and knowledge are kept up-to-date through professional development. Make recommendations on new tools, technologies and techniques that can be adopted by the team. Participate in regular exercises to test business continuity and disaster recovery plans. Human Resources Line manage (if applicable) in line with appropriate policies, procedures, working practices and guidelines, ensuring all resources are deployed to maximise an efficient and effective delivery of support services to patients and users. As requested, provide reports on progress, status and achievements for own work. Undertake and support the development of staff/placements in line with personal development reviews and other associated guidance. Provide guidance for staff from own or other disciplines on own subject area, when required. On limited occasions, by exception, the post holder may be required to work unsociable hours to support and/or enable the delivery of key programmes or projects Financial/Physical Resources Be responsible for the safe and efficient use of hardware, software and financial resources. Where required, liaise with external agencies, suppliers and contractors ensuring delivery of service is in line with agreed contracts and value for money. Ensure the post holder adheres to Trust Standing Financial Instructions (SFIs) and procurement guidelines. Project Management Advise and participate in the development and implementation of projects as part of planned development sprint cycles. Ensure project tasks, where required, are successfully delivered in line with agreed timescales and budgets. Work with line manager to ensure any project management documentation or reports are delivered in line with agreed standards and timescales Policy/Service Development/Governance Act as an ambassador for Digital Services by developing and maintaining excellent working relationships with users across the organisation to deliver a high quality professional service as part of the a development team. Pro-actively participate in ensuring that Digital services delivered within the Trust reflect best practice with respect to organisational, NHS and legislative requirements and guidelines including IT Infrastructure Library (ITIL), Data Protection Act 2018, Information Standards, Information Security and compliance with NHS Information Governance. Ensure all documentation relating to own area is complete and fit for purpose and all releases relating to hardware, software and documentation is controlled. Ensure there is a proactive and comprehensive approach to risk management and be responsible for service continuity for own area. Contribute to Root Cause Analysis (RCA) for allocated incidents and problems; instigating action when required, liaising with other team members and managers, as appropriate. Business Continuity Management Be familiar with the Trust and Department level Business Continuity Plan and personal responsibilities within, where applicable.