Job Description

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 4W8At Shoppers Drug Mart, we\xe2\x80\x99re innovating health and wellness in Canada. From prescriptions to walk-in clinics, and a beloved loyalty program, we\xe2\x80\x99re 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\xe2\x80\x99s a great place to work. We\xe2\x80\x99re 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:\xc2\xb7 Develop, maintain and distribute reports to internal stakeholders and the field periodically to support day to day operations of Pharmacy projects at all sites\xc2\xb7 Develop exception reports to determine potential stop gaps and issues to support day to day operations in all Pharmacy projects sites\xc2\xb7 Develop dashboards for daily, weekly, and period end KPI reporting packages using Power BI as the distribution mechanism\xc2\xb7 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\xc2\xb7 Liaise with Accounting, IT, and other relevant departments to streamline procedures at the Pharmacy project level\xc2\xb7 Enhance planning process including CYP, MYP, monthly re-forecasting of the Pharmacy project programs, and other metrics as required\xc2\xb7 Monitor and maximize each of the site\xe2\x80\x99s portfolio\xc2\xb7 Provide analytical support for all sites using vendor data, MicroStrategy and/or Teradata\xc2\xb7 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:\xc2\xb7 University degree with focus on Computer Science, Statistics, Engineering and/or Finance\xc2\xb7 Business acumen and superior knowledge of Retail pharmacy operations, Inventory Management and CPAK/Central Vial operations\xc2\xb7 Ability to develop and manage exception reports from multiple data sources\xc2\xb7 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\xc2\xb7 Excellent analytical skills: ability to rapidly assess relevance, accuracy, and statistical significance\xc2\xb7 Experience in creating and defending business cases for large, complex multi-year projects\xc2\xb7 Experience managing sensitive programs in highly regulated environments\xc2\xb7 Strong MS Excel, Access, PowerPoint, SQL Server Management Studio, Power BI, Power Apps, Citrix Server Applications, VBA, Python, MicroStrategy and Teradata\xc2\xb7 Demonstrated problem solving skills\xc2\xb7 Demonstrated ability to drive to clear action and ownership\xc2\xb7 Exceptional project and time management skills\xc2\xb7 Understanding of pharmaceutical/health care industry a strong asset\xc2\xb7 Ability to thrive in a fast-paced environmentWhy 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\xe2\x80\x99ll 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 timeType of Role: RegularShoppers 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\xe2\x80\x99s 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 \xe2\x80\x93 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.

Shoppers Drug Mart