Job Description

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?
Reporting to the Senior Manager, Analytics & Planning, this role is responsible for data systems and tools that support analysis, management and execution of the generic component of Shoppers Drug Mart's Pharmacy Procurement program. The scope of the role encompasses the following broad functions: SQL Server database development and optimization, advanced reporting (including Power BI and operational reports), decision support tools development, analytical modeling, and technical documentation.
Duties and Responsibilities
Program Data & Reporting
Identify key data requirements supporting pharmaceutical procurement store programs
o Generic Medicine Utilization Program
o Formulary Purchase Program
o Internal Asset Utilization Program
Develop views, scripts, and validation queries for these programs.
Within established cadences, ensure reports are distributed to each of the required levels.
Design comprehensive processes to track year-over-year performances, supporting suitable benchmarking and auditing activities.
Dashboard & Tool Design
Responsible for compelling dashboard and tool designing to support and understand the Canadian pharmaceutical market dynamics
o Market Intel
o Portfolio Managemen
o Rx Financial Plan Tracker
o Store Pharmaceutical Waste Mitigation Management Strategies
Identify Key Performance Metrics across all these projects and provide key data and reporting requirements to the System Developer.
Design Dynamic, Refreshable Dashboards (from executive-level to store-level, where applicable) to support key decision-making strategies.
Design Tools to Facilitate "What If" scenarios, support Cross Functional Impact analysis, and drive insights.
Database Management & Optimization
Maintain, monitor, and optimize the databases underpinning the store programs.
Ensure the accuracy, consistency, and reliability of critical data assets, including master data and product attributes.
Continuous Improvement & Stakeholder Engagement
Establish a feedback loop to ingest feedback from external sources.
Brainstorm improvements, optimization, and expansion opportunities for existing and/or new programs.
Work with Operations and leadership to ensure proper and timely communications are sent out.
Information Sharing & Platform Sustainability
Develop streamlined information sharing strategies to support 2-way dialogue.
Where possible, seek alternate tools and platforms to support sustainability and continuity.
Documentation
Ensure appropriate documentation is assembled and available for reference and for transitioning purposes.
QUALIFICATIONS
Requires a university degree in Business, Computer Science, Mathematics, Engineering, Science or similar.
3 - 5 years supply chain and analytical experience in the pharmaceutical or food industry with exposure to a broad array of analysis techniques
Expert level with Excel, Power BI, VBA, Access, SQL (and other relational databases)
Excellent analytical skills
Experienced in SAP
Statistics background would be considered an asset
Strong organizational and leadership skills.
Effective project management skills.
Able to maintain strong working relationships with internal employees and with external partners.
In addition to excellent analytic skills, the candidate must be able to interpret and present information (both written and verbal) in an engaging, meaningful way.
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.
Hiring Range / Echelle salariale a l'embauche :
$100,000.00 - $132,000.00 / 100.000,00$ - 132.000,00$ (per year / par an)
A candidate's experience and knowledge as well as the geographical region in which the position is located may be factored into the pay a candidate receives for this position. This posting is for a newly created position. The Company uses artificial intelligence for the purpose of screening, assessing and/or selecting applicants for this position. / L'experience et les connaissances d'un candidat ainsi que la region geographique dans laquelle le poste est situe peuvent etre prises en compte dans la remuneration qu'un candidat recoit pour ce poste. Cette offre d'emploi concerne un poste nouvellement cree. L'entreprise utilise l'intelligence artificielle dans le but de filtrer, d'evaluer et/ou de selectionner les candidats a ce poste.
#EN #SS #SDM #ON

Skills Required