Snowflake Developer

External

Medaviehs · Ns, Canada

ContractRemote3w ago

CompliancedbtDocumentationEncryptionETLLeadership

Cover Letter Connect

Prepare for this interview

Elite

AI-generated questions, company research, and talking points tailored to this role

About the role

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 to design, build, and maintain data pipelines and architectures within the Snowflake Cloud Data Platform. What's in it for you? What makes us a different kind of employer? In this role, we develop cutting edge Digital Health solutions for our members, partners, advisors, health care providers and group administrators. We are an in-house, innovation led, IT shop that is 500+ strong and growing! Whether you are just starting your career as a new grad or you are an experienced developer, we have challenging and rewarding roles and we are looking for top talent. Common goals and collaboration to deliver outstanding service is what our team is all about, we offer: A diverse team of colleagues with multiple fields of expertise A stimulating and flexible working environment 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 An organization where we encourage personal learning, growth and giving back to our communities

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 advancementProviding wellness benefits, health resources and fitness center discounts.Your every day with us consists of: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.What you need to be succeed: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 capabilitHealth insuranceDental insuranceVision insurancePaid time offRemote work optionsFlexible schedulePerformance bonus

Additional Information

Position Type: Permanent If you're looking for a fulfilling career that can make a real difference in your life, and the lives of others, you've come to the right place. As a national health solutions partner, we put people first in everything we do - and that begins with our team of 8,000+ professionals who bring a cross-section of diverse life experiences and career expertise to Medavie. By collaborating and innovating together, our employees are creating industry-leading solutions in insurance, primary care and emergency medical services that impact millions of lives in Canada each year. Our mission is to improve the wellbeing of Canadians so that every life can be lived to the fullest - and it's reflected in our award-winning culture. We celebrate individuality and value the diverse perspectives and skills our employees contribute. We go 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 where employees can be their best selves, feel they belong, and achieve their full potential. Be part of it by applying for a position with us today.

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at medaviehs? Share your experience

Interested in this role?

Apply on the company's website.

Cover Letter Connect