Data Engineer

National Grid plc; Warwick; Hybrid; GBP 65,000 - 90,000; Full time

Job summary

National Grid plc is seeking an experienced analytics professional to provide data engineering expertise across ETL, data modelling, and governance for analytics platforms in a hybrid Warwick (UK) role. You will design and maintain data products, pipelines, and dashboards to enable business insights and performance measurement.

The role emphasizes building scalable data solutions, collaboration with stakeholders, and applying data mesh concepts with federated governance.

Qualifications

• Experience in data mining, profiling, and manipulation of large datasets.
• Proficiency in writing ETL code and implementing data quality rules.
• Advanced Power BI skills, including DAX, Power Query (M), data modelling, and report design.
• Proficient in Python, SQL, Azure Data Factory, Git, and DBT.
• Experience with Snowflake and big data tooling (Databricks, Trino).
• Strong experience in API development and testing.
• Familiarity with data mesh concepts such as data as a product, domain ownership, and federated governance.
• Knowledge of JIRA and agile delivery practices.

Responsibilities

• Develop and maintain ETL pipelines and data models for analytics and reporting platforms.
• Design, build, and maintain data products that serve specific business domains and use cases.
• Conduct advanced data mining and manipulation, advising on architecture and data model changes.
• Design and deliver Power BI dashboards and reports that provide actionable insights to business stakeholders.
• Set strategic roadmaps for information quality and ensure critical data dependencies are recognised and governed.
• Collaborate with business users to catalogue data lineage and develop data quality dashboards using modern tooling.
• Ensure data consistency through cleaning, transformation, and validation processes.
• Support data scientists and analysts by delivering robust data solutions aligned with business objectives.
• Build and maintain APIs to enable secure, scalable data exchange across systems.
• Develop and optimise data pipelines using Snowflake and other big data tools such as Databricks and Trino.
• Contribute to the implementation of data mesh principles and federated data governance.
• Leverage Data Fabric platforms such as Promethium to unify data access, discovery, and governance.
• Integrate and orchestrate data flows using MuleSoft and SnapLogic.

Skills

Data mining

Data profiling

ETL development

Power BI

Python

SQL

Azure Data Factory

Git

DBT

Snowflake

Databricks

Trino

APIs

Data governance

Data mesh concepts

JIRA & Agile

Tools

Snowflake

Databricks

Trino

MuleSoft

SnapLogic

Promethium

Job description

At National Grid, we keep people connected and society moving. But it’s so much more than that. National Grid provides the environment, support, and purpose that enable us to make real impact. As we drive momentum in the energy transition for all, we’re committed to ensuring none of our customers are left in the dark.

This role operates under a hybrid working model and is based out of the Warwick, UK office. Hybrid work expectations are subject to business needs and company policy.

About the Role

To provide analytical expertise across all areas of ET in the manipulation, interpretation, and management of data. The role focuses on designing and implementing architectural and data model changes across core applications and strategic data platforms to support business outcomes. A key purpose of the role is to design, build, and maintain high-quality data products that are discoverable, reusable, and aligned with domain needs—enabling decentralised data ownership and supporting a data mesh approach. The role also involves profiling data to implement quality rules that enable visibility into data health and drive improvements to support business insight and performance metrics.

What You'll Do

• Develop and maintain ETL pipelines and data models for analytics and reporting platforms.
• Design, build, and maintain data products that serve specific business domains and use cases.
• Conduct advanced data mining and manipulation, advising on architecture and data model changes.
• Design and deliver Power BI dashboards and reports that provide actionable insights to business stakeholders.
• Set strategic roadmaps for information quality and ensure critical data dependencies are recognised and governed.
• Collaborate with business users to catalogue data lineage and develop data quality dashboards using modern tooling.
• Ensure data consistency through cleaning, transformation, and validation processes.
• Support data scientists and analysts by delivering robust data solutions aligned with business objectives.
• Build and maintain APIs to enable secure, scalable data exchange across systems.
• Develop and optimise data pipelines using Snowflake and other big data tools such as Databricks and Trino.
• Contribute to the implementation of data mesh principles and federated data governance.
• Leverage Data Fabric platforms such as Promethium to unify data access, discovery, and governance.
• Integrate and orchestrate data flows using MuleSoft and SnapLogic.

About You

• Strong experience in data mining, profiling, and manipulation of large datasets.
• Proficiency in writing ETL code and implementing data quality rules.
• Advanced Power BI skills, including DAX, Power Query (M), data modelling, and report design.
• Skilled in Python, SQL, Azure Data Factory, Git, and DBT.
• Experience with Snowflake and big data tooling (e.g. Databricks, Trino).
• Strong experience in API development and testing.
• Familiarity with data mesh concepts such as data as a product, domain ownership, and federated governance.
• Demonstrated experience in data governance, including stewardship, policy implementation, and metadata management.
• Knowledge of JIRA and agile delivery practices.
• Effective communicator with the ability to translate complex data issues for diverse audiences.

We value diversity and are committed to creating an inclusive workplace for all. We welcome applications from all suitably qualified candidates – we make appointments purely on merit, assessed against objective selection criteria. We support flexible working and will make reasonable adjustments throughout the recruitment process should you have any physical or mental impairment which may affect your ability to participate in the process.

Please note that in most cases, National Grid is unable to offer sponsorship for employment under the UK points-based immigration system. As such, applicants must have the legal right to work in the UK without requiring sponsorship now or in the future under the UK points-based immigration system. However, in exceptional circumstances where there is a clear and demonstrable need for specialist skills that cannot be sourced from the local labour market, National Grid may consider offering sponsorship. All applications are welcome from candidates who meet these requirements, regardless of race, nationality, or ethnic origin.

National Grid operates in both the UK and US, with a broad portfolio of energy businesses dedicated to providing safe, reliable, and sustainable power.

From electricity and gas transmission to advancing clean energy and modernising grids, our work covers every aspect of the energy system.

Our energy flows through absolutely everything we do

Life here at National Grid is more than just our purpose or our values, it’s everything we put into everything we do. It’s our commitment to diversity and inclusion; how we help our employees learn and grow; and how we partner with and support the communities where we live and work. It’s all this, and so much more.

We leverage our collective strengths to do meaningful BIG work so that we can be at the heart of a fair and affordable energy future.

Your salary is reviewed each year against the market for your role, skills, knowledge and experience.

Incentive

Annual performance plan or bonus (depending on your role) rewards your contribution to our success each year.

Retirement

Generous pension plan with company contributions up to 12%.

Private medical insurance for self and family.