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 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
Senior DBA contract in Toronto, onsite. Requires 10+ years Oracle DBA experience, CRJMC security clearance, and expertise in Oracle 12c/19c, RAC, Data Guard, and cloud.
Manufacturing Engineering Support role at Expleo developing solutions for aircraft components and optimizing processes. Collaborating with engineering teams on assembly and manufacturing strategies.
Manufacturing Engineering Support providing innovative solutions to improve processes at Expleo. Collaborating on complex projects within the aerospace sector in a hybrid role.
Experienced Executive Assistant needed to support senior banking executives with calendar management, meeting coordination, and confidential correspondence.
Multiple openings across Canada for SIEM Architect, Java Developer, Data Analyst, AI Developer, and Test Analyst roles. Requires 6+ years experience and valid Canadian work authorization.