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.

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
Toronto, Canada
Others
Full time
Early Career (Fixed Term)
No
A small group engaged in conversation while seated outdoors
REQ-10071790

Summer Student - Data Automation

Apply to Job