Position Type:
PermanentIf 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.
The Opportunity
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
What we offer:
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.
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 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
Qualifications
Education: University degree or college diploma in Computer Science or similar program
Work Experience: 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.
Security Clearance Requirement: In conjunction with our contract with the Federal Government, you will be required to have Reliability Status Clearance (Enhanced Level B). This includes Fingerprinting, Criminal Record Check, Credit Check and you must have resided in Canada for at least 5 years and hold Permanent Resident or Citizenship Status.
Skills
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).
Experience building data models for Power BI or similar BI tools, including awareness of DirectQuery vs. Import mode considerations.
Ability to explain Snowflake concepts clearly to business analysts or functional staff with limited data engineering background.
Familiarity with CI/CD for Snowflake (e.g., SchemaChange, dbt CI) is advantageous.
Pay Range: $88,158 - $110,197 CAD
#CBM2
#LI-VS1
This posting is for a newly created position within our organization.The Base Pay range may vary depending on the successful candidate or other relevant job-related factors such as knowledge, skills, qualifications, experience and education/training. In addition to Base Pay, eligible Medavie employees may participate in various performance-based incentive programs. Payments under these programs are discretionary and subject to both individual and organizational results.
We believe our employees should reflect the communities we serve and welcome applications from candidates of all backgrounds. To provide the best experience possible, we will support you with accommodations or adjustments at any stage of the recruitment process. Simply inform our Recruitment team of your needs. We are committed to making sure recruitment, retention, advancement, and compensation are fair and accessible while following all relevant human rights and privacy laws. We appreciate everyone who has shown interest in this position. Only those selected for an interview will be contacted.
Our recruitment process may involve automated tools, including AI, to assist in screening applications.
If you experience any technical issues throughout the application process, please email: Medavie.Recruitment@medavie.ca.
We are committed to hiring military and Veteran spouses and encourage you to identify your connection with the MSEN when reaching out to us or applying to any of our open roles.
Have questions or want to learn more about us? We would love to hear from you!
Whenever possible, reach out to a named contact rather than a general inbox - it helps ensure a quicker, more personalized response. If you hit a bounce-back, let us know at
Who we are
We’re a team of over 8,000 professionals serving clients from coast-to-coast with operations in most provinces. We provide health benefits to nearly 1 in 10 Canadians and manage emergency medical services for nearly 1 in 15 Canadians.
We’ve been a leading health services partner for individuals, employers and governments across Canada for 80 years and a premier all-in-one carrier that provides health, dental, travel, life and disability benefits to individuals and organizations.
We've been recognized as one of Canada's Most Admired Corporate Cultures, one of Canada's Top 100 Employers, and an Imagine Caring Company.
What we value
Our values are inherent to our culture and provide the framework for each interaction we have and transaction we make, while providing a clear set of expectations to empower employees to do the right thing for everyone we serve. We are:
Caring – We show compassion in everything we do
Accountable – We follow through on our commitments
Responsive – We have the courage to act and adapt
Innovative – We encourage and value new ideas
Community-minded – We achieve more together
More than simply a poster on the wall, our mission of improving the wellbeing of Canadians represents the purpose of our organization ― and we align that with our culture.
What we give back
As a not-for-profit organization, we don’t answer to shareholders. Instead, we invest our earnings in our business, our communities and, most importantly, our employees. We use some of these earnings to support:
Programs to support causes that are close to our employees' hearts, matching the volunteer hours and donations they contribute
An annual United Way workplace campaign led by employees in each of our locations
The Medavie Foundation, which invests in community initiatives and organizations that improve the wellbeing of Canadians, focuses on some of the most pressing mental and physical health challenges facing Canadians.
We want to meet you as you are
At Medavie Blue Cross, we foster a culture of openness, understanding and a sense of belonging where everyone can bring their true selves to work. Nearly 70% of our management roles are held by women and we’re committed to creating a diverse, equitable and inclusive workplace where everyone is valued for who they are and what they contribute. We will accommodate people with disabilities during the recruitment, selection and hiring processes.
What we offer
If you live our values and deliver results, you’ll experience meaningful, rewarding work in a purpose-centred, inclusive organization that provides:
Flexible work options: We want you to work where you work best. We offer work from home, from the office, or a hybrid of the two, while ensuring you feel connected to your team and to our purpose. Our flexibility goes beyond location. We also have flexible working hours and part-time options available.
Competitive compensation: We believe in rewarding our employees for the skills they bring to their jobs and the results they deliver. This includes competitive compensation that will reflect your experience and expertise and annual performance-based incentives, a 100% employer-matched defined contribution pension plan, an employee RRSP, one-on-one financial counselling, vacation and personal days to help you rest, refuel and balance your life.
Career Growth: Internal talent mobility and growth are an integral part of our success. Employees are empowered to own their career development and have rewarding experiences in a variety of work areas. Supportive leadership will encourage and coach you to maximize your potential so you can access multiple learning pathways to develop. Our leadership development program and other programs, such as mentoring, performance-based management and education assistance, are offered to provide employees with an environment of lifelong learning.
Outstanding benefits: Wellbeing is at the centre of everything we do and this starts with our employees. To help you take a proactive approach to your health, we provide: