Data Engineering Lead - Internal TO NHS WALES

Data Engineering Lead - INTERNAL TO NHS WALES

You will be able to find a full Job description and Person Specification attached within the supporting documents, for example with departments, programmes and projects, and externally with key partners including NHS Wales organisations, local authorities and Welsh Government, and suppliers, to ensure the potential of insight from WAST intelligence is maximised. Work collaboratively with other NHS Wales organisations and Welsh Government Leads to agree and support their data and reporting requirements.

Work collaboratively with the National Data Resource Programme to identify areas of commonality and alignment of service provision Ensure that procedures and protocols are complied with, particularly around information governance, data protection and use of patient-identifiable information. Enable communication, planning and sharing of good practice within the team. Communicate complex technical information relating to queries, updates, faults and changes to the Data Warehouse system with non-experts in WAST in a way that is understandable, persuasive and overcoming barriers to understanding or acceptance of this information.

Communicate highly complex or technical proposed changes to Senior management, the directorate and team members where there could be resistance to change, due to impact on the service. Engage in highly complex, technical discussions and ideas regarding changes in direction or strategic decisions within senior management meetings, with heads of information, and other senior level meetings and groups, within NHS Wales and with external stakeholders.

This will involve using skills of influencing, persuading, motivational, and negotiating. Exercise own judgment based on the interpretation of highly complex facts, figures and situations which require the analysis, interpretation and comparison of a range of options for the purpose of service planning and delivery. Create reports from internal and external sources, that allow evaluation of Information Services plans and services.

In-depth knowledge and experience of programming languages, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS) and scripting languages, and ability to write complex SQL queries, stored procedures. Work with data providers/owners on the acquisition of additional/new data into the local data warehouse and suitable and compliant onward sharing to the national warehouse. Undertake horizon scanning to identify new, valuable data sources.

Diagnose complex data/processing problems or inefficiencies, suggesting and providing solutions. Ensure data is made available in a timely manner, establishing automation of reports and processes whenever possible. Establish a standard approach for data science projects. Develop methodologies for the analysis and interpretation of data to support service redesign and research, including prediction of demand, conducting what if analysis, identifying risks, exploring gains in productivity and efficiencies, and discovering opportunities to improve clinical quality.

Within the national data warehouse and acquisition areas, monitor and review plans which may be long term in nature, and ensure they are adjusted for changes in local need and in response to changes in national policy, Welsh Government guidelines and best practice. Plan and prioritise own work to ensure effective support to all areas and delivery of key objectives.

Promote to Directorates and departments, the opportunity and value of the national data warehouse and to be proactive and influential in WASTs contribution to the design and delivery of the NDRs strategic and operational plans. Support the planning and development of major organisational change projects which may be contentious and impact across the whole of WAST, requiring the post holder to gain agreement from all grades of staff in the organisation.

Formulate long term, strategic plans around the development of the WAST Data Warehouse, in conjunction with the National Data Resource or other cloud data storage opportunities. This will involve understanding and evaluating the available options and formulating the best solution for the long-term which may involve uncertainty. The postholder will require standard keyboard skills for regular use of Microsoft packages, Teams, software systems and Visio.

The postholders duties will not require any direct contact with patients however any contact would be incidental. Responsibility to lead on implementation of a range of national data warehouse and acquisition service policy, service development and corporate initiatives which may impact across the organisation as agreed with the Head of Data & Analytics and the Assistant Director of Digital Services.

Work across the organisation(s) as appropriate in relation to collaborative schemes for delivery of joint strategy, planning and service developments. As appropriate, identify any engagement issues where…