Job Title

Overview Location: 243 Consumers Road, Toronto, Ontario, M2J 4W8 At Shoppers Drug Mart, were innovating health and wellness in Canada. From prescriptions to walk-in clinics, and a beloved loyalty program, were 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, its a great place to work. Were 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 Marts Pharmacy Procurement program. The scope includes 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 Generic Medicine Utilization Program Formulary Purchase Program 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 Market Intel Portfolio Management Rx Financial Plan Tracker 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 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 Youll 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 Canadas diversity as a source of national pride and strength. We have made it a priority to reflect our nations 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 / chelle salariale lembauche : $100,000.00 - $132,000.00 / 100.000,00$ - 132.000,00$ (per year / par an) A candidates 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. / Lexprience et les connaissances dun candidat ainsi que la rgion gographique dans laquelle le poste est situ peuvent tre prises en compte dans la rmunration quun candidat reoit pour ce poste. Cette offre demploi concerne un poste nouvellement cr. Lentreprise utilise lintelligence artificielle dans le but de filtrer, dvaluer et/ou de slectionner les candidats ce poste. #EN #SS #SDM #ON #J-18808-Ljbffr