Data Engineer - Snowflake&DBT

Square One Resources; City Of London; Hybrid; GBP 111,000 - 129,000; Full time

Job summary

Square One Resources is recruiting a Data Engineer to design and deliver cloud‑native data solutions using Snowflake and dbt in a largely London‑based environment. The role focuses on building scalable pipelines, governance, and platform improvements within an Agile setting.

You will work with SQL, Python and modern data architectures to optimise data flows, support migration, and partner with offshore teams on Aladdin‑related use cases. This contract spans 3–4 months, with potential extension.

Qualifications

• Strong data engineering background with cloud data architectures.
• Extensive hands‑on Snowflake and dbt experience.
• SQL and Python skills; data quality and governance experience.

Responsibilities

• Develop and maintain data pipelines using Snowflake and dbt.
• Build modular dbt models and automated data quality tests.
• Support migration of legacy on‑premise processes to cloud.
• Manage the data lifecycle from ingestion to downstream outputs.
• Implement data governance, lineage and quality controls.
• Optimize Snowflake compute, warehouses and storage.
• Work with developers, testers and offshore teams in an Agile/Scrum environment.
• Support Aladdin use cases and wider data platform development.

Skills

SQL

Python

Data Engineering

Cloud data architectures

Data governance

Data lineage

Agile/Scrum

Data pipelines

Tools

Snowflake

dbt

Aladdin

Job description

Job Title:Data Engineer - Snowflake&DBT
Location: London (3 days in office)
Salary/Rate: £600-700 per day inside IR35
Start Date: End of September
Job Type: Initial 3-4 month contract (possibility of extension)

Company Introduction
We have an exciting opportunity now available with one of our sector-leading consultancy clients! They are currently looking for a skilled Data Engineer with Snowflake & DBT Specialist to join the data engineering team of a global asset manager, supporting Aladdin use-case development and the modernisation of legacy data processes.

Job Responsibilities/Objectives
The role will focus on building scalable, cloud-native data solutions using Snowflake and dbt, alongside broader data engineering and platform optimisation.

• Develop and maintain data pipelines and transformations using Snowflake, dbt, SQL and Python.
• Build modular, version-controlled dbt models and automated data quality tests.
• Support migration of legacy/on-premise processes to cloud-native architectures.
• Manage the data lifecycle from ingestion through to downstream outputs.
• Implement data governance, lineage and quality controls.
• Optimise Snowflake compute, warehouses and storage for performance and cost.
• Work with developers, testers and offshore teams in an Agile/Scrum environment.
• Support Aladdin use cases and wider data platform development.

Required Skills/Experience
The ideal candidate will have the following:

• Strong Data Engineering background.
• Extensive hands‑on experience with Snowflake and dbt.
• Aladdin experience is a very nice to have
• Strong SQL and Python skills.
• Experience building data pipelines and modern cloud data architectures.
• Experience with data quality, governance and lineage.
• Experience modernising or migrating legacy data processes.

Desirable Skills/Experience
Although not essential, the following skills are desired by the client:

• Asset / investment management or financial services experience.
• Aladdin experience.
• Databricks experience.Working knowledge of Informatica.
• Experience with cloud migration and Modern Data Stack environments.

Disclaimer

Notwithstanding any guidelines given to level of experience sought, we will consider candidates from outside this range if they can demonstrate the necessary competencies.

Square One embraces diversity and will treat everyone equally.

Please see our website for our full diversity statement.