Snowflake Lead Consultant - Data Warehouse & Migration

Falcon Smart IT (FalconSmartIT); St Albans; Hybrid; GBP 90,000 - 120,000; Full time

Job summary

Falcon Smart IT (FalconSmartIT) in London is seeking an experienced Snowflake Lead Consultant to drive cloud data warehousing, data migration, and data engineering initiatives across our client projects.

You will oversee Snowflake architecture, optimize data models, and lead ETL/ELT pipelines while mentoring our data engineering teams and partnering with stakeholders to deliver scalable, high-performance data solutions.

Qualifications

• 8+ years in data and analytics with 5+ years hands-on Snowflake experience.
• Strong SQL, data modelling and warehousing expertise.
• Experience with ETL/ELT tools and cloud platforms (AWS/Azure/GCP).
• Proven ability to lead technical teams and manage stakeholders.

Responsibilities

• Lead Snowflake architecture, implementation, and migration projects.
• Design scalable data models and optimize SQL queries and warehouse performance.
• Develop and manage ETL/ELT pipelines and data integration solutions.
• Provide technical leadership and mentor data engineering teams.
• Collaborate with business stakeholders to deliver effective data solutions.

Skills

SQL

Data modelling

Data warehousing

ETL/ELT

Cloud platforms (AWS/Azure/GCP)

Team leadership

Tools

Snowflake

Job description

Falcon Smart IT (FalconSmartIT) in London is seeking an experienced Snowflake Lead Consultant to drive cloud data warehousing, data migration, and data engineering initiatives across our client projects.

You will oversee Snowflake architecture, optimize data models, and lead ETL/ELT pipelines while mentoring our data engineering teams and partnering with stakeholders to deliver scalable, high-performance data solutions.