Senior Analyst, Business Intelligence

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?

The Senior Analyst, Reporting position's primary responsibility will be to help extract & analyze all patient assistance program data within core therapeutic areas and provide value add insight into trends, opportunities, performance to targets and benchmarks for programs and recommendations on efficiencies. The Senior Analyst's role is to assist the business users in getting raw data out of the system to turn into something meaningful for stakeholders. They will also act as a liaison for communication between the business end users and the developers.  

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

What you will do: 

Act as a conduit between: Client, SHN Sales & Marketing and Business Intelligence department to clarify and translate business and or operational requirements into documentation and conceptual report designs 

Recommend and facilitate development of reports (regular & ad-hoc) 

Develop, run, validate and review reports, analyze trends, monitor and maximize operational excellence, and summarize analyses for report end users which includes internal employees and clients 

Deliver said analysis & reports in the most effective way possible for the audience  

Develop financial analysis and reports designed to maximize profitability  

Develop supporting invoice data and queries 

Maintain business requirements, functional requirements and technical specification documentation for all reports 

Participate in audits on behalf of the Business Intelligence department  

Participate in Request for Proposal processes related to specific therapeutic area of expertise 

Assess impact to reports due to process changes and improvements 

Report 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 procedure 

What you will need: 

Business/Computer Science/Engineering Degree or equivalent working experience 

A minimum of 3-7 years' experience preferably in a pharmaceutical industry 

Strong knowledge and understanding of SQL is a key skill 

Effective organizational, communication and customer relations skills 

Well-developed analytical and problem-solving skills  

Familiarity with CRM platforms (SalesForce) 

Exceptional computer skills (MS Excel and quantitative & statistical analysis tools) 

Experience with Business Intelligence Platforms (i.e. Tableau, PowerBI, etc.) 

Must be able manage time effectively through flexibility & prioritization 

Must 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:

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