Data Engineer

Do you have experience in Terraform?, 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 packageThe 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

Requirements :Compliance.Eligibility to Work in the UK Permanent f/t (37.5 hrs pw)

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.