Data Warehouse Engineer (Snowflake/dbt/AWS) - Contract

AgileSource are looking for a Data Warehouse Engineer for a 1-2 year project. Mixture of Hybrid/On-site work required so Cardiff or London would be the base location.

We are seeking a Data Warehouse Engineer to support the design, build and optimisation of a modern, cloud-based data warehouse environment.

The role will focus heavily on Snowflake, SQL, and dbt, working within an AWS ecosystem to deliver scalable, reliable data solutions that support analytics and downstream business use cases.

Key Responsibilities

• Design, build and maintain data warehouse solutions using Snowflake

• Develop and optimise ELT/ETL pipelines

• Create and maintain dbt models and macros (Jinja)

• Write high-quality, performant SQL to support reporting and analytics

• Work with AWS services, including serverless technologies

• Collaborate with data engineers, analysts and stakeholders across the business

Essential Skills & Experience

• Strong experience with Snowflake, including:

  • Internal and external stages

  • S3 read/write integrations

  • Warehouses and dynamic tables

• High proficiency in SQL

• Hands-on experience with dbt Core and dbt macros (Jinja)

• Python development experience

• Solid understanding of ELT/ETL processes

• AWS experience (Associate-level certification preferred)

• Exposure to AWS serverless services such as EventBridge, Step Functions and Lambda