Snowflake Developer

Posted yesterday

Apply Now

Resume Score

Check how well your resume matches this job before you apply.

Sign in to check score

About the role

  • Snowflake Developer working on data engineering and deliverables at Medavie. Collaborating to design, build, and maintain data pipelines and architectures within the Snowflake Cloud Data Platform.

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

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

Benefits

  • Comprehensive health and dental plan that is 100% employer paid effective on your first day
  • Emphasis on work life balance, providing wellness benefits, health resources and fitness center discounts
  • 100% employer-matched Defined Contribution Pension Plan
  • Annual Incentive Bonus which recognizes your contribution to our success
  • Gifted week of vacation in your first year and optional Vacation Purchase Program

Job type

Full Time

Experience level

Mid levelSenior

Salary

CA$88,158 - CA$110,197 per year

Degree requirement

Bachelor's Degree

Tech skills

AzureCloudETLPythonScalaSDLCSQL

Location requirements

RemoteCanada

Report this job

Found something wrong with the page? Please let us know by submitting a report below.