Snowflake Developer

🕒 3 days ago

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Medavie

WebsiteLinkedInAll Job Openings

5001 - 10000 employees

⚕️ Healthcare Insurance

🧘 Wellness

Healthcare Insurance • Community Health • Wellness

Medavie is a national health solutions partner dedicated to improving the wellbeing of all Canadians. It integrates benefits management, healthcare delivery, and advanced health solutions, aiming to transform healthcare in Canada with innovative approaches. Medavie also focuses on community health through its foundation, promoting initiatives for accessible and equitable healthcare services.

📋 Description

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

🏖️ Benefits

• Comprehensive health and dental plan that is 100% employer paid effective on your first day • Flexible work arrangements and emphasis on work-life balance • 100% employer-matched Defined Contribution Pension Plan • Annual Incentive Bonus which recognizes your contribution to our success • Paid vacation and an optional Vacation Purchase Program • Opportunities for career development and advancement • Providing wellness benefits, health resources and fitness center discounts