Share this Job

Principal Data Engineer (Welsh Water) Competitive

Date: 19-Sep-2021

Location: Cardiff, GB, CF3 0LT

Company: dwrcymrucy

Job Requisition Number                              2061                                                                              
Work Type Permanent
Job Function Data / Knowledge Management
Salary Range Competitive
Location Cardiff & Home Working (50/50)

Who we are


Dŵr Cymru Welsh Water keep 3 million people healthy each day with safe, reliable water, and take away wastewater to clean, before returning it safely to our beautiful rivers and seas.

To be able to deliver high quality, essential services which help to protect the health of our customers, colleagues and our environment, we need the right people to deliver on our vision.  This is achieved by living our core values and demonstrating the core behaviours that underpin them.

We know that the most successful teams are the most diverse teams. Equality, diversity and inclusion provide the very foundation to our culture at Welsh Water. We want every individual to feel confident, proud and able to bring their whole selves to work. 

To ensure an improved representation in our workforce, applications are particularly welcome from minority groups including Black, Asian and Minority Ethnic people, Females, LGBT+, Non-binary and people with disabilities. Together we continue to build a workplace that not only celebrates the diverse voices of our colleagues but also represents each customer we serve.

In essence, ours is a company based on trust, openness, respect, commitment and honesty. A company that our colleagues are proud to work for.


What you’ll be responsible for


This is a new and exciting role that will allow you to play a leading role in developing our new cloud-based data platform.   You will be leading on the technical data engineering development on the new platform, whilst also supporting our existing set of SQL Servers, that are predominantly used to feed data into a number of analytics products produced by the Data Team to help the business with data-led decision making.

Your responsibilities will include

1.        Line managing a small team of database developers and data engineers, supporting newer members of the team (particularly graduates and apprentices) to develop their own understanding
2.        Managing and participating in the design and implementation of data engineering projects on both on-premise and cloud based data stacks, delivering efficient solutions that comply with architectural and data security requirements, on time
3.        Working closely with the Data Governance and Engineering Manager to ensure relevant strategic objectives (e.g., utilisation of the cloud data platform etc.) successfully progress
4.        Being able to work collaboratively as part of a team, whilst also being trusted to work individually where necessary.  Approaching collaborative projects with others in a positive manner to problem-solve, and identify viable solutions to overcome issues and challenges
5.        Working closely with technical and management colleagues within key teams such as Integrated Technology Services (ITS) – to ensure relevant information technology components and services are in place to accommodate developed solutions
6.        Actively horizon-scan across a rapidly changing field, assessing how the latest research, techniques and approaches could be implemented to achieve business benefit
7.        Undertaking any other duties as required to meet the needs of the business.


Who you’ll work with


•    Data Team 
•    Integrated Technology Services (ITS) e.g. Architecture, InfoSec
•    Third party partners such as Infosys
•    Stakeholders across our retail, operational and support functions


About you



  • Relevant undergraduate degree (BSc) in computer science, mathematics or related discipline, relevant long term experience or MCSA/MTA certification



  • Ideally 5 years+ experience in any of the following or related fields: database management, data architecture, data platform management
  • Ideally 5 years+ experience using cloud-based data stack (e.g. Azure, AWS, GCP)


Knowledge & Skills

Top three - 

  • Substantial, demonstrable experience of data pipeline design and management
  • Solid understanding of database administration activities and principles
  • Strong understanding of typical ingestion patterns (e.g. ETL, ELT) and their effective implementation with on-premise and cloud-based environments


Other knowledge & skills

  • Enthusiastic about putting our customers first every day
  • Knowledge of typical data modelling approaches (e.g. Kimball) and experience of working with and building data warehouses
  • Data transformation approaches
  • Advanced Python and SQL programming capabilities
  • Experience using the Microsoft data stack (especially Azure Data Lake, Azure Synapse, Azure Data Factory) 
  • Data security approaches – e.g. permission models (AD, role-based etc.) and techniques to protect data in certain circumstances (e.g. encryption, masking)
  • Demonstrable experience of the full software/reporting lifecycle from planning and design through to deployment and maintenance
  • Strong understanding of DevOps (or other source control technologies) – particularly code repositories and version control, containerisation methodologies, and application deployment practices (CI/CD pipelines)


Desirable (should not deter you from applying)

  • Knowledge of the Microsoft BI Stack, including SQL Server Analysis Services, Integration Services and Reporting Services, and Power BI - Desirable only
  • Experience using common agile project management principles, particularly in the context of data and analytical project delivery - Desirable only



We offer a range of employee benefits including:

  • Variable annual pay schemes (annual bonus)
  • Enhanced employer pension contributions
  • Reduction on gym memberships and high street shopping
  • Cycle to work scheme
  • Car-leasing scheme
  • Health CashBack scheme
  • 20% discount across all of our visitor centres and gift shops across Wales
  • Flexible working patterns
  • An employee assistance programme for employees and their immediate family (24 hour free online and confidential support phoneline)
  • Several internal employee networks including BAME+, LGBTQI+, Neurodiverse, Disability, Women of Welsh Water, Parents, Wellbeing and many more!
  • We also have our own Wellbeing Champions that you can also volunteer to become - the programme offers full i-act and StRaW training. 






Closing date


The role will remain open until we have found a suitable match, please apply ASAP


For an informal chat about the role, please contact: Justin.Doran@dwrcymru.com




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

© Dŵr Cymru Cyf 2019.

Job Segment: Database, Architecture, Engineer, Computer Science, SQL, Technology, Engineering