Hybrid Data Engineer: Snowflake, dbt & Data Pipelines

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

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.