Data Engineer

Dŵr Cymru Welsh Water; Cardiff; Ibrido; GBP 43.000 - 49.000; Tempo pieno

Vantaggi offerti da questo lavoro

Hybrid work arrangement

Office-based once a week

Descrizione del lavoro

Dŵr Cymru Welsh Water in Cardiff is seeking a Data Engineer to help evolve our cloud-based data platform. You will design and deliver data pipelines, support SQL Server-based analytics feeds, and enable data-led decision making across the business.

You'll build robust on-prem and cloud data stacks, ensure data quality and security, collaborate with data teammates and stakeholders, and stay current with new data engineering techniques.

Competenze

• Substantial experience designing and managing data pipelines.
• Proactive problem solving and ability to explain solutions to data teams and stakeholders.
• Good understanding of database administration and data security approaches.
• Experience with data transformation techniques and on-prem/cloud stacks.
• Strong Python and SQL programming capabilities.
• Familiarity with Microsoft data stack tools and BI suites.

Mansioni

• Design efficient data engineering projects across on-prem and cloud stacks.
• Build, maintain and support data pipelines; resolve incidents.
• Deliver end-to-end data solutions with data quality, testing and documentation.
• Collaborate with data teams and other technical colleagues across the business.
• Stay updated on new data engineering approaches and potential business benefits.
• Undertake other duties to meet business needs.

Conoscenze

Python

SQL

Data pipelines

Data security

Database administration

Data transformation

Stakeholder communication

Strumenti

Azure Data Lake

Azure Synapse

Azure Data Factory

Databricks

Power BI

Microsoft BI Stack

Descrizione del lavoro

Select how often (in days) to receive an alert:

City: Cardiff

Address:

Cardiff, Wales, GB, CF3 0LT

Job Requisition Number 9006

Work Type Permanent

Job Function Data / Knowledge Management

Salary Range £42,786.00-£48,912.00

Base

Closing Date

Linea (St Mellons, Cardiff) - Hybrid Options

23:59 on 17 August 2026

What you’ll be responsible for

This is an exciting role that will allow you to be integral to the evolution of our cloud-based enterprise data platform. As a Data Engineer, you will be working on technical solutions, whilst supporting our existing set of SQL Servers that are predominantly used to feed data into a number of analytics products. This will help the business with data-led decision making to provide essential public services.

Your responsibilities will include:

• Designing efficient and robust data engineering projects within both on-premises and cloud-based data stacks that add business value and comply with architectural and data security requirements.
• Building, maintaining and supporting data engineering pipelines, with resolution of incidents.
• End-to-end delivery of data engineering solutions, including data quality, testing, peer reviewing, documenting and demonstrating of completed solutions to the team.
• Working closely with teams within data and other technical colleagues across the business.
• Remaining aware of new data engineering approaches, and be able to suggest how the latest research, techniques and approaches could be implemented to achieve business benefit
• Undertaking any other duties as required to meet the needs of the business.

About you

Essential Qualifications, Knowledge and Experience

• Substantial experience of data pipeline design and management
• Enthusiasm to add customer value whilst improving the effectiveness of the data engineering function
• Proactive problem solving and being able to effectively communicate solutions to both the data team, and to stakeholders
• Good understanding of database administration activities and principles
• Data transformation approaches
• Strong Python and SQL programming capabilities
• Data security approaches – e.g. permission models (AD, role-based etc.) and techniques to protect data in certain circumstances (e.g. encryption, masking)

Desirable Qualifications, Knowledge and Experience

• Familiarity with common agile project management principles, particularly in the context of data and analytical project delivery
• Good understanding of typical ingestion patterns (e.g. ETL, ELT) and their effective implementation with on-premises and cloud-based environments
• Knowledge of typical data modelling approaches (e.g. Kimball)
• Experience using the Microsoft data stack (especially Azure Data Lake, Azure Synapse, Azure Data Factory, Databricks)
• Experience of the full software/reporting lifecycle from planning and design through to deployment and maintenance
• Knowledge of the Microsoft BI Stack, including Analysis Services, Integration Services and Reporting Services, and Power BI
• Understanding of DevOps (or other source control technologies) – particularly code repositories and version control, containerisation methodologies, and application deployment practices (CI/CD pipelines)

Good to know

• Hybrid based - requirement for office based work once a week.
• Flexi working around core business hours (10:00 to 15:00), most of the team work 09:00 to 17:00

Dŵr Cymru Cyf, a limited company registered in Wales No. 2366777. Registered office: Linea, Fortran Road, St. Mellons, Cardiff CF3 0LT

Job Segment: Cloud, Testing, DBA, SQL, Database, Technology