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.

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

#CBM1

#LI-VS1

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.

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