City : Toronto, Ontario

Category : Full time

Industry : Merchandising

Employer : Shoppers Drug Mart®

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:

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 & Insights, this role is responsible for the data systems and tools to support the analysis that drive the 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 maintenance/development/optimization, decision support tools development, data integration across multiple platforms, analytical modeling, demand / supply planning and reporting.

What You'll Do:

• Develop, maintain, optimize and support database systems running on SQL Server.
• Develop, maintain, optimize and support the data transformation activities.
• Identify maintenance plan strategies and opportunities for expansion/upgrade to keep up with increasing data requirements.
• Develop, maintain, design and support the front-end tools and scorecards to support portfolio analysis and complex business decisions.
• Liaise with IT and other business units in the design, development and ongoing maintenance of the databases and reporting tools that drive key business decisions in the pharmacy procurement group.
• Align with Enterprise-level changes and systems migration to ensure minimize gaps in data streams.
• Responsible for the development of structured analyses, utilizing multiple data sources (primary and secondary) and systems, to identify opportunities to enhance our product and vendor mix to meet customer needs and operational & commercial objectives.
• Support for creating and maintaining financial models and for the development and distribution of key reports (both ad hoc and regular) on a timely basis.
• Required to further develop the analytical and decision support capabilities of the Pharmacy Procurement Group through formal and informal coaching and mentoring of team members.

What You'll Need:

• Requires a University degree in Computer Science, Business, Engineering, Mathematics, Statistics or similar.
• 3 - 5 years analytical experience with exposure to a broad array of analysis techniques
• Advance level SQL Server, Excel, VBA, Access; preference will be given to candidates with strong SQL or other relational databases experience
• Retail or generic pharma experience would be considered an asset
• Strong organizational skills. Able to maintain strong working relationships with internal employees and with external partners.
• In addition to excellent technical and analytic skills, the candidate must be able to interpret and present information (both written and verbal) in an engaging, meaningful way.
• This position does not have any direct reports but will provide coaching and support to other team members

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.