Senior Technical Business Analyst – CABL Initiative

Job Description

Senior Technical Business Analyst – CABL Initiative

Location: Saint-Laurent, Quebec

Duration: Initial 6-month assignment, with potential extension

Job Type: Contract

Work Model: Hybrid, 2 days per week onsite

About the Opportunity

McKesson Canada is seeking a Senior Business Analyst to support the CABL initiative, partnering with business stakeholders, MBA subject matter experts, and data engineering teams. This role will focus heavily on data discovery, requirements analysis, data mapping, and business rule documentation needed to support Snowflake-based analytics, contract validation, and leakage analysis.

The ideal candidate is a senior, bilingual Business Analyst with strong SQL and data-modeling capabilities who is comfortable working across both business and technical teams.

Key Responsibilities

• Lead data discovery and analysis across MBA source systems, identifying key data structures, relationships, dependencies, and business rules.

• Elicit, analyze, and document business, functional, and technical requirements through stakeholder and SME working sessions.

• Develop source-to-target mappings, data dictionaries, ERDs, SIPOCs, process flows, and data lineage documentation.

• Analyze Contract, Alliance Code, Banner, and Customer hierarchies, along with Pricing, Fee-for-Service (FFS), Best Price, Private Label, NWDA, Promo, and Prebook classification requirements.

• Partner with data engineering and business teams to provide Snowflake ingestion, mapping, and data-model recommendations supporting contract validation and leakage analysis.

• Must-Have Qualifications

• Business fluency in both French and English, with the ability to work effectively with bilingual business and technical stakeholders.

• Advanced SQL skills with a strong understanding of relational databases, data structures, and complex data analysis.

• Proven experience with data analysis, data mapping, data modeling, data lineage, and data-quality analysis.

• Strong experience eliciting and documenting business and technical requirements, business rules, and data-transformation logic.

• Experience supporting data warehouse, reporting, analytics, or cloud data-platform initiatives, including Snowflake or a comparable platform.

• Nice-to-Have Qualifications

• Experience within pharmaceutical distribution, healthcare supply chain, contract management, pricing, or commercial agreements.

• Experience with Snowflake, ERP systems, legacy enterprise applications, data governance, and master data management.

• Exposure to contract leakage analysis, pricing validation, and revenue validation processes.

• Required Experience

• 8+ years of Business Analysis experience.

• 5+ years of experience working with complex enterprise applications and data-intensive programs.

• Demonstrated experience working independently and facilitating requirements and analysis sessions across business, SME, and technical teams.

• Proficiency with Excel, Visio, Jira, or equivalent tools.

• Strong stakeholder management, communication, analytical, and problem-solving skills.

• Education & Certifications

• Degree, diploma, or equivalent professional experience in Business, Information Technology, Data, Computer Science, or a related discipline.

• Relevant Business Analysis, data, or technology certifications are considered an asset.

• Additional Engagement Details

• Start Date: Immediate requirement; candidate availability within 2–4 weeks preferred.

• Position Count: 1

• Interview Process: One interview round anticipated.

• Interviews may include business stakeholders, subject matter experts, and technology team members.

• Interviews will be conducted in both French and English.

• No formal technical test is planned. Candidates should expect scenario-based questions covering business analysis, data analysis, stakeholder management, and data modeling.