Summer Student Data Automation
Share
Job Location:
Monthly Salary:
Posted on:
30+ days ago
Vacancies:
1 Vacancy
Job Summary
Job Description Summary
Location: Montreal #LI-HybridFrom 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:
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.
Skills Desired
About Company
Novartis is a global healthcare company based in Switzerland that provides solutions to the evolving needs of patients worldwide.
