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.
#J-18808-Ljbffr
Senior Technical Business Analyst – CABL Initiative in Montréal employer: Apex Systems
Everforth Apex is an exceptional employer located in Vancouver, BC, offering a dynamic hybrid work environment that fosters innovation and collaboration. With a strong commitment to employee growth, we provide extensive training resources, certification opportunities, and a comprehensive benefits package, ensuring that our team members thrive both personally and professionally. Join us to be part of a culture that values continuous learning and recognizes excellence, making it a rewarding place to advance your career as an IT Project Manager.
