Snowflake Architect

London (Hybrid - 2-3 days per week)

£400 per day (Inside IR35)(open to negotiation depending on experience)

We are looking for an experienced Snowflake Architect to join a major enterprise data transformation programme. This role will be instrumental in designing and delivering modern cloud-native data platforms, driving best practice across architecture, data engineering, and stakeholder engagement.

Working within a collaborative Agile environment, you'll help shape enterprise-wide data solutions, leveraging Snowflake, dbt, and cloud technologies to deliver scalable, high-performance platforms that support critical business and reporting requirements.

Key Responsibilities

Design and architect enterprise-scale data platforms using Snowflake.

Define modern data architecture, modelling standards, and best practices.

Lead the implementation of scalable cloud-native data solutions on AWS or Azure.

Design and optimise ELT/ETL pipelines using dbt and modern data ingestion tools.

Develop enterprise data models supporting analytics and reporting.

Provide technical leadership and guidance to Data Engineering teams.

Engage with business and technology stakeholders to translate requirements into scalable technical solutions.

Drive architecture standards, DevOps practices, automation, and CI/CD adoption.

Support large-scale enterprise data transformation initiatives.

Essential Skills

Extensive experience designing Snowflake data platforms and architecture.

Strong hands-on experience with dbt (Cloud or Core).

Experience with data ingestion technologies such as Fivetran, HVR, or similar.

Advanced SQL and strong data modelling expertise.

Strong understanding of Data Vault, Kimball methodology, and Lakehouse architecture.

Experience designing cloud-native data platforms on AWS and/or Azure.

Strong architecture, solution design, and technical leadership experience.

Excellent stakeholder management and communication skills.

Experience working within Agile, DevOps, and CI/CD environments.

Desirable

Experience within Financial Services, Banking, or Insurance.

Knowledge of financial data models, P&L, regulatory reporting, and enterprise reporting datasets.

Experience delivering enterprise-scale data transformation programmes.

If you're a Snowflake Architect with a passion for designing modern cloud data platforms and delivering enterprise-scale transformation, we'd love to hear from you.