Snowflake Developer (Fully Remote)

• Permanent full-time position with opportunity to grow in a well-established organization.
• Flexible work arrangements and emphasis on work-life balance.
• Comprehensive health, vision, and dental plan that is 100% employer paid effective on your first day.

Your every day with us consists of:

• Ingesting Bronze data from ADLS Gen2 into Snowflake and building Silver-layer transformation pipelines.
• Designing and building Gold-layer data models optimised for Power BI consumption.
• Implementing Snowflake objects including Stages, Snowpipe, Tasks, Streams, Dynamic Tables, and role/privilege structures.

What you need to succeed:

• A clear understanding of the software development life cycle (SDLC).
• Experience building ETL/ELT pipelines to move data into and within Snowflake using Snowpipe, Streams, and Tasks.
• Experience designing efficient schema structures and transforming raw data into usable formats for analytics using SQL or Snowpark.

Medavie

Medavie is a national health solutions partner that innovates in insurance, primary care, and emergency medical services, impacting millions of Canadians. With a team of over 8,000 professionals, Medavie fosters an award-winning, inclusive culture emphasizing flexibility, growth, and wellbeing.