Business Analyst II - Pharmacy Operations (Temporary - 18 month contract)

Intello Technologies Inc.; Calgary; Hybrid; CAD 57,000 - 105,000; Full time

Benefits offered by this job

Total rewards package

3 weeks vacation minimum

Flexible benefits plan

Pension and share purchase

Work options: in-office/virtual

Community involvement

Job summary

TELUS Health in Calgary is seeking a Business Analyst II to join the Drug Operations team, ensuring Health Canada-approved drugs, formularies, and DIN-based lists are current and precise to support Canadians in accessing medications.

You will work with cross-functional teams to maintain data accuracy, manage formulary structures, and respond to pricing or coverage inquiries while meeting SLAs. A strong background in PBM and SQL will help optimize data quality in a regulated healthcare setting.

Qualifications

• PBM experience with claim adjudication principles, formulary management, and pharmacy benefit systems
• 1–3 years in a comparable business analyst, pharmacy operations, or drug information role
• Advanced Excel (pivot tables, VLOOKUP, data validation, formula development) for managing and analyzing formulary and pricing data
• Strong written and verbal communication skills, with ability to document complex business processes clearly and concisely
• Excellent organizational and planning skills with demonstrated ability to prioritize multiple tasks and adapt quickly to changing requirements
• Working knowledge of SQL or database query tools for data retrieval and validation
• Meticulous attention to detail and commitment to data accuracy in a regulated healthcare environment

Responsibilities

• Maintain flawless database accuracy by adding, updating, and validating drug information for Health Canada-approved products and provincial PINs in the TELUS system, using both database UI entry and SQL queries to prevent claim processing errors
• Master and manage PBM claim adjudication data structures by creating and maintaining formularies, price files, categorization rules, and list management to ensure smooth claim processing across pharmacy networks
• Establish standardized business process documentation that captures workflows, decision trees, and system requirements while ensuring consistency across the Drug Operations team
• Provide expert, timely responses to complex drug pricing, plan coverage, and formulary inquiries from internal teams and external stakeholders, meeting established SLAs while maintaining comprehensive documentation
• Collaborate with cross-functional teams including pharmacy operations, compliance, and system administrators to implement updates, troubleshoot claim adjudication issues, and optimize data quality processes

Skills

PBM experience

Excel expert

SQL knowledge

Communication skills

Organization skills

SQL queries

Education

Post-secondary diploma or certification

Job description

Select how often (in days) to receive an alert:

Business Analyst II - Pharmacy Operations (Temporary - 18 month contract)

Location: Calgary, AB, CA, T2P 0W4 Vancouver, BC, CA Halifax, NS, CA St John's, NL, CA Toronto, ON, CA Moncton, NB, CA Edmonton, AB, CA Ottawa, ON, CA Winnipeg, MB, CA

Jobs by Category: Health

Job Function: Health Solutions

Status: Full Time

Schedule: Temporary

Description

Our team and what we'll accomplish together

You'll join TELUS Health's Drug Operations team, a mission-critical group responsible for maintaining the accuracy and integrity of Canada's pharmacy benefit management systems. As a Business Analyst II, you'll ensure that Health Canada-approved drugs, formularies, and DIN-based lists are current and precise, directly impacting how millions of Canadians access their medications. You'll thrive in a collaborative, fast-paced environment where your attention to detail and analytical thinking drive real healthcare outcomes.

What you'll do

• Maintain flawless database accuracy by adding, updating, and validating drug information for Health Canada-approved products and provincial PINs in the TELUS system, using both database UI entry and SQL queries to prevent claim processing errors
• Master and manage PBM claim adjudication data structures by creating and maintaining formularies, price files, categorization rules, and list management to ensure smooth claim processing across pharmacy networks
• Establish standardized bus iness process documentation that captures workflows, decision trees, and system requirements while ensuring consistency across the Drug Operations team
• Provide expert, timely responses to complex drug pricing, plan coverage, and formulary inquiries from in ternal teams and external stakeholders, meeting established SLAs while maintaining comprehensive documentation
• Collaborate with cross-functional teams including pharmacy operations, compliance, and system administrators to implement updates, troubleshoot c laim adjudication issues, and optimize data quality processes

Qualifications

What you bring

• Pharmacy Benefit Management (PBM) experience with demonstrated knowledge of claim adjudication principles, formulary management, and pharmacy benefit systems
• 1–3 years of experience in a comparable business analyst, pharmacy operations, or drug information role
• Advanced proficiency with Microsoft Excel (pivot tables, VLOOKUP, data validation, formula development) for managing and analyzing formulary and pricing data
• Strong written and verbal communication skills, with ability to document complex business processes clearly and concisely
• Excellent organizational and planning skills with demonstrated ability to prioritize multiple tasks and adapt quickly to changing requirements
• Working knowledge of SQL or database query tools for data retrieval and validation
• Meticulous attention to detail and commitment to data accuracy in a regulated healthcare environment

Great-to-haves

• Bilingual proficiency in French and English, with ability to communicate complex drug information in both languages
• Post-secondary diploma or certification in pharmacy, healthcare administration, or a related field
• Experience with TELUS Health systems or other pharmacy benefit management platforms

Salary Range: $57,000-$105,000

Performance Bonus or Sales Incentive Plan: 10%

Actual total compensation will be determined based on factors such as knowledge, skills, performance and experience. We're open to discussing competitive compensation packages tailored to your experience level and expertise. TELUS offers rewarding benefits, which may vary per job function, such as:

• Comprehensive total rewards package highlighting competitive salary and bonus structures, minimum 3 weeks of vacation, and flexible benefits plan to meet the needs of you and your family
• Flexibility to work in-office, virtually or a combination of both, based on the role's requirements
• Generous company matched pension and share purchase programs
• Opportunity to give back to communities in which we work, live and serve
• Career growth and learning & development opportunitiestodevelop your skills
• And much more

Job Type: This is for a current vacancy

A bit about us

We’re a people-focused, customer-first, purpose-driven team who works together every day to innovate and do good. We improve lives through our technology solutions and foster a culture of innovation that empowers team members to solve complex problems and create remarkable human outcomes in a digital world.

You’ll find our engaging, high-performance culture personally fulfilling, professionally challenging, and financially rewarding. We’re committed to diversity and equitable access to employment opportunities based on ability. Your unique contributions and talents will be valued and respected here. When you join our team, you’re helping us make the future friendly.

TELUS Health is an IT leader in Canada that focuses on the health sector. Our mission is to improve the way information is being used along the continuum of care to better the health of citizens in Canada and in selected countries.

Disclaimer: In accordance with the TELUS Health Solutions Data Center Security Policy, as a condition of employment, all team members whose job functions require they work at a Data Center and/or have access to detailed knowledge of technology related to client service delivery, are subject to a Personnel Security Screening conducted through the Government of Canada.

Note for Quebec candidates: if knowledge of English is required for this position, it is because the team memberwill be asked, on a regular basis, to interact in English with external or internal parties or to use English applications or software as part of their tasks.

By applying to this role, you understand and agree that your information will be shared with the TELUS Group of Companies’ Talent Acquisition team(s) and/or any leader(s) who will be part of the selection process.

Health

We’re looking for clinicians, programmers, product developers, sales and marketing people, customer support, and everyone in between. If you have a penchant for turning information into better health outcomes, then we want you to help us develop, implement and manage the most innovative healthcare solutions possible.

We are honoured to be recognized

21,166
Physicians using TELUS Health electronic medical records

140 million+
Health claims processed using TELUS Health solutions

Accessibility

TELUS is proud to foster an inclusive culture that embraces diversity. We are committed to fair employment practices and all qualified applicants will receive consideration for employment.

We offer accommodation for applicants with disabilities, as required, during the recruitment process.