Senior Analyst, Business Intelligence

Shoppers Drug Mart; Mississauga; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading pharmacy chain in Mississauga is seeking a Senior Analyst to analyze patient assistance program data, provide insights on trends, and facilitate reporting for internal and external clients. The ideal candidate has a degree in Business or related, strong SQL skills, and 3-7 years of experience in the pharmaceutical industry. Join our team to contribute to innovation in health and wellness while enjoying competitive pay and benefits.

Benefits

Competitive pay

Purchase discount program

Online learning opportunities

Qualifications

• A minimum of 3-7 years' experience preferably in a pharmaceutical industry.
• Must manage time effectively through flexibility and prioritization.
• Enjoy working in a fast-paced environment.

Responsibilities

• Act as a conduit between Client, SHN Sales & Marketing, and Business Intelligence.
• Develop, run, validate and review reports, monitor operational excellence.
• Assess impact on reports due to process changes and improvements.

Skills

Strong knowledge and understanding of SQL

Effective organizational skills

Communication skills

Customer relations skills

Analytical skills

Problem-solving skills

Familiarity with CRM platforms

Exceptional computer skills

Experience with Business Intelligence Platforms

Education

Business/Computer Science/Engineering Degree or equivalent experience

Tools

MS Excel

SalesForce

Tableau

PowerBI

Job description

Location

1685 Tech Ave, Mississauga, Ontario, L4W 0A7

At Shoppers Drug Mart, we’re innovating health and wellness in Canada. From prescriptions to walk‑in clinics, and a beloved loyalty program, we’re caring and supporting our customers in new ways every day.

With more than 1,300 locally owned and operated stores from coast to coast, the Shoppers Drug Mart network is more than a great place to shop, it’s a great place to work. We’re committed to building our talented team who champion collaboration, kindness and inclusivity. Join our team, and help recognize a healthy future for your career and for all Canadians.

Why this role is important?

The Senior Analyst, Reporting position’s primary responsibility will be to help extract & analyze all patient assistance program data within core therapeutic areas and provide value add insight into trends, opportunities, performance to targets and benchmarks for programs and recommendations on efficiencies. The Senior Analyst’s role is to assist the business users in getting raw data out of the system to turn into something meaningful for stakeholders. They will also act as a liaison for communication between the business end users and the developers.

The incumbent will work with internal staff to develop and maintain comprehensive reporting for SDM Specialty Health Network Management and external clients.

What you will do:

• Act as a conduit between Client, SHN Sales & Marketing and Business Intelligence department to clarify and translate business and or operational requirements into documentation and conceptual report designs
• Recommend and facilitate development of reports (regular & ad‑hoc)
• Develop, run, validate and review reports, analyze trends, monitor and maximize operational excellence, and summarize analyses for report end users which includes internal employees and clients
• Deliver said analysis & reports in the most effective way possible for the audience
• Develop financial analysis and reports designed to maximize profitability
• Develop supporting invoice data and queries
• Maintain business requirements, functional requirements and technical specification documentation for all reports
• Participate in audits on behalf of the Business Intelligence department
• Participate in Request for Proposal processes related to specific therapeutic area of expertise
• Assess impact to reports due to process changes and improvements
• Report all Adverse Events (AE) and Product Technical Complaints (PTC) immediately or as soon as possible upon becoming aware of the event as per current policies and procedure

What you will need:

• Business/Computer Science/Engineering Degree or equivalent working experience
• A minimum of 3-7 years’ experience preferably in a pharmaceutical industry
• Strong knowledge and understanding of SQL is a key skill
• Effective organizational, communication and customer relations skills
• Well‑developed analytical and problem‑solving skills
• Familiarity with CRM platforms (SalesForce)
• Exceptional computer skills (MS Excel and quantitative & statistical analysis tools)
• Experience with Business Intelligence Platforms (i.e. Tableau, PowerBI, etc.)
• Must be able manage time effectively through flexibility & prioritization
• Must enjoy working in an environment of fast paced change and ambiguity

Why work at Shoppers Drug Mart?

Acting as consultants, supporting internal customers and the Associate‑Owners, you will get experience unique to the retail industry while working for an award‑winning national brand. Benefit from a purchase discount program, competitive pay and online learning through Academy.

Take ownership of your work and find more ways to care about your work, co‑workers, customers and community.

How You’ll Succeed:

At Shoppers Drug Mart Inc., we seek great people to continually strengthen our culture. We believe great people model our values, are authentic, build trust and make connections.

If that sounds like you, and you are open‑minded, responsive to change and up to the challenges provided in a fast‑paced retail environment, apply today.

Employment Type:

Full time

Type of Role:

Regular

Shoppers Drug Mart Inc. recognizes Canada’s diversity as a source of national pride and strength. We have made it a priority to reflect our nation’s evolving diversity in the products we sell, the people we hire, and the culture we create in our organization. Accommodation is available upon request for applicants with disabilities in the recruitment and assessment process and when hired.

In addition, we believe that compliance with laws is about doing the right thing. Upholding the law is part of our Code of Conduct – it reinforces what our customers and stakeholders expect of us.

Please note: If you have Employee Self Service (ESS) on Workday, apply to this job via the Workday application.