Senior Technical Business Analyst - CABL Initiative

Senior Technical Business Analyst - CABL Initiative

Job#: 3057822

Job Description:

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.

Everforth Apex is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Everforth Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Benefits Department at [email protected] or View phone number on apply.j-vers.com. (Do not submit resumes or solicit consultants to this email address). UnitedHealthcare creates and publishes the Transparency in Coverage Machine-Readable Files on behalf of Everforth Apex.