🌿 Back to all jobs

🥝 Snowflake Developer (Montreal)

Prophecy Technologies | montreal (administrative region), Canada | Posted June 01, 2026

Job Description

We are seeking a Snowflake Developer to design, develop, and optimize cloud-based data warehousing solutions. The ideal candidate will have deep expertise in Snowflake architecture, SQL, data modeling, and ETL/ELT pipelines. You will work closely with data architects, analytics teams, and business stakeholders to deliver scalable, high-performance data solutions supporting investment banking, wealth management, and risk analytics.

Snowflake Development

  • Design, develop, and optimize Snowflake data warehouses, including data modeling (Star, Snowflake, Data Vault), clustering, and partitioning strategies.
  • Write and optimize complex SQL queries (window functions, CTEs, analytical functions) for high-performance data processing.
  • Implement Snowflake features such as Time Travel, Zero-Copy Cloning, Streams, Tasks, External Stages, and Snowpipe for real-time/near-real-time ingestion.
  • Optimize query performance using Query Profiles, Caching,...

Apply for This Position

Submit Application