Data Engineering Lead - INTERNAL TO NHS WALES

Be a senior member of the Data & Analytics team (within the Insight & Data Services department), responsible for leading the team that develops and maintains the local data warehouse and data acquisition solutions and supports delivery of the National Data Resource (NDR).

Be responsible for the architectural design, development and management of the local data warehouse environment used for data analytics, publishing and reporting, and responsible for the delivery of WAST data and information into the NDR to support agreed strategic plans.

Be an NHS data specialist, with hand-on expertise and knowledge encompassing the extensive range of operational, clinical, managerial and Government performance datasets and national submissions.

Work with the Head of Data & Analytics to formulate the strategic direction of data storage, acquisition and processing for WAST. This includes evolving the architecture of the current local portfolio and aligning with the emerging National Data Resource.

Have an excellent eye for quality to ensure the highest levels of integrity and governance across all of the appropriate data and data quality management.

Have strong team management skills and mentor/develop staff to ensure the whole team can contribute. The post holder will manage direct reports and their teams and have cross site management responsibility.

Welsh Language level 1 skills are desirable for this role.

You will be able to find a full Job description and Person Specification attached within the supporting documents or please click Apply now to view in Trac

Build effective positive relationships internally, 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 Insight & Data Services (IDS) input is required.

Support the implementation of WASTs policies and procedures that facilitate the development of a learning culture.

Participate in the learning and development agenda within Insight & Data Services.

Manage any developments of the local and national data warehouse and data acquisition services by contributing to business cases and bids for funding to add additional functionality that may enhance the Insight & Data Services portfolio.

Liaise with external suppliers to ensure service delivery is in line with agreed or contractual terms.

Comply with all legal, regulatory and WASTs requirements including policies, standing financial instructions, standing orders and procedures. Work with the Information Governance team on ensuring GDPR and Data Protection compliance where necessary.

#RemarkablePeople

Our workforce is made up of over 4,000 remarkable people who contribute to the delivery of world-class patient care across Wales, 24 hours a day, 365 days a year. Whether you work in a patient-facing role or within our range of support services, the work that you do enables us to provide high quality care, wherever and whenever we're needed.

The Trust recognises the need for its workforce to represent the diversity of the population it serves across the whole of Wales and seeks to create an environment where diversity is celebrated and inclusivity matters. We are also keen to break down any barriers into the Trust, and would encourage applications from under-represented groups, including those from Black, Asian and Minority Ethnic communities, LGBTQ+ communities and disability groups.

Careers within the Welsh Ambulance Services University NHS Trust are diverse and varied, with opportunities arising right across the service. Whatever your skills and background, you're sure to find a career with us which is fulfilling, challenging, and rewarding.

In line with the Trust's Starting Salary Procedure, all applicants will start at the bottom of the band for the position applied for, but can apply for a higher salary if they have previous experience relevant to the position.

Qualifications & Knowledge

Experience

Skills & Attributes