Snowflake Lead Consultant

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

Job Location: London, UK/ Hybrid( 4 days office)

Job Type: FTE

Experience: 8–12 years overall, with 5+ years of hands-on Snowflake experience

Job Description:

We are looking for an experienced Snowflake Lead Consultant to lead cloud data warehousing, data migration, and data engineering initiatives.

Key Responsibilities

• Lead Snowflake architecture, implementation, and migration projects.
• Design scalable data models and optimise 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.

Required Skills

• 5+ years of hands-on experience with Snowflake.
• Strong expertise in SQL, data modelling, and data warehousing.
• Experience with ETL/ELT tools and cloud platforms (AWS, Azure, or GCP).
• Proven experience leading technical teams and managing stakeholders.