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:
1. Experience building data pipelines using dbt and Snowflake
2. Strong SQL skills and experience with relational databases
3. Familiarity with Python for data transformation and automation
4. Understanding of star schema modelling and data architecture
5. Experience working with Salesforce Data Cloud or willingness to develop expertise
Criteria for all other candidates:
6. Familiarity with cloud-based data platforms (e.g., Azure) and infrastructure-as-code tools like Terraform
7. Ability to work collaboratively in Agile teams
8. 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