Data Engineer x 3

National Trust; Swindon; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A prominent conservation organization in Swindon seeks a Data Engineer to develop and maintain data pipelines that enhance decision-making. The ideal candidate should be experienced with dbt and Snowflake, have strong SQL skills, and be familiar with Python and data modelling principles. Join a collaborative Agile team dedicated to using data effectively in line with our strategic goals. This role offers substantial benefits, including a pension scheme and flexible working arrangements.

Benefits

Pension scheme of up to 10%

Free entry to National Trust places

Rental deposit loan scheme

Season ticket loan

EV car lease scheme

Discounts on gym memberships and shopping

Holiday allowance up to 32 days

Flexible working

Employee assistance programme

Free parking at most Trust places

Qualifications

• Experience in building data pipelines using dbt and Snowflake.
• Strong SQL skills and experience with relational databases.
• Familiarity with Python for data transformation and automation.
• Understanding of star schema modelling and data architecture.
• Experience working with Salesforce Data Cloud or willingness to develop expertise.

Responsibilities

• Design, build, and maintain data pipelines using dbt and Snowflake.
• Transform raw data into trusted, reusable data products.
• Collaborate with colleagues to understand requirements and deliver solutions.
• Contribute to data governance and ensure data quality.

Skills

Building data pipelines using dbt

Strong SQL skills

Familiarity with Python

Understanding of star schema modelling

Experience with Salesforce Data Cloud

Familiarity with cloud-based platforms (e.g., Azure)

Ability to work in Agile teams

Awareness of data governance principles

Tools

dbt

Snowflake

Terraform

Job description

Summary

• Important notice
• In line with our redeployment policy, we’ll prioritise applications from employees who are under formal notice of redundancy. We’re looking for a Data Engineer to help build and maintain the data products that power decision-making across the National Trust. You’ll work with modern tools like Snowflake and dbt to deliver high-quality, scalable data pipelines that support our People and Nature Thriving strategy.

What it's like to work here

You’ll join a collaborative Agile delivery team within our IT function, working alongside analysts, BI developers, and business stakeholders across the organisation. We value creativity, learning, and impact. You’ll report to the Lead Data Engineer and be part of a team that’s passionate about using data to support the ongoing delivery of our strategy.Your contractual location will be our head office in Swindon and there will be an expectation for you to attend the office. However, there is flexibility on where you are based at other times. You will be required to work at a National Trust location for 40‑60% of your working week. This will be discussed in more detail at interview. There is an expectation to work from our Swindon office two days a week.

What you'll be doing

You’ll design, build and maintain data pipelines using dbt and Snowflake, transforming raw data into trusted, reusable data products. You’ll work with star schema models to support reporting and analytics. You’ll collaborate with colleagues to understand requirements and deliver solutions that meet business needs. You’ll contribute to data governance, ensure data quality, and help improve how we manage and share data across the Trust.

Who we're looking for

Applications from redeployees are assessed against the minimum criteria for the role. In your application, please provide details of how you meet the minimum criteria below.

• Experience building data pipelines using dbt and Snowflake
• Strong SQL skills and experience with relational databases
• Familiarity with Python for data transformation and automation
• Understanding of star schema modelling and data architecture
• Experience working with Salesforce Data Cloud or willingness to develop expertise

Criteria for all other candidates

• Familiarity with cloud-based data platforms (e.g., Azure) and infrastructure-as-code tools like Terraform
• Ability to work collaboratively in Agile teams
• Awareness of data governance and security principles

The package

The National Trust has the motto ‘For everyone, for ever’ at its heart. We’re working hard to create an inclusive culture, where everyone feels they belong. It’s important that our people reflect and represent the diversity of the communities and audiences we serve. We welcome and value difference, so when we say we’re for everyone, we want everyone to be welcome in our teams too.

• Substantial pension scheme of up to 10% basic salary
• Free entry to National Trust places for you, a guest and your children (under 18)
• Rental deposit loan scheme
• Season ticket loan
• EV car lease scheme
• Perks at work discounts such as gym memberships, shopping discount codes, cinema discounts
• Holiday allowance up to 32 days relating to length of service, plus holiday purchase scheme, subject to meeting minimum criteria.
• Flexible working whenever possible
• Employee assistance programme
• Free parking at most Trust places