Data Engineer (Welsh Water)

Job Requisition Number                              6386                                                                               Work Type Permanent Job Function Data / Knowledge Management Salary Range

£39,904.00 -£45,616.00 

+ annual salary uplift
+ annual cost of living increase + bonus

Base

Closing Date

South East Hub Cardiff (Hybrid Flexible Working)

Please apply ASAP - we will review applications on a weekly basis until the role is filled with a suitable match.

 

What you’ll do

 

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

The Data Engineer role, a component of our Data Governance and Engineering Team, participates in the technical planning and implementation of data structures and pipelines within both our on-premises (Microsoft SQL Server) and cloud (Microsoft Azure) environments.  The Data Engineer will work closely with both Database Developers and the Lead Data Engineer to ensure developed solutions are robust, accurate and efficient 

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. 

 

 

You will be working on a number of on premise SQL Servers, undertaking both database administration activities, and building pipelines to feed data into analytics outputs, such as predictive models etc.  You will also support the progression of our new cloud-based data platform by contributing to development initiatives using tools within the Azure (cloud) data stack. 

Your responsibilities will include
    
1.        Designing and implementing high quality data engineering solutions on both on-premise and cloud based data stacks, ensuring compliance with architectural and data security requirements 
    
2.        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 overcome issues and challenges
    
3.        Working closely with technical colleagues within key teams within Integrated Technology Services (ITS) – to ensure relevant information technology components and services are in place to accommodate developed solutions
    
4.        Remain aware of new developments within the specialist field
    
5.        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
• Third party partners such as Infosys
• Stakeholders across our retail, operational and support functions

About you

 

Qualifications

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

 

Experience

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

 

Knowledge & Skills

• Enthusiastic about putting our customers first every day
• Experience of data pipeline design and creation
• Database administration activities
• Data transformation approaches
• 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

• An awareness of typical ingestion patterns (e.g. ETL, ELT) and their effective implementation with on-premise 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) 
• An awareness of the full software/reporting lifecycle from planning and design through deployment and maintenance. From requirement gathering to report or dashboard solution.
• Awareness 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

 

• We offer a flexible hybrid working model where you will be required to work from home as well as at one of our offices on some occasions. Please feel free to email Craig should you require a more specific breakdown.
• Interviews will take place virtually and we will aim to book your interview ASAP.
• Any questions? Please contact craig.hodges@dwrcymru.com

 

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 band will remain the same, but performance depending, you could receive an incremental within-band increase and a yearly incentive)
•    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
•    Free on-site parking at all our sites
•    Discount off all Welsh Water visitor attraction centres and gift shops
•    Car-leasing scheme
•    Health CashBack scheme
•    An employee assistance programme for employees and their immediate family
•    Colleague matched fundraising scheme up to the value of £500 per year for your chosen charity

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

Please note, we may close this role sooner if required. We may also extend the original closing date depending on interest.

Due to the nature of the industry, we require satisfactory references, post offer medical clearance, and a criminal records Basic Disclosure check on all new employees joining the business. For some roles there may be additional checks and security clearance required, and this offer is subject all checks being satisfied. You will receive further information on how to complete these checks via email once you have accepted this offer.

 

INDHP

 

Who we are

Our careers website https://jobs.dwrcymru.com/
Meet our people video https://youtu.be/VKAifNbjcz0

 

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.

 

 

 

 

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.