Data Engineer

  • Job Reference: R10226
  • Date Posted: 22 February 2021
  • Employer: Anglian Water
  • Location: Lincoln, Lincolnshire
  • Salary: £42,000 to £45,000
  • Sector: Information Technology (IT)
  • Job Type: Permanent
  • Work Hours: Full Time

Job Description

Enterprise Data Engineer

Salary £42,000 - £45,000

Location: Lincoln/Huntingdon/Flexible working

Employment type Permanent

Hours 37 hours per week

Do you have prior experience of 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!

Team overview

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.

What will my role involve?

The Enterprise Data Engineer is a T-shaped professional (also referred to as a generalised specialist) with identifiable core skills yet with an ability to work across multiple disciplines (both technical and non-technical) as required.

The Enterprise Data Engineer whilst having core skills to enable them to deliver data and analytical solutions on our analytics and BIG data platform, you will also act as a technical expert in all aspects of delivery and provide leadership and guidance to small project teams/resources in a collaborative way.

You will be expected to work in Agile/Scrum environment in a squad model consisting of various other developers. You may be expected to work as lead on the squad and/or fulfil other roles within the squad.

The Enterprise Data Engineer will have the core skills to be able to carry out following activities

  • Actively contribute to work estimation

  • Adopt and embed agile development and continuous improvement into team ways of working

  • Support the on boarding of new team members & coach other Data Engineers

  • Actively contribute to drafting and updating our service policies, procedures, work instructions and guidance notes.

  • As a BI Solution Architect/Dimensional Modeller, design robust, secure and supportable corporate data solutions to meet business requirements 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, responsible for building new automated test frameworks, for developing test harnesses for each component and be responsible for raising the overall test coverage across the project. would work with each squad to ensure the culture of automated testing is embraced and that any technical challenges are resolved. These processes are essential to building robust delivery pipelines if the solution is to adopt modern DevOps processes.

What does it take to be a Data Engineer?

  • Previous experience in data engineering ideally using Databricks, Azure Data Factory, Spark, Python, SQL, Cosmos DB, Microsoft Azure Analysis services, PowerBI

  • Dimensional and relational data modelling

  • Experience in delivering end to end BI solution from requirements, design to delivery

  • Experience of working within an Agile/Scrum environment

  • Experience/understanding of Product lifecycle management

  • Knowledge of Azure DevOps or similar tools

As a valued employee, you'll be entitled to:

  • 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.

As our region flourishes it is our priority to support our economy, customers and communities; driving sustainable growth and building resilience across our services. We recently announced plans to invest £6.5 billion to protect our regions water supplies over the coming years.

Our OT team is currently undergoing a transformation which will enhance the services it delivers and ensure they are best positioned to play a proactive and value orientated role across our business. Our goal is to exceed customer expectations whilst embracing new technology to drive digital transformation; better connecting our customers, people, assets and information