Business Intelligence (BI) Developer Intern

Socket.dev; Quebec; On-site; CAD 21,000 - 34,000; Part time

Job summary

Intelcom is seeking an intern to contribute to real data projects and help bring data from diverse sources into the data warehouse. You will gain hands-on experience, build data pipelines, and work with stakeholders across Canada in a fast-moving, innovation-driven environment.

You will develop data transformations, document tests, and contribute to data quality initiatives while collaborating with pan-Canadian teams.

Qualifications

• Currently pursuing a bachelor's degree in Data Engineering, Analytics, Business Analysis or a related program.
• Interest or experience working as data analyst/developer in data projects.
• Strong knowledge of SQL (subqueries, CTEs, window functions).
• Good knowledge of ETL/ELT principles.

Responsibilities

• Collaborate with stakeholders to understand data & analytical requirements.
• Contribute to bring data from various sources into the data warehouse.
• Analyze and suggest data transformations to raw data.
• Write functional analysis documents: Data transformation mapping & workflows design (BPO).
• Develop and document test scenarios.
• Troubleshoot and optimize data pipelines.
• Participate in data quality initiatives.
• Identify and recommend opportunities for system improvement.
• Participate in the resolution of incidents and problems.

Skills

SQL

ETL/ELT

Data engineering concepts

Analytical mindset

Education

Bachelor's degree in Data Engineering, Analytics, Business Analysis or related program

Job description

Make your internship count

At Intelcom, interns don’t just observe, they contribute meaningfully to real projects that shape how we operate. You’ll gain hands‑on experience, grow your skills, and explore long‑term career opportunities in a fast‑moving, innovation‑driven environment.

Responsibilities

• Collaborate with stakeholders to understand data & analytical requirements.

• Contribute to bring data from various sources into the data warehouse.

• Analyze and suggest data transformations to raw data.

• Write functional analysis documents: Data transformation mapping & workflows design (BPO)

• Develop and document test scenarios.

• Troubleshoot and optimize data pipelines.

• Participate in data quality initiatives.

• Identify and recommend opportunities for system improvement.

• Participate in the resolution of incidents and problems. Propose solutions and action plans.

• Theroleinvolvesdaily(orregular) communicationwithpan-Canadian stakeholders.

Qualifications

• Currently pursuing a bachelor's degree in Data Engineering, Analytics, Business Analysis or a relatedprogram.

• Interest or experience working as data analyst/developer in data projects.

• Strong knowledge of SQL (subqueries, CTEs, window functions).

• Good knowledge of ETL/ELT principles.

#LI-DNI #IG-DNI

Intelcom is a leading last-mile carrier in the e-commerce sector. Our teams across Canada as well as our network of independent contractors contribute to Intelcom’s daily operations.

Our goal is simple: in a constantly evolving business sector, we don't just follow, we get ahead. In addition to standing out through innovative services and delivery methods, Intelcom is also undergoing a technological transformation where the integration of customer experience and logistics technologies are at the heart of its evolution.

At Intelcom, we know experience comes in many forms and are committed to building a culture where difference is valued. We are always looking for talented and diverse individuals to join our teams. With over 60 delivery centers across Canada, we may have the right opportunity for you.