Trac proudly powers the recruitment for

Public Health Wales NHS Trust

About

Welcome to Public Health Wales, the national public health organisation for Wales. We exist to protect and improve health and wellbeing and reduce health inequalities for people in Wales.

To find out more visit Public Health Wales and watch this about our Strategic Plan

Working together, with trust and respect, to make a difference

Our purpose is ‘working together for a healthier Wales'. We exist to help all people in Wales live longer, healthier lives. With our partners, we aim to increase healthy life expectancy, improve health and well-being, and reduce inequalities for everyone in Wales, now and for future generations.

Together, our teams work to prevent disease, protect health, and provide leadership, specialist services and public health expertise. We are the main source of public health information, research and innovation in Wales.

Executive Summary - Public Health Wales (nhs.wales)

Contact

Address: No.2 Capital Quarter; Tyndall Street; Cardiff; CF10 4BZ
Contact Number: 02921 500200

Find out more

Jobs Website

Login changes are coming

From July 2025 onwards, Multi-Factor Authentication (MFA) will be introduced to this site. This will add an extra step to the login process: a requirement to enter a One Time Passcode (OTP) upon login to minimise fraud and maintain security. See our summary page here for more details.

Open

Ref: 028-AC175-0725 Vacancy ID: 7344752

Advanced Data Engineer

Accepting applications until: 11-Aug-2025 23:59

Vacancy status: Open

Accepting applications until: 11-Aug-2025 23:59

Location

Site: Capital Quarter 2
Address: Tyndall Street
Town: Cardiff
Postcode: CF10 4BZ
Major / Minor Region: Cardiff

Contract type & working pattern

Contract: Permanent
Hours: Full time - 37.5 hours per week

Salary

Salary: £46,840 - £53,602 per annum
Salary period: Yearly
Grade: (Band 7)

Specialty

Main area: Data Engineer

Interview date: 01/09/2025

Welcome to Public Health Wales, the national public health organisation for Wales

Our vision is Working to achieve a healthier future for Wales

To find out more visit Public Health Wales and watch this video about our Strategic Plan

Working together, with trust and respect, to make a difference

Applicants are invited to apply in Welsh, any application submitted in Welsh will not be treated less favourably than an application made in English. To support our all Wales service, we particularly welcome applications from Welsh speakers.

Detailed job description and main responsibilities

Key Skills, Knowledge and Experience:

Advanced SQL and scripting skills (e.g., TSQL, PowerShell[LN1] [FB2] ) for data engineering, automation and orchestration tasks.
Advanced database manipulation and administration skills, particularly T-SQL, Azure SQL, as well as capacity with unstructured and unlinked data management languages.
Experience using and implementing schema and metadata design (e.g., star schema, snowflake, normal forms), with strong understanding of master and reference data management.
Experience working with Azure/GCP building and managing data solutions such as data lakes or data warehouses, Azure Data Factory, Data Bricks and so forth
Skilled in using cloud tools such DataFlow, Cloud Composer and Big Query
Experience with data visualisation tools, particularly on the Microsoft Stack or GCP.
Knowledge of data integration patterns and technologies (e.g., ETL, ELT, API-first), including near real-time and event-driven approaches.
Experience in on-prem to Cloud migration and greenfield projects.
Experience collaborating with business stakeholders, analysts, and developers to translate business needs into technical solutions.

What you'll bring to the team:

Proven experience as a Data Engineer in a hands-on role, with communication and collaboration skills to match your technical expertise.
Proven experience in cloud platforms such Azure and GCP.
Strong proficiency in automation of data processes, particularly ETL/ELT at scale.
Advanced programming skills in SQL and Python [LN3] [FB4] and a collaborative, CI/CD approach to pushing code; experience with orchestration and data pipeline tools.

· A user-focused approach to data delivery, ensuring that outputs are accessible, actionable and grounded in real-world context

Effective communication and stakeholder engagement skills, with the ability to influence at all levels of the organization.
A collaborative mindset, coupled with a passion for delivering in a high-performing team environment.

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 on Trac.

The ability to speak Welsh is desirable for this post; Welsh and/or English speakers are equally welcome to apply.

Public Health Wales, reserves the right to close this vacancy early. We therefore encourage early applications.

Priority is given to staff awaiting redeployment. We therefore reserve the right to withdraw this advert at any stage.

If you have a disability and have any particular requirements to enable you to participate in the application process, please contact [email protected]

IMPORTANT NOTE FOR APPLICANTS: Applications for our roles are carefully reviewed and shortlisted based on specific criteria, which varies from job to job.

Using a generic application or automated AI application services, such as Lazy Apply or AI Apply, does not usually provide enough personal evidence of your skills and experience relevant to the role. This can make it difficult for us to assess your suitability and will reduce your chances of being shortlisted.

To ensure your application is given full consideration, we recommend submitting a tailored application that directly addresses the criteria listed in the Person Specification section of the advert, providing clear evidence and examples to demonstrate how you meet each requirement.

Visa Sponsorship Eligibility

If you require sponsorship under the Skilled Worker or Health and Care Visa routes, please ensure you self‑assess your eligibility for sponsorship for this role before applying.
Check the Skilled Worker visa guidance or Health and Care visa guidance for details on job eligibility, salary, English language, and sponsorship requirements.

If you are successful and short listed for interview you will be contacted by email using the address with which you registered. Please ensure you check your email account regularly.

We are committed to fair, transparent recruitment and believe in equality of opportunity in our workplace and will not tolerate discrimination on grounds of age, disability, gender identity, religion or belief, race or nationality, marriage or civil partnership status, sex, sexual orientation, working pattern, caring responsibilities, trade union activity or political beliefs – or on any other grounds. We welcome applications from individuals seeking flexible working arrangements.

To work in the UK, all candidates who are not UK or Republic of Ireland (RoI) nationals require sponsorship to obtain either a Health and Care visa or Skilled Worker visa, unless you have permission to work via another route. Non UK / RoI candidates wishing to apply should self-assess the likelihood of obtaining a Certificate of Sponsorship by visiting Work in the UK. If you are eligible for the Health and Care visa, application costs are lower and you do not need to pay the annual Immigration Health Surcharge.

The salary scale shown is for a full-time member of staff, with the amount being adjusted pro rata for those working less than 37.5 hours per week.

The salary scale above has been agreed as part of the NHS Agenda for Change pay award for 2025/2026 and will be implemented in August 2025 with arrears backdated to 1st April 2025 where applicable.

In general, anyone joining our Trust who has not previously worked in the NHS will, by default, start on the first point of the advertised pay band. Pay progression will then be determined by annual Performance and Development Reviews in accordance with the NHS Wales Pay Progression Policy. An application for Incremental Credit may be considered, but can only be awarded based on evidenced, reckonable service and/or equivalent, relevant experience.

Applicant requirements

Welsh language skills are desirable

Person specification

Qualifications and Knowledge

Essential criteria

• Undergraduate degree or equivalent knowledge and skills in data engineering or related discipline, for example (but not limited to) computer science, data science, information technology, software engineering, or other discipline with a substantial data engineering component
• Evidence of continuing professional development and practical application of learning in data engineering

Experience

Essential criteria

• Good technical skills and experience in Python / R, Power BI and Power Apps, Google Cloud Platform, Azure, cloud-to-on-prem engineering, SQL, NoSQL, dashboards, databases and visualisation, APIs, including understanding and application of good practice in these areas
• Evidence of developing and delivering effective data engineering projects, including data architecture, data modelling, ETL processes, and metadata management concepts
• Evidence of using tools such as Git, GitHub and / or Azure DevOps to effectively manage work flow, version control, and collaborative development, and use of Agile delivery methodologies
• Evidence of understanding and application of data security, governance, and compliance regulations
• Evidence of successful delivery of data engineering products in a complex organisational environment

Skills and Attributes

Essential criteria

• Communicating between the technical and non-technical. You can communicate effectively with technical and non-technical stakeholders. You can support and host discussions within a multidisciplinary team, with potentially difficult dynamics. You can be an advocate for the team externally and can manage differing perspectives. (Skill level: working)
• Data analysis and synthesis. You can undertake data profiling and source system analysis. You can present clear insights to colleagues to support the end use of the data. (Skill level: working)
• Data development process. You can design, build, and test data products that are complex or large scale. You can build teams to complete data integration services. (Skill level: practitioner)
• Data innovation. You can understand the impact on the organisation of emerging trends in data tools, analysis techniques and data usage. (Skill level: working)
• Data integration design. You can select and implement the appropriate technologies to deliver resilient, scalable, and future -proofed data solutions. (Skill level: practitioner)
• Data modelling. You can produce relevant data models across multiple subject areas. You can explain which models to use for which purpose. You can understand industry -recognised data modelling patterns and standards, and when to apply them. You can compare and align different data models. (Skill level: practitioner)
• Metadata management. You can design an appropriate metadata repository and present changes to existing metadata repositories. You can understand a range of tools for storing and working with metadata. You can provide oversight and advice to more inexperienced members of the team. (Skill level: practitioner)
• Problem resolution (data). You can respond to problems in databases, data processes, data products and services as they occur. You can initiate actions, monitor services, and identify trends to resolve problems. You can determine the appropriate remedy and assist with its implementation, and with preventative measures. (Skill level: working)
• Programming and build (data engineering). You can use agreed standards and tools to design, code, test, correct and document moderate-tocomplex programs and scripts from agreed specifications and subsequent iterations. You can collaborate with others to review specifications where appropriate. (Skill level: practitioner)
• Technical understanding. You can understand the core technical concepts related to the role and apply them with guidance. (Skill level: working)
• Testing. You can review requirements and specifications and define test conditions. You can identify issues and risks associated with work. You can analyse and report test activities and results. (Skill level: working)
• A demonstrated ability to embrace, drive, and lead change, to lead others to achieve organisational goals and objectives, with an enthusiasm for improving performance and services
• The ability to flexibly adjust plans and workloads to meet the requirements of the role, such as planning and organising broad range of complex activities; formulates, adjusts plans or strategies
• Plans specialist projects which impact across clinical and non clinical areas
• Ability to demonstrate understanding and application of our workplace valsues, together with the underpinning behaviours identified for success in this role