Data Engineer I - Internship: ELT Pipelines & Cloud

Intact Financial Corporation; Montreal (administrative region); On-site; CAD 67,000 - 83,000; Full time

Job summary

Intact Financial Corporation is launching your tech career by joining a diverse team of Digital, Data and Tech experts. You will contribute to data flows and build pipelines using Python, Databricks, and Snowflake, while learning cloud technologies.

The Winter 2027 internship is full-time (35 hours/week) in Montreal, Quebec, with bilingual collaboration across English and French teams. You should be a currently enrolled student in AI/CS/Engineering and ready to return to school in 2027.

Qualifications

• Currently pursuing a Bachelor’s or Master’s in AI, data science, CS, engineering, math or statistics.
• Available to work full-time, 35 hours per week, for the Winter 2027 Term (January–April).
• Active student during internship and planning to return to school in 2027.
• Bilingual in Quebec interactions with English-speaking colleagues.
• Eligible to work in Canada; no Canadian work experience required.

Responsibilities

• With your team, participate in development and delivery of efficient data flows.
• Build, optimise and maintain data ELT/ETL pipelines into Intact’s data platform using Python and Databricks.
• Contribute to best practices to depersonalize datasets and ensure data quality.
• Work on data modeling and building reporting capabilities.
• Certify data as a trusted asset with data reconciliation pipelines.
• Collaborate with developers, devops, data scientists and end users.

Skills

Python

SQL

PySpark

AWS

Education

Bachelor’s or Master’s in AI/Data Science/CS/Engineering/Math/Statistics

Tools

Databricks

Snowflake

AWS

Job description

Intact Financial Corporation is launching your tech career by joining a diverse team of Digital, Data and Tech experts. You will contribute to data flows and build pipelines using Python, Databricks, and Snowflake, while learning cloud technologies.

The Winter 2027 internship is full-time (35 hours/week) in Montreal, Quebec, with bilingual collaboration across English and French teams. You should be a currently enrolled student in AI/CS/Engineering and ready to return to school in 2027.