Senior System

Location:

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?

Shoppers Drug Mart is one of the most recognized and trusted names in Canadian retailing. The Company is the licensor of full-service retail drug stores operating under the name Shoppers Drug Mart (Pharmaprix in Québec). With over 1,000 Shoppers Drug Mart and Pharmaprix stores operating in prime locations in each province and three territories, the Company is one of the most convenient retailers in Canada.

At Shoppers Drug Mart, we have always remained true to our belief that the root of our success lies with our people.  We pride ourselves on the quality and commitment of our employees who thrive on exciting challenges.

Senior System & Reporting Specialist

SUMMARY

Reporting to the Senior Manager, Analytics & Planning, this role is responsible for the data systems and tools that support the analysis driving the management and execution of the generic component of Shoppers Drug Mart's Pharmacy Procurement program, and Sanis Health Supply Planning Division. The scope of the role encompasses the following broad functions: robust data integration across diverse platforms, comprehensive data quality management (including cleansing and optimization), SQL Server database development and optimization, advanced reporting (including Power BI and operational reports), decision support tools development, analytical modeling, demand/supply planning, and technical documentation.

• Maintain, monitor, and optimize Sanis databases, Sanis/SAP tables to ensure high performance, availability, and data quality and accuracy

• Ensure the accuracy, consistency, and reliability of critical data assets, including master data and product attributes

• Convert current Sanis forecast to SQL Server (or similar) with proper checks and balances

• Research, evaluate, and implement new, advanced forecasting solutions specifically design for Sanis operations

• Responsible for compelling dashboard and tool designing to support:

• • Sanis Supply Chain

  • Market Intel

  • Portfolio Management

  • Rx Plan Tracker

  • Product Program Tracker

  • 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

• Develop streamlined information sharing strategies to support 2-way dialog

• Where possible, seek alternate tools and platforms to support sustainability and continuity

• Ensure appropriate documentation 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.

 For internal applicants:

Please note, staff cannot be approached directly for the purpose of recruitment/interviews without prior knowledge of the Associate or Department Head.  A minimum of four (4) weeks notice must be provided unless otherwise agreed upon by the Associate or Department Head.

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:

Type of Role:

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.

#EN