Specialist, Virtual Card Services

Shoppers Drug Mart Specialty Health Network; Mississauga; On-site; CAD 52,000 - 72,000; Full time

Benefits offered by this job

Purchase discount program

Job summary

Shoppers Drug Mart Specialty Health Network Mississauga seeks a Business Analyst to troubleshoot and support financial assistance programs, simplifying high-cost medication billing. You will coordinate setup/activation of policies, manage data, and collaborate with project teams to achieve client objectives.

The role requires strong analytical and communication skills, advanced Excel/VBA, and familiarity with CRM and BI tools; a team player who can meet deadlines in a fast-paced environment.

Qualifications

• 2–5 years of relevant work experience.
• Degree in Business/CS/Engineering or equivalent is an asset.
• Strong computer skills in Windows environment with MS Visio, PowerPoint and Word.
• Experience with Excel, VBA, Access; SQL is a plus.
• Familiarity with CRM platforms and BI tools is advantageous.
• Able to multitask and meet deadlines with strong communication.

Responsibilities

• Respond to inquiries from SHN staff or pharmacies.
• Document needs for upgrades, training issues and refreshers.
• Maintain data structures to monitor product attributes and performance.
• Create, review and audit Financial Assistance reports.
• Run and analyze reports; summarize for end users.
• Ensure adherence to internal policies and timelines.

Skills

Analytical skills

Communication skills

Time management

Multitasking

Customer service

Attention to detail

confidentiality

Education

Business/Computer Science/Engineering degree

Tools

MS Visio

PowerPoint

Word

Excel

VBA

Access

SQL

Salesforce

Siebel

Qlik/Tableau

Job description

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.

Location:

1685 Tech Ave, Mississauga, Ontario, L4W 0A7

Why this role is important?

Basic Function The Business Analyst is directly responsible for providing troubleshooting and technical assistance for financial assistance programs which simplify complex billing processes for high cost medications for retail pharmacies. The Business Analyst is responsible for ensuring coordination and maintenance of set-up, activation and termination of policies for financial assistance programs, data management and acts as a coordinator for various projects. You will work closely with the program management team to deliver exceptional client management and business objectives. You must be keen to apply your unique talents and be part of a high-performing team.

Principal Accountabilities

• Respond to incoming calls, emails or system communications from SHN Staff or Pharmacies
• Work with various business units to document needs for future upgrades, training issues and refresher sessions
• Responsible for developing and maintaining the data structures required to monitor product attributes and performance to proactively identify issues
• Provide exceptional customer service to all parties requesting assistance, ensuring that the unique needs of the individual’s requirements are met
• Assist with projects as requested
• Carry out duties and responsibilities in accordance with internal policies and procedures, as well as maintaining timelines based on contractual obligations
• Create, review and audit reports for Financial Assistance across the SHN programs
• Data management and secure file transfer
• Run, validate and review reports, analyze trends, opportunities and weaknesses and summarize for report end users which includes internal employees and clients
• Maintain business requirements, functional requirements and technical specification documentation for all reports
• Liaise with internal staff who provide and support program services
• 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 procedures

Qualifications And Skills

• A minimum of 2-5 years of relevant work experience
• Business/Computer Science/Engineering Degree or equivalent working experience is an asset
• Strong computer skills in a Windows environment using MS Visio, PowerPoint and Word
• Intermediate or Expert level Excel, VBA, Access (and other relational databases); SQL experience is an asset
• Well-developed analytical and problem-solving skills
• Familiarity with CRM platforms (SalesForce, Siebel, PatientConnect, etc.) and Business Intelligence Platforms (Qlik, Tableau, etc.) is a strong asset
• A team player with the desire to provide superior customer care
• Able to multitask, prioritize work, and meet deadlines
• Excellent communication skills, verbal and written
• Work effectively, with short lead times and changing customer demands
• Diplomatic, professional communicator, able to maintain patient confidentiality, as per SDM Specialty Health Network policies and legal requirements
• Excellent time management, organizational, and a keen attention to detail are required
• Must work well under pressure, with changing deadlines from external forces, changing priorities, and projects with multiple individuals within the organization
• Must be able manage time effectively through flexibility & prioritization
• Must enjoy working in an environment of fast paced change and ambiguity, with little direct supervision

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.

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

$52,000.00 - $71,500.00 / 52.000,00$ - 71.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