Senior Technical Business Analyst – CABL Initiative

Apex Systems; Montreal; Híbrido; CAD 90.000 - 131.000; Jornada completa

Descripción de la vacante

Everforth Apex in Saint-Laurent, Quebec seeks a Senior Technical Business Analyst for the CABL initiative. Hybrid work model with 2 days onsite. You will lead data discovery, document business rules, and partner with data engineering on Snowflake ingestion and mappings.

The role requires senior-level BA experience, fluency in French and English, and strong SQL/data-modeling skills to support contract validation and leakage analysis.

Formación

• 8+ years of Business Analysis experience.
• 5+ years with complex enterprise applications and data-intensive programs.
• Bilingual in French and English and able to work with bilingual stakeholders.
• Experience with data warehouse, analytics, or cloud platforms (Snowflake).
• Strong requirement elicitation and data-transformation documentation experience.

Responsabilidades

• Lead data discovery and analysis across MBA source systems and data structures.
• Elicit, analyze, and document business, functional, and technical requirements.
• Develop source-to-target mappings, data dictionaries, ERDs, SIPOCs, and data lineage.
• Analyze hierarchies and classification requirements for contracts, pricing, and campaigns.
• Collaborate with data engineering for Snowflake ingestion and mapping.

Conocimientos

Bilingual French/English

Advanced SQL

Data analysis

Data mapping

Data modeling

Data lineage

Data quality analysis

Requirements elicitation

Snowflake / cloud data platform

Data warehouse / reporting

Educación

Degree in Business/IT/Data/CS

Herramientas

Excel

Visio

Jira

Descripción del empleo

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 804-523-8228. (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.