Enterprise Data Engineer

Anglian Water Services Ltd; Huntingdon; Hybrid; GBP 42,000 - 50,000; Full time

Job summary

A utility company in the UK seeks an experienced Enterprise Data Engineer to enhance its data services. The role involves working within an Agile environment, designing robust data solutions, and delivering end-to-end BI projects. Ideal candidates will have 3-5 years of data engineering experience, particularly with tools like Databricks and Azure Data Factory. Competitive salary and benefits including health care and flexible working options are offered.

Benefits

Personal private health care

26 days annual leave

Flexible working

Pension scheme

Bonus scheme

Qualifications

• Strong experience in data engineering ideally using Databricks and related tools.
• Experience delivering end-to-end BI solutions from design to delivery.
• Strong data engineering experience of at least 3-5 years.

Responsibilities

• Contribute to work estimation and support onboarding of new team members.
• Adopt agile development and contribute to drafting service policies.
• Design robust corporate data solutions following dimensional modelling methodology.

Skills

Databricks

Azure Data Factory

Spark

Python

SQL

PowerBI

Dimensional data modelling

Agile methodologies

Product lifecycle management

Azure DevOps

Job description

Overview

Base location in either Lincoln or Huntingdon (depending on location) with home working. Expectation is 2 days in the office. Permanent full time, 37 hours per week.

Do you have prior experience of Enterprise Data Engineering, dimensional modelling? Do you have experience of working within an Agile environment or are keen to work in one? Do you like to always explore, learn, challenge yourself and are a good team player? If you can answer yes to the above we have an exciting opportunity for you with our expanding team!

The Data and Digital Services team will transform the way data and digital services are provided in Anglian Water, moving from an order-taker service to a trusted, informed partner. The data service will go beyond the traditional data warehouse to provide a modern business intelligence capability that supports distributed (crowd-sourced) reporting and analytics, allowing business SMEs and data and analytics SMEs to work hand in hand to deliver insight to drive business performance. The team will keep the BI service in step with emerging technologies and practices to ensure their activities continue to align to externally recognised best practices.

Responsibilities

• Actively contribute to work estimation
• Adopt and embed agile development and continuous improvement into team ways of working
• Support the onboarding of new team members & coach other Data Engineers
• Actively contribute to drafting and updating service policies, procedures, work instructions and guidance notes
• As a BI Solution Architect/Dimensional Modeller, design robust, secure and supportable corporate data solutions following dimensional modelling methodology, considering privacy by design and self-service capabilities by default
• As an ETL Developer, develop, test and/or quality assure extracts of data from corporate systems into the Data Lake
• As a Semantic Layer Developer, develop, test and/or quality assure semantic models
• As a Report Developer, develop, test and/or quality assure reports, visualisations and dashboards, producing lo-fi and hi-fi wireframes and capturing purpose
• As a Test Automation Specialist, build automated test frameworks, develop test harnesses and raise overall test coverage across the project
• Collaborate with each squad to embrace automated testing and resolve technical challenges; contribute to robust delivery pipelines aligned with modern DevOps practices

Qualifications

• Previous strong experience in data engineering ideally using Databricks, Azure Data Factory, Spark, Python, SQL, PowerBI
• Strong data engineering experience of at least 3-5 years
• Dimensional data modelling
• Experience delivering end-to-end BI solutions from requirements, design to delivery
• Experience working within an Agile/Scrum environment
• Experience/understanding of Product lifecycle management
• Knowledge of Azure DevOps or similar tools

Remuneration & Benefits

• Salary: £50k
• Personal private health care
• 26 days annual leave - rising with length of service
• Flexible working
• Pension scheme - Anglian Water double-matches your contributions up to 6%
• Bonus scheme
• Flexible benefits to support your wellbeing and lifestyle

Engineering

https://awg.wd3.myworkdayjobs.com/AW/job/Lincoln/Enterprise-Data-Engineer_R32183-1