Referred applicants must not apply directly to this role. All referred applicants must use their unique referral link generated when they are referred by an existing colleague.

Location:
243 Consumers Road, Toronto, Ontario, M2J 4W8
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?

Nature and Scope:
Business Intelligence Analyst is responsible for analytical support and reporting for Pharmacy projects and day-to-day activities and driving operating leverage and supporting data driven decision making. This position is reporting to Director, Operational Intelligence and System Development.

What you will do:

• Develop, maintain and distribute reports to internal stakeholders and the field periodically to support day to day operations of Pharmacy projects at all sites
• Develop exception reports to determine potential stop gaps and issues to support day to day operations in all Pharmacy projects sites
• Develop dashboards for daily, weekly, and period end KPI reporting packages using Power BI as the distribution mechanism
• Develop and adhere to the end-to-end Pharmacy project process that includes reporting by each program, program performance, analysis of pain points and growth opportunities
• Liaise with Accounting, IT, and other relevant departments to streamline procedures at the Pharmacy project level
• Enhance planning process including CYP, MYP, monthly re-forecasting of the Pharmacy project programs, and other metrics as required
• Monitor and maximize each of the site’s portfolio
• Provide analytical support for all sites using vendor data, Micro Strategy and/or Teradata
• Maintain and support the Labour Planning tool processes and metrics, Capacity Planning tool processes and metrics, and Period End processes (MBR)

What you will need:

• University degree with focus on Computer Science, Statistics, Engineering and/or Finance
• Business acumen and superior knowledge of Retail pharmacy operations, Inventory Management and CPAK/Central Vial operations
• Ability to develop and manage exception reports from multiple data sources
• Ability to communicate effectively leveraging data, statistics, market research, scientific studies, and other relevant information to influence individuals from a variety of educational backgrounds, seniority, and experience
• Excellent analytical skills: ability to rapidly assess relevance, accuracy, and statistical significance
• Experience in creating and defending business cases for large, complex multi-year projects
• Experience managing sensitive programs in highly regulated environments
• Strong MS Excel, Access, Power Point, SQL Server Management Studio, Power BI, Power Apps, Citrix Server Applications, VBA, Python, Micro Strategy and Teradata
• Demonstrated problem solving skills
• Demonstrated ability to drive to clear action and ownership
• Exceptional project and time management skills
• Understanding of pharmaceutical/health care industry a strong asset
• Ability to thrive in a fast-paced environment

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.