Senior Data Engineer

Who we are

The Data Governance and Data Engineering Team, belonging to the organisation’s Data Team, play a huge role in providing quality and reliable data to feed into analytics products used by the business for decision
making.
 

The Senior Data Engineer role, a component of our Data Governance and Engineering Team, will be actively involved in the technical design, planning and implementation of data structures and pipelines within both our on-premises (Microsoft SQL Server) and cloud (Microsoft Azure) environments. On occasion, the Senior Data Engineer may be asked to deputise for the Lead Data Engineer, to liaise with stakeholders etc. As a senior member of the team, the role holder will also support the learning and development of junior members of the team.
 

We are looking for a talented individual to join us as we continue our data and analytics journey within Dwr Cymru Welsh Water. There will be opportunity to get involved with the latest cloud-based technologies and advanced analytics, and to be part of a collaborative, supportive and high-performing team within our organisation.
 

What you’ll be responsible for
 

This is an exciting role that will allow you to play a key role in developing our new cloud-based data platform. As Senior Data Engineer, you will be working on technical data engineering development on the new platform, whilst 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
 

• Mentoring and supporting Data Engineers within the team, helping ensure developed solutions are robust, efficient and add business value.    
• Designing and implementing data engineering projects on both on-premise and cloud based data stacks, delivering efficient solutions that comply with architectural and data security requirements.     
• 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.   
• Working closely with technical 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.  
• Remain aware of new data engineering approaches, and be able to suggest how the latest research, techniques and approaches could be implemented to achieve business benefits.
• Undertaking any other duties as required to meet the needs of the business.

Who you’ll work with

Internal

• Data Team
• Integrated Technology Services (ITS) e.g. Architecture, InfoSec
• Stakeholders across our retail, operational and support functions

External

• Third party partners such as Infosys
   

About you

Knowledge, Skills & Experience:
 

• Experience in on-premise SQL server to cloud migration
• Experience in any of the following or related fields: database management, data architecture, data platform management
• Good understanding of typical ingestion patterns (e.g. ETL, ELT) and their effective implementation with on-premise and cloud-based environments
• Experience of using cloud-based data stack (e.g. Azure, AWS, GCP)
   

Good to know

This is a hybrid role and there is an expectation to visit the office at least once a month for collaboration.
 

Benefits

As well as a market competitive salary, 33 days  annual leave (pro rata, including public holidays), we offer a range of employee benefits and rewards including:

• Variable pay schemes (your salary will always stay the same, but depending on the performance of the company you could receive a yearly bonus)
• Enhanced employer pension contributions – Up to 11% employer contributions
• Enhanced family friendly policies
• Progression opportunities, including the ability to apply for funded training and coaching and mentoring programmes
• Reduction on gym memberships and high street shopping
• Cycle to work scheme
• Car-leasing scheme
• Health CashBack scheme
• An employee assistance programme for employees and their immediate family

Whilst also working for a not-for profit company that truly cares about earning the trust of customers everyday, and about looking after our beautiful environment.
 

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.  The security of our people, assets and information is key to us, so we are looking for people who understand and comply with the company’s required security objectives.
 

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.