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