Senior Analyst, Business Intelligence And Reporting

Mississauga, ON, Canada

Job Description


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\xe2\x80\x99re innovating health and wellness in Canada. From prescriptions to walk-in clinics, and a beloved loyalty program, we\xe2\x80\x99re 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\xe2\x80\x99s a great place to work. We\xe2\x80\x99re 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\xe2\x80\x99s 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\xe2\x80\x99s 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\xe2\x80\x99 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 analysis tools)

Experience with Business Intelligence Platforms (i.e. Tableau, PowerBI, etc.) is a strong asset

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\xe2\x80\x99ll 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\xe2\x80\x99s 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 \xe2\x80\x93 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.

Shoppers Drug Mart

Beware of fraud agents! do not pay money to get a job

MNCJobz.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Job Detail

  • Job Id
    JD2254248
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Full Time
  • Salary:
    Not mentioned
  • Employment Status
    Permanent
  • Job Location
    Mississauga, ON, Canada
  • Education
    Not mentioned