natgridProd
Lead Data Engineer

How your CV stacks up
Upload your CV to see how well it fits this job role
?%
About Us
At National Grid, we light up the world by harnessing the unique strengths of our people. Join us as a Lead Data Engineer to be part of a team that's driving forward the energy transition, creating a brighter, more sustainable future for all. Unleash your superpower and bring energy to life.
National Grid is hiring a Lead Data Engineer - This position is based from our Warwick office however we offer flexible hybrid working options.
Job Purpose
This role provides solutions for data challenges that support the electrification of the economy and drive to Net Zero. As the technical lead for data engineering in the team, you will set the engineering direction for our data products, own the standards other engineers build to and grow the capability of the engineers around you.
This role is part of a Product Team in National Grid's Electricity Transmission business supporting engineers, operational teams, planners, performance and regulatory teams by ensuring they have up to date, accessible, easy to understand and easy to use data so they can answer their questions.
We design, build and operate the data products Electricity Transmission runs on, taking accountability for their performance, reliability, security and continuous improvement throughout their lifecycle. These products comprise governed, reusable pipelines and data models that serve BI and KPI reporting, integration between operational applications and the data science, AI and advanced analytics workloads underpinning National Grid's BIG work. You will own the engineering patterns behind those products end to end: ingestion, transformation, modelling, testing, deployment, monitoring and operational support, ensuring solutions are scalable, supportable and repeatable across the estate.
What You'll Do
To work with National Grid Electricity Transmission to deliver actionable data products (pipelines) that drive business performance. Collaborating with key stakeholders, the lead data engineer will work to understand key business challenges, helping to determine the most impactful data and translate this into business requirements.
- Lead the design, build and delivery of data products (pipelines) that support Electricity Transmission's performance ambitions, taking technical accountability for the solutions the team ships.
- Set and maintain the engineering standards for the team — design patterns, coding standards, code review, testing, CI/CD and deployment practice — and hold delivery to them.
- Mentor and develop data engineers across the team and the wider community, growing depth in the skills we're short of and creating a genuine pathway for engineers to progress.
- The lead data engineer will own the implementation of data products (pipelines), consider the business readiness for product implementation, and undertake necessary engagement to ensure the data drives action and is continuously improved.
- Identify opportunities to increase business value, leading by example to create thoughtful and considered products, simplifying transformation, and ensuring alignment to ET's strategic priorities.
- Work with system, solution and data architects to shape target-state architecture — agreeing integration patterns, interface contracts, data modelling approaches and non-functional requirements, and making sure what we build fits the wider ET landscape rather than creating new silos.
- Own our data governance and data quality frameworks and controls, ensure requirements are met during development of products, and that data policies have been considered throughout the development and operation.
- Analyse insight to identify trends, use business context to articulate business performance issues and suggest options to improve business outcomes.
- Manage data product lifecycle, to ensure insight roadmap is managed, content remains relevant, and opportunities are identified for continuous improvement.
Reasons to use Rodeo
I’m in my final year doing Economics and I don’t know whether to apply for grad schemes now or do a masters first. What do you think?
Honest answer — it depends on where you want to end up. A lot of top grad schemes (Big 4, civil service, banking) don’t need a masters. Let’s look at the ones you’d be competitive for now, and we can decide if a masters actually adds anything.
Also worth knowing: most autumn 2026 applications are open now. Timing matters more than you think.
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
Graduate Consultant — 2026 Scheme
Why you're a good match
StrongYour economics background and your summer at a regional bank line up with what PwC looks for on the consulting scheme. Applications close in four weeks.
See breakdownIt searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Why you're a good match
You’ve got the grades and the economics background, and your bank internship is exactly the experience this scheme looks for. Apply soon — deadlines close within the month.
Experience fit
Your summer at the bank plus your econometrics coursework map directly to the day-one responsibilities on this scheme — client modelling, market briefings, and deal support.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
About You
- Demonstrable experience leading a data engineering team or workstream setting technical direction, reviewing others' work and being the person the team escalates to.
- Collaborate with Electricity Transmission to identify areas where data products would be beneficial in articulating and understanding business performance.
- Experience in stakeholder and user engagement, considering communication requirements and business readiness.
- Experience in data mining and manipulation for large datasets, experience of data profiling and experience of writing ETL code to present data for data quality rules and analysis.
- Experience in working within or product managing data development environment, acting as a stakeholder contact and working within a team to deliver successful insight, able to understand risk and controls and to track and monitor these.
- Working knowledge of modern data architecture patterns and where each applies — data mesh, data fabric, Lakehouse and domain-oriented ownership models.
Knowledge and experience of query language, data mesh methods and data transformation tools which may include but are not limited to:
- Data Querying - Structured Query Language (SQL), Python – Essential, C# -ideal
- Data Engineering – Microsoft ADF, DBT - Essential
- Database & Fabric – Snowflake, Promethium and Microsoft Fabric
- Data Visualization - Microsoft Power BI, Tableau
- Version Control – Git, DataOps.live, and experience of CI/CD for data pipelines.
Good to have certifications in:
- Experience supporting data science and AI/ML workloads as a consumer of the pipelines you build.
- Microsoft Certified: Azure Data Engineer Associate
- Additional specialist cloud or devops certifications
What You'll Get
A competitive salary between £54,000 – £65,000 dependent on capability
As well as your base salary, you will receive:
- 26 days holiday, plus eight statutory days, an option to buy extra holiday days, and the option to holiday swap up to 3 bank holiday days
- An annual performance incentive
- A generous pension scheme, double matched up to 6% of your salary each month. For every £1 you contribute we’ll put in another £2, so if you put in 6%, we’ll add 12% giving a total of 18% to your pension pot
- Life insurance at 10 times basic salary
- Employer funding towards a portion of your Private Medical Insurance.
- You will also have access to a number of flexible benefits such as a share incentive plan, salary sacrifice car and technology schemes, support via employee assistance lines and matched charity giving to name a few.


Get help with your application
Your very own career expert that helps elevate your application to the next level.
More Information
This role closes at midnight on 9th September 2026; however, we encourage candidates to submit their application as early as possible and not wait until the published closing date as this can vary.
National Grid Electricity Transmission (NGET) is at the heart of energy in the UK. The electricity we provide gets the nation to work, powers schools and brings energy to life. Our energy network connects the nation, so it’s essential that it’s continually evolving, advancing and improving.
In NGET we are passionate about both operating our network safely and providing highly reliable quality of supply for our customers. At the heart of achieving these outcomes is the effective control and operation of our network.
To find out more about us, please follow the link below: https://www.nationalgrid.com/electricity-transmission/
DE & I statement
At National Grid, we work towards the highest standards in everything we do, including how we support, value and develop our people. Our aim is to encourage and support employees to thrive and be the best they can be. We celebrate the difference people can bring into our organisation, and welcome and encourage applicants with diverse experiences and backgrounds, and offer flexible and tailored support, at home and in the office.
Our goal is to drive, develop and operate our business in a way that results in a more inclusive culture. All employment is decided on the basis of qualifications, the innovation from diverse teams & perspectives and business need. We are committed to building a workforce so we can represent the communities we serve and have a working environment in which each individual feels valued, respected, fairly treated, and able to reach their full potential.
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.
#LI-KR1 #LI-HYBRID
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location