Senior Snowflake Architect — AI-Ready Data Cloud

FalconSmartIT; City of Edinburgh; Hybrid; GBP 90,000 - 130,000; Full time

Job summary

FalconSmartIT in Edinburgh is seeking a Sr. Snowflake Architect to lead the enterprise data strategy, target-state blueprints, and modernization programs on the Snowflake AI Data Cloud. You will govern modeling standards and cross-platform migrations with hands-on Snowflake expertise.

The role requires deep data modeling, ELT/ETL orchestration, and security-by-design governance, with a focus on AI-ready architectures and scalable data foundations. Hybrid work with two days on site is offered.

Qualifications

• 20+ years in data architecture and engineering with leadership roles.
• 5+ years delivering enterprise Snowflake architecture.
• Experience migrating from Teradata/Oracle/SQL Server to Snowflake.
• Strong SQL and Python, plus CI/CD and IaC.

Responsibilities

• Define enterprise data strategy and target-state blueprints on Snowflake AI Data Cloud.
• Lead modernization and migration programs across data platforms.
• Establish data modeling standards and semantic layers.
• Mentor engineers and ensure governance alignment.

Skills

Snowflake architecture

Data modeling

ELT/ETL orchestration

dbt

Airflow

Cloud platforms

Security governance

SQL

CI/CD / IaC

Stakeholder management

Tools

Snowpipe

Dynamic Tables

Streams

Tasks

dbt

Airflow

Azure Data Factory

Informatica

Terraform

Job description

FalconSmartIT in Edinburgh is seeking a Sr. Snowflake Architect to lead the enterprise data strategy, target-state blueprints, and modernization programs on the Snowflake AI Data Cloud. You will govern modeling standards and cross-platform migrations with hands-on Snowflake expertise.

The role requires deep data modeling, ELT/ETL orchestration, and security-by-design governance, with a focus on AI-ready architectures and scalable data foundations. Hybrid work with two days on site is offered.