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