Data Engineer

Important notice

The National Trust does not offer sponsorship.

We welcome applicants with right to work in UK, but we are unable to offer any form of visa sponsorship.

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, dbt and Azure 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 Enterprise Data Manager 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 help manage and support the Enterprise Data Platform (EDP), including CI/CD pipelines, infrastructure-as-code deployments and cloud services. You'll contribute to data governance, ensure quality and help improve how we manage and share data across the Trust.

Who we're looking for

We welcome applicants with right to work in UK, but we are unable to offer any form of visa sponsorship.

• Experience building modern data pipelines using dbt and Snowflake, including deploying dbt in Azure DevOps and working with star schema models.
• Strong SQL and Python skills for transformation, automation and integration across Azure and Snowflake.
• Knowledge of Snowflake administration, including roles, masking policies, warehouse performance and general database management.
• Experience with cloud engineering and CI/CD, including Azure DevOps pipelines, Agent Pools, and managing structured lifecycle deployments (Dev Pre Prod Prod).
• Familiarity with infrastructure and cloud tooling, such as Terraform, Azure Blob Storage, Key Vault, Function Apps and Azure Data Factory.
• Experience working with Salesforce Data Cloud or a willingness to develop expertise.
• Good general technical skills, e.g. Unix/Windows sysadmin, VS Code, Docker and Python virtual environments.
• Experience supporting BI and analytics platforms, such as deploying changes to Tableau datasets, along with an understanding of Agile delivery, 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