Senior Analyst, Business Intelligence

Shoppers Drug Mart Specialty Health Network

Mississauga

Hybrid

CAD 60,000 - 83,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Accommodation available

Job summary

Shoppers Drug Mart Specialty Health Network Inc. in Mississauga, Ontario, seeks a Senior Analyst, Business Intelligence and Insights to translate business needs into data-driven solutions using SQL, Power BI, and Salesforce.

You will collaborate with program management and operations to deliver outputs, validate results, and document requirements, while working from the SHN office most days with some remote flexibility.

Qualifications

  • Minimum 2–3 years of experience preferably in a pharmaceutical industry.
  • Post-secondary education equivalent to a university degree in analytics, mathematics, computer science, or engineering.
  • Strong knowledge of relational databases and SQL.
  • Familiarity with CRM platforms (e.g., Salesforce) is a strong asset.
  • Experience with BI platforms (e.g., Power BI) is a strong asset.

Responsibilities

  • Act as a conduit between client partners, SHN program management and operations teams, and the BI team to translate business requirements into data-driven outputs.
  • Recommend and facilitate the development of specific data solutions, both as ad-hoc requests and for ongoing outputs.
  • Adhere to best practices for testing and deploying solutions.
  • Validate outputs, analyze trends, identify opportunities and weaknesses for end users.
  • Maintain requirements and technical documentation for outputs to ensure usability and knowledge transfer.
  • Assess impact to outputs due to process changes.

Skills

SQL
Relational databases
Analytical thinking
Communication skills

Education

University degree in Analytics/Math/CS/Engineering

Tools

Power BI
Salesforce CRM

Job description

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 and Insights is an individual with strong technical skills that will leverage SHN program, patient, and system data to generate outputs and insights that guide effective business decision making. They will work with key stakeholders within the BII team and within the program management and operations teams to understand requirements and develop data-driven solutions.

What You Will Do
  • Act as a conduit between client partners, SHN program management and operations teams, and the BII team to effectively understand and translate business and/or operational requirements into data-driven solutions and outputs.
  • Recommend and facilitate the development of specific data solutions, both as ad-hoc requests/support and for ongoing scheduled outputs
  • Adhere to best practices for testing and deploying aligned-on solutions
  • Validate outputs, analyze trends, identify opportunities and weaknesses for end users
  • Maintain business requirements, functional requirements and technical specification documentation for all outputs to ensure easy usability, referencing, and knowledge transfer
  • Assess impact to existing solutions/outputs due to proposed operational and system process changes
What You Will Need
  • Minimum 2-3 years of experience preferably in a pharmaceutical industry
  • Post-secondary education equivalent to a university degree in a numerate or analytical discipline such as Analytics, Mathematics, Computer Science, or Engineering.
  • Strong knowledge and understanding of relational databases and querying ability using SQL is a key skill
  • Familiarity with CRM platforms (eg. SalesForce) is a strong asset
  • Experience with Business Intelligence Platforms (eg. PowerBI) is a strong asset
  • Effective organizational and communication skills
  • Well-developed analytical and problem-solving skills
  • Must be able to manage time effectively through flexibility & prioritization in an environment of fast-paced change and ambiguity

This role requires you to work from the SHN office (Tech Ave) a minimum of four days a week (one day allowed to work remote).

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

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.

Hiring Range / Échelle Salariale à L’embauche

$60,000.00 - $82,500.00 / 60.000,00$ - 82.500,00$ (per year / par an)

A candidate’s experience and knowledge as well as the geographical region in which the position is located may be factored into the pay a candidate receives for this position. This posting is for an existing vacancy. The Company uses artificial intelligence for the purpose of screening, assessing and/or selecting applicants for this position. / L’expérience et les connaissances d’un candidat ainsi que la région géographique dans laquelle le poste est situé peuvent être prises en compte dans la rémunération qu’un candidat reçoit pour ce poste. Cette offre d’emploi concerne un poste vacant existant. L’entreprise utilise l’intelligence artificielle dans le but de filtrer, d’évaluer et/ou de sélectionner les candidats à ce poste.

#EN

#SS #ON

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Analyst, Business Intelligence
Senior Analyst, Business Intelligence

Specialty Health Network • Mississauga

Hybrid
CAD 60,000 - 83,000
Purchase discount program
Academy online learning
Senior Program Manager (15-month Contract)
Senior Program Manager (15-month Contract)

Shoppers Drug Mart Specialty Health Network • Mississauga

On-site
CAD 120,000 - 154,000
Competitive salary
Benefits package
Shoppers discount
+3
Senior Manager, Learning, Development and Engagement
Senior Manager, Learning, Development and Engagement

Loblaw • Toronto

On-site
CAD 100,000 - 132,000
Purchase discount program
Online learning through Academy
Competitive pay
Senior Manager, Specialty Programs
Senior Manager, Specialty Programs

Specialty Health Network • Mississauga

On-site
CAD 120,000 - 154,000
Purchase discount program
Competitive pay
Online learning through Academy
Patient Care Specialist-4
Patient Care Specialist-4

Shoppers Drug Mart Specialty Health Network • Mississauga

On-site
CAD 52,000 - 72,000
Discount program
Online learning via Academy
Competitive pay
+2
Analyst, Promotion Optimization
Analyst, Promotion Optimization

Shoppers Drug Mart • Toronto

On-site
CAD 60,000 - 83,000
Purchase discount program
Online learning through Academy
Competitive pay
Senior Specialist, Quality Assurance
Senior Specialist, Quality Assurance

Shoppers Drug Mart • Toronto

On-site
CAD 68,000 - 94,000
Purchase discount
Competitive pay
Online learning through Academy
Analyst, Supply Chain Replenishment, Logistics
Analyst, Supply Chain Replenishment, Logistics

Loblaw • Toronto

On-site
CAD 52,000 - 72,000
Purchase discount program
Online learning through Academy
Director, Pharmacy Experience and Transformation
Director, Pharmacy Experience and Transformation

Shoppers Drug Mart • Toronto

On-site
CAD 128,000 - 176,000
Purchase discount program
Academy online learning
Analyst, Promotion Optimization
Analyst, Promotion Optimization

Loblaw • Toronto

On-site
CAD 60,000 - 83,000
Purchase discount program
Online learning through Academy