Data Analyst - Finance

About the job

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.

Position Summary The Data Analyst, Finance plays a critical role in transforming raw financial and operational data into trusted, analytics-ready datasets for end users across Finance and the business. This role combines strong technical skills in data transformation and ETL processes with a solid understanding of financial accounting, financial reporting, and financial planning & analysis (FP&A). Working closely with Finance, IT, and Analytics teams, this role ensures that data flowing through the enterprise data platform (i.e. Snowflake) for finance users and stakeholders is accurate, well-structured, well-documented, and aligned to financial concepts and reporting requirements. The role is essential in enabling self-service reporting, management insights, and enterprise decision-making.

Key Responsibilities

• Data Cleansing and Transformation: Design and manage data structures within the data platform environment (i.e. Snowflake). Implement rigorous cleaning protocols within Snowflake to resolve data discrepancies and ensure the accuracy of financial or operational datasets. Transform data to be reporting ready for use with external tools like Power Query for access to "single source of truth."
• Data Governance & Quality: Assist in supporting data governance practices for finance data. This includes maintaining thorough documentation of data definitions and lineage, enforcing data quality controls and reconciliation checks, and ensuring proper data security and compliance with financial reporting standards.
• Data & Business Analysis: Translate Finance and FP&A reporting needs into reliable data solutions by performing exploratory analysis, defining data requirements, validating data through UAT, and data analysis to identify gaps, ensure data quality, and continuously improve reporting and data processes.

Required Qualifications

Education: College diploma or Bachelor’s degree in Business or Data Analytics, Finance, Accounting, Computer Science, or a related field (or equivalent experience).

Work Experience: 3+ years of experience in financial analytics, data analysis, or a role supporting finance or corporate reporting. (Asset: experience supporting ERP implementations or finance transformation initiatives; experience in the healthcare, insurance, or financial services sector.)

Computer Skills: Proficiency with data analysis using cloud-based data platforms (e.g., Snowflake, Azure), visualization/transformation tools (e.g., Advanced Excel, Power Query/BI, Python), and ability to learn new data technologies or programming languages, e.g. Python/SQL.

Other Qualifications: SnowPro Certified, Certified Analytics Professional (CAP); Microsoft Certified Data Analyst Associate (Power BI); and/or a professional designation or progress toward one, such as CPA or CFA.

Language Skills: English, written and spoken. French would be considered an asset.

Core Competencies

• Demonstrates strong capability in cleansing, transforming, and governing financial and operational data to ensure accuracy, consistency, and usability. Effectively translates Finance and FP&A requirements into reporting‑ready datasets through sound data modeling, exploratory analysis, quality assurance, and continuous improvement, enabling trusted insights and a single source of truth.
• Strong business acumen, including knowledge in financial accounting, reporting, and FP&A processes, with the ability to translate technical data into meaningful business insights.
• Communicates clearly with all audiences, tailoring messages as needed, and delivers technical findings in accessible formats.
• Takes initiative, proactively tracks down information, addresses issues promptly, and recommends mitigation strategies, even in ambiguous situations.
• Demonstrates strong analytical skills—independently interpreting information, identifying relationships, and sharing actionable conclusions.
• Quick learner with curiosity, able to grasp new concepts efficiently.
• Excellent time management—organizes priorities, adapts timelines, and acts with urgency.
• Builds strong relationships, fosters collaboration, and adapts to diverse working styles and stakeholder needs.
• Excellent communication and presentation skills for conveying technical findings to non-technical stakeholders. Ability to bridge technical data concepts with financial language and business context.

What’s in it for you?

What makes us a different kind of employer? Our award-winning culture, a team who really cares, unmatched training and support are all dedicated to ensuring you are set up for success.

What We Offer

• Permanent full-time position with strong career growth opportunities.
• Hybrid or remote work arrangements.
• Flexible work environment and work-life balance.
• 100% employer-paid health, dental, and vision benefits (effective Day 1).
• 100% employer-matched Defined Contribution Pension Plan.
• Annual performance-based Incentive Bonus.
• A gifted week of vacation in your first year + optional Vacation Purchase Program.
• Support for professional development, training, and certifications.
• Wellness programs, health resources, and fitness discounts.

#CBM1

This posting is for an existing vacancy within our organization / Ce poste est actuellement vacant au sein de notre organisation.

Pay Range

73,465 - 82,648 CAD

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.