At a Glance
- Tasks: Build and maintain high-quality data products and pipelines for a sustainable energy future.
- Company: Join National Grid, a leader in energy transition and sustainability.
- Benefits: Competitive salary, generous holiday, pension scheme, and flexible working options.
- Other info: Collaborative environment with opportunities for mentorship and career growth.
- Why this job: Make a real impact on energy solutions while developing your data engineering skills.
- Qualifications: Strong programming skills in SQL/Python and experience with data modelling and pipeline frameworks.
The predicted salary is between 48000 - 58000 £ per year.
About Us
At National Grid, we light up the world by harnessing the unique strengths of our people. Join us as a 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.
This role can is based at our Warwick site with hybrid working - and you'll also have access to our London co-working space if that location suits your working pattern. Every quarter, you'll attend a 2-3 day in-person planning event held at one of our office locations.
Job Purpose
Reporting to the Data Product Manager in Customer Network Design, this is an opportunity to play a critical role in shaping the data that underpins essential customer operations. As a Data Engineer in our Customer Network Design team, you'll be at the heart of delivering high quality, resilient, and scalable data products, driving best in class engineering practices across the full data lifecycle - from ingestion and modelling through to curated, trusted, and reusable data products.
You’ll take real ownership of your work - leading data engineering activities end to end and setting the standard across pipeline development, information modelling, and data quality. With a strong focus on customer data products and CRM based sources, your impact will be visible, ensuring our data is not only reliable, but trusted at scale.
Information modelling sits at the core of this role. You’ll design and evolve the logical, physical, and canonical models that give our data structure and meaning - providing the foundation that makes pipelines consistent, data products reusable, and engineering faster and safer to change.
This is a hands-on engineering role where you’ll design, build, and evolve robust data pipelines and well-structured data assets, creating clean, maintainable, high performing code. Alongside this, you’ll play a key part in uplifting data engineering capability, supporting and mentoring junior Data Engineers and analysts, helping them adopt modern engineering approaches, strong modelling discipline, and effective configuration management practices.
Working closely with other Data Engineers and cross-functional teams, you’ll help ensure consistent standards, governance, and high quality delivery, aligned with wider Group engineering practices and long term technology strategy.
What You'll Do
As a Data Engineer, you’ll play a key role in ensuring we deliver high quality, resilient, and scalable data products that support critical customer and network operations. You’ll take ownership of delivery across the full lifecycle, driving excellence in both engineering and data quality standards. In this role, you will:
- Own and evolve our data pipeline capabilities - building and maintaining a robust, well-engineered ingestion and transformation codebase that supports the programme from initial delivery through to ongoing change.
- Lead on information modelling - designing and maintaining logical, physical, and canonical/semantic models that underpin and accelerate engineering activity, ensuring consistency, reusability, and clear meaning across our data products.
- Drive the integration of customer and CRM based sources - bringing together data from CRM platforms (e.g., Salesforce, Microsoft Dynamics 365) and other operational systems into curated, governed, customer facing data products.
- Champion best in class data engineering practices, working closely with Data Architects, Product Owners and Data Engineers to ensure consistent use of tools, standards, and engineering approaches.
- Design and develop high quality data products and pipelines, covering both functional and non-functional requirements.
- Lead on non-functional concerns, including performance, scalability, security, and cost efficiency - ensuring data platforms are reliable, secure, and scalable.
- Build and maintain traceability between source data, models, and data products, creating reusable assets, well documented lineage, and comprehensive regression and validation packs.
- Collaborate with stakeholders across the business to ensure the right data is available, well understood, and fit for purpose ahead of delivery.
- Analyse pipeline and data quality outcomes and provide clear, actionable insights, highlighting progress, risks, issues, and opportunities for improvement.
- Drive high quality issue and defect management, ensuring data issues are clearly documented with all necessary detail to support efficient resolution.
- Investigate complex issues across pipelines and environments, working hands-on to support root cause analysis and resolution.
- Act as a guardian of data quality, proactively identifying risks and escalating concerns to ensure standards are never compromised.
- Play an active role in Agile delivery, ensuring blockers and challenges are surfaced and resolved through ceremonies and team collaboration.
- Support and uplift others in the team, sharing knowledge and helping junior Data Engineers and analysts adopt modern, engineering led practices.
About You
You're a passionate Data Engineer who thrives on building high quality, scalable data products and continuously improving how teams approach data. You bring a strong engineering mindset, a problem solving attitude, and a drive to model, automate, and elevate data quality standards. To succeed in this role, you'll bring:
- Strong programming expertise in SQL and/or Python with a focus on writing clean, maintainable, and scalable code.
- Proven experience in data and information modelling - logical, physical - and a clear understanding of how strong models support and accelerate engineering activity.
- Hands-on experience with modern data pipeline and ETL/ELT frameworks such as dbt, and a passion for building robust, well-engineered solutions.
- Strong experience integrating CRM and customer data sources (e.g., Salesforce, Microsoft Dynamics 365) and other operational systems, using APIs and modern integration patterns.
- Exposure to cloud data platforms such as Azure (e.g., Databricks, Snowflake, Fabric), with experience building and running pipelines in cloud-based environments.
- A solid understanding of both batch and streaming data processing, and how to apply each effectively.
- Strong experience in data quality, governance, lineage, and cataloguing, ensuring trusted and compliant data products.
- A deep understanding of non-functional requirements, with the ability to translate them into effective, practical engineering approaches.
- Experience integrating data delivery into CI/CD pipelines and DataOps practices, working with modern build and delivery tooling.
- A clear grasp of test and quality led engineering principles and how they support reliable data delivery.
- Knowledge of data security approaches and an awareness of risks within enterprise environments.
- A strong track record of working in Agile teams, actively contributing to delivery, collaboration, and continuous improvement.
- The confidence to work autonomously, take ownership, and adapt in fast paced, evolving environments.
- Experience with software engineering tools such as Git, and code quality tools.
It would be great if you also have:
- Experience in data visualisation (e.g., Power BI), Streamlit or data catalogue/governance tooling.
What You'll Get
A competitive salary between £48,000 - £58,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.
More Information
The closing date for this vacancy is 6th July. However, we encourage candidates to submit their applications as early as possible and not to wait until the published closing date. National Grid's recruitment periods can and may vary. We reserve the right to remove this advert or close it to further applications at any point during the recruitment process.
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.
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.
Data Engineer in Warwick employer: National Grid
At National Grid, we pride ourselves on fostering a dynamic and inclusive work culture that empowers our employees to thrive. As a Data Engineer based in Warwick, you'll enjoy hybrid working options, competitive benefits including a generous pension scheme and performance incentives, and ample opportunities for professional growth through mentorship and collaboration with cross-functional teams. Join us in shaping the future of energy while enjoying a supportive environment that values innovation and diversity.
StudySmarter Expert Advice🤫
We think this is how you could land Data Engineer in Warwick
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like National Grid!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Data Engineer at National Grid.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like National Grid.
✨Apply Directly through Our Website
When you find a suitable opening like Data Engineer at National Grid, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Data Engineer in Warwick
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at National Grid, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at National Grid. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at National Grid
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at National Grid!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.