Enterprise Data Engineer

Job Description

£43k - £50k, salary dependant on skills and experienceBase location in either Lincoln or Huntingdon (depending on your location) and home working (expectation is 2 days in the office) Permanent Full time, 37 hours per weekDo you have prior experience of Data Engineering, dimensional modellingDo you have experience of working within an Agile environment or are keen to work in oneDo you like to always explore, learn, challenge yourself and are a good team playerIf 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 providea 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 BIservice in step with emerging technologies and practices to ensure their activities continue to align to externally recognised best practices.What will my role involveThe 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 guidanceto 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

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 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, youll 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

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 suppliesover 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 embracingnew technology to drive digital transformation; better connecting our customers, people, assets and informationClosing date: 22nd October 2023#loveeverydrop