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.

Closed

Ref: 028-AC417-1223 Vacancy ID: 5840744

Data Engineer

Closed for applications on: 8-Jan-2024 00:04

Vacancy status: Closed

Closed for applications on: 8-Jan-2024 00:04

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
Flexible working
Home or remote working

37.5 hours per week

Salary

Salary: £51,706 - £58,210 per annum
Salary period: Yearly
Grade: (Band 8a)

Specialty

Main area: Data Engineer

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

You will lead on the delivery of physical data models and views required for data exploiters to enable visualisation of metrics and the provision of insightful analysis for data science projects.

You will be the technical lead for departmental work area and overall data management framework.

You will embed improved ways of working with data across the team and organisation, including automation of manual tasks and data assurance.

You will utilise your strong experience of working with data and databases, including the development of new and existing data sources in a Data Warehouse environment. Your understanding of Data Warehouse techniques, including dimensional data modelling and relational database design and concepts (e.g., Kimball), will be used extensively.

You will regularly demonstrate your expertise in SQL and relational databases such as Oracle Database & PL/SQL or Microsoft T-SQL.

You will utilise your knowledge and experience of R and Python programming and undertake code reviews and ensuring coding standards are applied and met.

You will define and document data workflows across systems and operations, including capturing and documenting complex data definitions and business rules.

You will collaborate directly and through partners to develop data systems, lead on developments as maybe required.

You will provide expert advice to the directorate and organisation on matters of data platforms, data integration and visualisation tools.

You will use your extensive connection skills to communicate to and between technical and non-technical stakeholders, and facilitate discussions within a multidisciplinary team, including data scientist/analysts.

You will help to develop and implement a successful Data Strategy for the organisation.

You will drive your own performance to ensure delivery against key projects and objectives.

Duties/Responsibilities

Lead on the delivery of physical data models and views required for data exploiters to enable visualisation of metrics and the provision of insightful analysis for data science projects.
Technical lead for departmental work area, and overall data management framework.
Embed improved ways of working with data across the wider team, including automation of manual tasks and data assurance.
Strong skills in analysing, defining, sourcing and capturing data across strategic business systems, processes and areas of an organisation
Strong experience of working with data and databases, ideally involving the development of new and existing data sources in a Data Warehouse environment.
Good understanding of Data Warehouse techniques, including dimensional data modelling and relational database design and concepts (e.g. Kimball).
Exceptional SQL experience and technical database expertise using relational databases such as Oracle Database & PL/SQL or Microsoft T-SQL.
Excellent knowledge and experience of R and Python programming
Experience of code reviews and ensuring coding standards are applied and met.
Experience of defining and documenting data workflows across systems and operations, including capturing and documenting complex data definitions and business rules.
Provide expert advice to the Directorate on matters of data platforms, data integration and visualisation tools.
Directly and through partners develop widely accessible data for analysis by data scientists & analysts in the organisation, customers and partners
Identify and lead on re-engineering manual data flows to enable scaling and repeatability.
Directly and through partners develop ETL layers and optimise them.
Knowledge of work management/collaboration tools such as MS Teams, Trello and Miro etc.

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.

The ability to speak Welsh is desirable for this post; English and/or Welsh 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 & KNOWLEDGE

Essential criteria

Educated to Masters level or equivalent level or equivalent experience of working at a senior level in specialist area, plus Postgraduate management diploma qualification.
Extensive working knowledge and experience with ETL and data integration.
Evidence of continued professional development.
Knowledge and expertise of IT architecture and infrastructure.
Knowledge and expertise of health intelligence (including systems and application).
Current knowledge of the public sector/NHS.
Knowledge of work management/collaboration tools such as MS Teams, Trello and Miro etc.

Desirable criteria

Knowledge of NHS, Welsh Government and strategies, policies and plans

Experience

Essential criteria

Experience of exporting data from various source data systems, transforming data against required business rules and data models, or data storage and analysis requirements, and loading data in various storage platforms.
Excellent communication and collaboration skills to determine data requirements.
Experience of implementing digital/information/data change programmes.
Experience of developing delivery plans, establishing work priorities, delegating effectively, ensuring a capability to deliver, monitoring performance and giving feedback
Good understanding of Data Warehouse techniques, including dimensional data modelling and relational database design and concepts (e.g. Kimball). Exceptional SQL experience and technical database expertise using relational databases such as Oracle Database & PL/SQL or Microsoft T-SQL. Able to develop partnerships across Organisations and drive collaboration between people to achieve desired outcomes.
Exceptional SQL experience and technical database expertise using relational databases such as Oracle Database & PL/SQL or Microsoft T-SQL.
Able to develop partnerships across Organisations and drive collaboration between people to achieve desired outcomes.

Desirable criteria

Experience of writing parameterised code in either a programming or scripting language such as SQL/PL-SQL and/or Python/Spark.
Experienced in delivering metadata driven development processes.
Experience of building pipelines in cloud technologies such as Azure Data Factory/Databricks.
Experience of using CI/CD techniques and processes DevOps/Git repository code promotion and change management experience.

Aptitude & Abilities (SKILLS)

Essential criteria

Excellent analytical, IT Keyboard and numerical skills - confident with statistics and their presentation.
Excellent verbal and written communication (including presentation) skills.
Ability to analyse highly complex issues where material is conflicting and drawn from multiple sources (verbal, written and numerical).
Significant ability to analyse numerical and written data, assess options and draw appropriate initiatives
Demonstrable ability to plan over short, medium and long-term timeframes and adjust plans and resource requirements accordingly
Demonstrable ability to work effectively between competing activities where required.
Demonstrable ability to manage own workload and make informed decisions in the absence of required information, working to tight and often changing timescales.
Excellent inter- personal skills and ability to build and maintain successful working relationships.
Time management skills and reliability in consistently delivering against deadlines.

Desirable criteria

Ability to speak Welsh or willingness to learn

PERSONAL ATTRIBUTES & VALUES

Essential criteria

Able to make a connection between their work and the benefit to patients and the public.
Demonstrate the ability to work under pressure.
Works well with others, is positive and helpful, listens, involves, respects and learns from the contribution of others.
Ability and commitment to work constructively with internal and external partners to create the conditions for successful collaborations.
High level of Organisation, self- motivation and flexibility in approach and attitude.
Strong sense of commitment to openness, honesty and integrity. .
A strong sense of accountability.
Consistently looks to improve what they do.
Values diversity and difference operates with integrity and openness
Self-awareness in terms of emotional intelligence, biases and personal triggers with cultural sensitivity and awareness