Snowflake Developer

Medavie

18h•$88,158 - $110,197•Hybrid

About The Position

As a national health solutions partner, Medavie puts people first in everything they do. This includes their team of over 8,000 professionals who bring diverse life experiences and career expertise to the organization. By collaborating and innovating, employees are creating industry-leading solutions in insurance, primary care, and emergency medical services that impact millions of lives in Canada each year. Medavie's mission is to improve the wellbeing of Canadians so that every life can be lived to the fullest, which is reflected in their award-winning culture. They celebrate individuality and value the diverse perspectives and skills their employees contribute. Medavie goes beyond providing competitive pay and comprehensive benefits to offer opportunities for personal and professional growth, flexible work options, meaningful experiences, and supportive leadership. Medavie is a place where employees can be their best selves, feel they belong, and achieve their full potential. In this role, the Snowflake Developer will work with architects, application developers, project stakeholders, and business partners to develop data engineering and data deliverables. The developer will be responsible for designing, building, and maintaining data pipelines and architectures within the Snowflake Cloud Data Platform. This is a permanent, full-time position with opportunities for growth in a well-established organization.

Requirements

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 (Python/Scala).
Experience with monitoring and optimizing query performance and managing virtual warehouse usage to control costs.
Experience configuring data access controls, encryption, and ensuring compliance with security standards.
Experience managing data migration, cloning, and sharing capabilities within the Snowflake environment.
Experience gathering functional, non-functional, and transitional requirements
Experience working on systems integration and migration related projects
Able to translate and communicate complex business logic requirements
Experience designing software solution specifications
Experience supporting Project Management planning, providing estimates and reporting on progress, issues and risks
Able to manage multiple priorities and activities
Able to provide supervision, leadership, mentorship and coaching to assigned resources
Able to plan and co-ordinate simple to complex projects and activities with team members and any stakeholder both internal to Medavie Blue Cross and external clients
University degree or college diploma in Computer Science or similar program
Specializes in building high-performance data pipelines, ELT processes, and modeling data using Snowflake.
Strong SQL proficiency, Python skills, and experience with cloud platforms (AWS, Azure, or GCP) to design scalable data warehouses.
Reliability Status Clearance (Enhanced Level B). This includes Fingerprinting, Criminal Record Check, Credit Check and you must have resided in Canada for at least 5 years and hold Permanent Resident or Citizenship Status.
Strong Snowflake hands-on experience: data modelling, Snowpipe, Tasks, Streams, Dynamic Tables, RBAC, and query optimization.
Proficiency with dbt Core or dbt Cloud for transformation; experience writing and testing dbt models at scale.
Understanding of how Snowflake integrates with Azure (storage integration, Private Link, Entra ID).
Experience building data models for Power BI or similar BI tools, including awareness of DirectQuery vs. Import mode considerations.
Ability to explain Snowflake concepts clearly to business analysts or functional staff with limited data engineering background.

Nice To Haves

Familiarity with CI/CD for Snowflake (e.g., SchemaChange, dbt CI) is advantageous.

Responsibilities

Ingest Bronze data from ADLS Gen2 into Snowflake and build Silver-layer transformation pipelines: cleansing, deduplication, conforming, and applying agreed business rules.
Design and build Gold-layer data models optimised for Power BI consumption (star schema or as agreed with each business team).
Implement Snowflake objects including Stages, Snowpipe or scheduled Tasks, Streams, Dynamic Tables, and role/privilege structures for each business team’s workspace.
Develop dbt (or agreed transformation framework) models with appropriate testing, documentation, and lineage.
Collaborate with Power BI developers or business team members to validate semantic layer requirements and ensure Gold models support required reports and dashboards.
Work in a paired or shadowing model with business team data leads, building Snowflake capability so teams can maintain and extend pipelines independently.
Produce handover documentation and conduct structured knowledge-transfer sessions for each stream before contract conclusion.

Benefits

Comprehensive health and dental plan that is 100% employer paid effective on your first day
Wellness benefits
Health resources
Fitness center discounts
Flexible work arrangements
Remote and hybrid work options
Comprehensive health, vision and dental plan that is 100% employer paid effective on your first day
100% employer-matched Defined Contribution Pension Plan
Annual Incentive Bonus
Gifted week of vacation in your first year
Optional Vacation Purchase Program
Opportunities for career development and advancement