REQ-10071790
Feb 12, 2026
Canada
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.
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.
About the Role
Key Responsibilities:
- Conduct needs assessments and gather requirements with multiple teams, documenting current-state processes, identifying pain points, and defining automation opportunities.
- Design and develop automation solutions (SQL/Python, Power Platform) to streamline data preparation, KPI generation, and reporting.
- Build data transformations, validation checks, and scheduled refreshes to ensure reliable outputs.
- Produce clear technical documentation (data flows, logic, assumptions) and communicate progress/status to stakeholders.
- Develop Power BI dashboards to support automation use cases that can be addressed through standardized, automated reporting.
Essential Requirements:
- Currently pursuing a degree in Computer Science, Information Technology, Software Engineering, Data Science, Business Intelligence, or related field.
- Hands-on coding ability in SQL and Python (data manipulation, automation scripts, basic testing/validation).
- Basic knowledge of data engineering best practices (data quality, version control, documentation, scalable design).
- Experience with Power BI (data modeling, measures, visuals) and familiarity with Power Automate/Power Apps.
- Strong analytical and communication skills; ability to collaborate with non-technical stakeholders and translate needs into solutions.
Why Novartis: Helping people with disease and their families takes more than innovative science. It takes a community of smart, passionate people like you. Collaborating, supporting and inspiring each other. Combining to achieve breakthroughs that change patients’ lives. Ready to create a brighter future together? https://www.novartis.com/about/strategy/people-and-culture
Benefits and Rewards: Learn about all the ways we’ll help you thrive personally and professionally.
Read our handbook (PDF 30 MB)
International
Strategic Planning & BD&L
Canada
Montreal
CA04 (FCRS = CA004) NOVARTIS PHARMA CANADA INC.
Toronto, Canada
Others
Full time
Early Career (Fixed Term)
No