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:

1685 Tech Ave, Mississauga, Ontario, L4W 0A7

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?

The Senior Analyst, Business Intelligence position’s primary responsibility will be to extract & analyze patient assistance program data within core therapeutic areas, and to provide value & insight into therapeutic trends, opportunities and weaknesses. The Senior Analyst’s role is to assist business users through providing raw data, and using it to generate meaningful insights for stakeholders. The reporting analyst will also act as a liaison for communication between the business end users and the developers.

Nature and Scope

The incumbent will work with internal staff to develop and maintain comprehensive reporting for SDM Specialty Health Network Management and external clients, as contracts and requirements dictate.

Principal Accountabilities

Act as a conduit between:Client, SHN Sales & Marketing, and Business Intelligence departments to clarify and translate business and/or operational requirements into documentation and conceptual report designsThird party vendors, e.g. IQVIA and SHNSHN internal clients and report writers to facilitate the development of reportsDevelop financial analysis and reports designed to maximize profitabilityDevelop supporting invoice data and queriesRecommend and facilitate development of reports (regular & ad-hoc)Run, validate and review reports, analyze trends, opportunities and weaknesses and summarize for end users of those reports, which includes internal employees and clientsMaintain business requirements, functional requirements and technical specification documentation for all reportsParticipate in Business Intelligence department for auditsParticipate in Request for Proposal process related to specific therapeutic area of expertiseAssess impact of process changes on reportingCreate manufacturer service fee invoicesProvide supporting documentation for service fee invoices Document report errorsPerform Data Base Code Promotion regression testingReport all Adverse Events (AE) and Product Technical Complaints (PTC) immediately or as soon as possible upon becoming aware of the event as per current policies and procedures

Qualifications and Skills

Business/Computer Science/Engineering Degree or equivalent working experienceA minimum of 1-3 years’ experience preferably in a pharmaceutical industryStrong knowledge and understanding of SQL language is a key skillEffective organizational, communication and customer relations skillsWell-developed analytical and problem-solving skillsFamiliarity with CRM platforms (SalesForce, Siebel, PatientConnect, etc.)Exceptional computer skills (MS Excel and quantitative analysis tools)Experience with Business Intelligence Platforms (i.e. PowerBI, Qlik, Tableau, etc.) is a strong assetMust be able manage time effectively through flexibility & prioritizationMust enjoy working in an environment of fast paced change and ambiguity

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.