Snowflake Solutions Engineer

Richardson Wealth; Toronto; On-site; CAD 80,000 - 120,000; Full time

Job summary

Join a leading Canadian wealth management organization as a Snowflake Solutions Engineer, where you'll leverage your SQL expertise and Snowflake knowledge to design secure, high-performance solutions. In this role, you will ensure seamless integration with Azure and optimize SQL queries for efficiency. This innovative firm values its employees and is committed to fostering a culture of growth and collaboration. If you're a self-driven, client-centric professional eager to make an impact in a dynamic environment, this opportunity is for you!

Qualifications

• 4+ years of SQL development and 3+ years of Snowflake expertise required.
• Proficiency in SQL-driven pipeline design and Snowpark for UDFs.

Responsibilities

• Implement Snowflake security features and optimize SQL queries.
• Build SQL-based pipelines and collaborate on ETL/ELT workflows.

Skills

SQL Development

Snowflake Expertise

Performance Tuning

Azure Integration

Data Pipeline Design

Snowpark (Python)

Education

SnowPro Core Certification

SnowPro Advanced Architect Certification

Tools

Terraform

DBT

Azure Data Factory (ADF)

Job description

February 27, 2025

About Us:

As a leading Canadian wealth management organization, Richardson Wealth offers the personal touch of a boutique firm while delivering big results. With offices across the country, we are home to some of Canada’s best investment advisors. We’ve embarked on an exciting growth phase – a multi-year transformational journey to enhance our entrepreneurial, high-performing, advisor-centric culture.

Position Overview
As our Snowflake Solutions Engineer, you will be the technical authority for Snowflake, ensuring it integrates seamlessly with our Azure infrastructure and aligns with industry’s best practices. You will combine deep SQL expertise and mastery of the Snowflake platform to design secure, high-performance, and cost-effective solutions.

Duties and Responsibilities

1. Snowflake Security & Governance
   • Implement RBAC, dynamic data masking, and row-level security using advanced SQL (e.g., tag-based masking)
   • Design and optimize SQL queries for auditing access logs and compliance reporting
2. Performance & SQL Optimization
   • Tune complex SQL queries for Snowflake’s architecture (e.g., leveraging partition pruning, search optimization)
   • Design clustering keys and materialized views using SQL to optimize query performance
   • Profile slow-running queries and recommend SQL-level fixes (e.g., reducing joins, avoiding cartesian products)
3. Azure Integration & Pipeline Development
   • Build and optimize SQL-based pipelines (e.g., Snowpipe auto-ingestion, Streams/Tasks for CDC)
   • Collaborate on ETL/ELT workflows, writing efficient SQL transformations in tools like DBT
4. Platform Configuration
   • Use SQL to configure Snowflake objects (warehouses, resource monitors, databases) alongside IaC (Terraform)
   • Write stored procedures and UDFs in SQL (or Snowpark Python) for administrative tasks
5. Enablement & Standards
   • Define SQL best practices for Snowflake (e.g., CTEs vs. temp tables, window functions)
   • Train teams on Snowflake-specific SQL features (e.g., QUALIFY, PIVOT, time travel)

Qualifications
Must have:
• 4+ years of hands-on SQL development (complex queries, optimization, stored procedures)
• 3+ years of Snowflake expertise, including security (RBAC, masking), performance tuning, and Azure integration
• Proficiency in SQL-driven pipeline design (ETL, CDC, data sharing)
• Snowpark (Python) for advanced UDFs or stored procedures

Nice-to-Have:
• Hands-on experience with Snowflake Cortex AI/ML Integration (e.g., Cortex Analyst)
• Experience with IaC (Terraform) and DevOps practices for Snowflake
• Familiarity with DBT, ADF
• Wealth Management experience, or relevant work experience in a regulated industry

Education
• Certifications: SnowPro Core (required), SnowPro Advanced Architect (preferred)

Why Apply:

Our firm is only as good as the people who work here. Our employees are exceptional because they combine in-depth expertise with enthusiasm, and empathy. From our front office talent to our colleagues behind the scenes, we have one focus: to ensure our people thrive here more than anywhere else. Are you innovative, self-driven, and client-centric?

If so, we’re ready to invest in you.

Richardson Wealth is an equal opportunity employer and committed to providing a diverse, equitable and inclusive environment. We are happy to meet your individual needs in keeping with the Canadian Charter of Rights and Freedoms and the Accessibility for Ontarians with Disabilities Act. Candidates may request accommodation at any point during the interview process.

We are a proud partner of Pride at Work Canada.