Summer Student Supply Chain

Job Description Summary

Location: Montreal #LI-Hybrid
From May 4 to August 28 2026 - 17 weeks
Novartis is unable to offer relocation support for this role; please only apply if this location is accessible for you.

Job Description

Key Responsibilities:

• Drive Novalytics Project by collecting and documenting business requirements and designing data models datasets and reporting structures to support dashboards analytics and recurring business reports.
• Design develop modify and maintain database and business intelligence solutions to improve reporting performance visual design usability and data refresh efficiency related to the Novalytics project.
• Launch SCM Planning Playbook through analyzing data using database management and BI tools to validate data accuracy perform trend analysis and generate actionable insights for sales planning and management reviews.
• Develop and implement data standards documentation and best practices to streamline data preparation validation governance and recurring report generation for the Planning Playbook
• Provide analytical and technical support for SCM enterprise system and analytics tool rollouts including data readiness user training support deployment tracking and post-implementation analysis for Novalytics and Planning Playbook.

Essential Requirements:

• Currently enrolled in a university program (Supply Chain Management Business Finance Economics Engineering or a related field)
• Power BI dashboard development & DAX: building and maintaining interactive reports creating measures/calculations and optimizing models for performance.
• Advanced Excel analytics: PivotTables Power Query Power Pivot complex formulas and clean/structured workbook design.
• Supply chain analytics fundamentals: understanding common Supply Chain KPIs and using data to identify root causes and opportunities.
• Improvement project execution & stakeholder communication: scoping work managing priorities/timelines translating business questions into analyses and presenting clear insights/recommendations to non-technical partners
• Language & level: French - advanced and English - advanced.

Commitment to Diversity and Inclusion: Novartis is committed to building outstanding inclusive work environment and diverse teams representatives of the patients and communities we serve.

Skills Desired