Snowflake Developer - Prophecy Technologies (Laval)

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,...