Business Intelligence Analyst

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.

The opportunity

As a Business Intelligence Analyst, you'll be at the heart of our data-driven decision-making. You’ll use your expertise in Microsoft BI tools and Advanced SQL to build and deliver impactful reports and dashboards that help both internal and external teams make smarter choices.

You’ll collaborate closely with business and IT partners, turning complex data into clear, actionable insights. Whether you're working in Power BI, Excel or writing advanced SQL queries, your work will help shape the way we understand and act on our data.

What You’ll Do:

Deliver reports, data sets, and dashboards solutions to Medavie’s internal and external partners through proficient using Advanced SQL and Microsoft BI tools (Microsoft Report Builder, Power BI, Excel, etc.)

Collaborate with Sales, Product, Actuarial, and Underwriting teams to meet reporting needs

Ensure compliance with privacy regulations in all deliverables

Identify opportunities for process optimization and efficiency

Support recurring and scheduled reporting for large clients

Who You’ll Work With:

• Daily collaboration with internal teams (Sales, Product, Actuarial, Underwriting)
• Monthly reporting to Sales leadership
• Periodic reporting for large external clients
• What You Bring:
• Bachelor’s degree in business, Statistics, Mathematics, Computer Science, Economics, or related field
• 2–4 years of experience with BI tools and data reporting
• Strong skills in Advanced SQL, Excel, DAX, Power Query M, and data visualization
• Excellent analytical thinking and communication skills
• Bilingualism will be considered as a great asset

What We Offer:

• Flexible work arrangements and an emphasis on work-life balance
• Comprehensive health, vision, and dental coverage
• A 100% employer-matched defined contribution pension plan
• Annual incentive bonus that recognizes your contribution to our success
• Paid vacation and the opportunity to purchase additional vacation time
• Opportunities for learning, career development, and growth within Medavie

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

Pay Range:

61 221 - 68 873 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.

While Medavie may use automated tools, including AI, to support application screening, candidates are expected to complete all recruitment interactions independently—without AI assistance—to ensure a fair and equitable process.

If you experience any technical issues throughout the application process, please email: [email protected].