Snowflake Cloud Data Lakehouse Lead Engineer

RBC; Mississauga; On-site; CAD 120,000 - 160,000; Full time

Benefits offered by this job

Total rewards program with bonuses and

Stock options where applicable

Leadership development opportunities

Dynamic, collaborative team

World-class training program

Job summary

RBC invites applications for a senior data engineering leadership role focused on building and operating a Snowflake-based data lakehouse platform. You will lead a team of data engineers, work with business stakeholders, and drive architectural decisions to enable scalable, secure data pipelines across Snowflake, Python/Snowpark, and related tools.

The role emphasizes collaboration, performance tuning, and data quality across the lifecycle.

Qualifications

• 5+ years of experience in data engineering with a focus on Snowflake Cloud Data Lakehouse Platform.
• Deep, hands-on experience with Snowflake architecture, SQL, SnowSQL, Tasks, Streams, Stages, and performance tuning.
• Strong proficiency in Python, with Pandas; Snowpark experience is a major plus.
• Solid understanding of cloud concepts on Snowflake, AWS, Azure, or GCP, especially storage and security.
• Proven experience in leading and managing high-performing teams.
• Excellent communication and interpersonal skills with stakeholders.
• Experience on multiple projects with high impact and risk and complex requirements.

Responsibilities

• Technical Leadership: design, develop and implement data strategies aligned with business objectives.
• Business Stakeholder Management: communicate technical concepts to stakeholders and provide solutions.
• Data Engineering: design and maintain large-scale data warehouses and pipelines on Snowflake.
• Lead the design of scalable ingestion, transformation pipelines using dbt, Python/Snowpark and Snowflake features.
• Monitor and optimize Snowflake workloads, including warehouses sizing, clustering and micro-partitioning.
• Collaborate with Data Architect to implement data quality frameworks.
• Contribute to Medallion data model architecture (bronze-silver-gold).
• Manage deployment of Snowflake objects and lead SRE setup for production.

Skills

Snowflake

Python

Snowpark

Cloud platforms

Data engineering leadership

Data warehousing

SQL

Stakeholder communication

DevOps

Big data

Tools

dbt

Snowflake

Job description

RBC invites applications for a senior data engineering leadership role focused on building and operating a Snowflake-based data lakehouse platform. You will lead a team of data engineers, work with business stakeholders, and drive architectural decisions to enable scalable, secure data pipelines across Snowflake, Python/Snowpark, and related tools.

The role emphasizes collaboration, performance tuning, and data quality across the lifecycle.