[Hiring] Snowflake Developer @Medavie

Role Description

As a Medavie Snowflake Developer, you will work with architects, application developers, project stakeholders, and business partners to develop data engineering and data deliverables. You will be responsible for designing, building, and maintaining data pipelines and architectures within the Snowflake Cloud Data Platform.

Your everyday tasks will include:

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

Qualifications

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

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 coordinate simple to complex projects and activities with team members and any stakeholders both internal to Medavie Blue Cross and external clients.

Benefits

• Permanent full-time position with opportunity to grow in a well-established organization.
• Flexible work arrangements and emphasis on work-life balance.
• 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 which recognizes your contribution to our success.
• In addition to paid vacation, we offer a gifted week of vacation in your first year and an optional Vacation Purchase Program.
• An organization where we encourage personal learning and growth with opportunities for career development and advancement.
• Providing wellness benefits, health resources, and fitness center discounts.