About the role#
We are looking for a Business Analyst Co-op student to join our Data Operations team for the Winter 2027 term. This position offers hands-on experience with data pipelines, CRM systems, and cloud-based platforms. You will support ongoing initiatives like CRM migration, data processing, and automation while working with cross-functional teams to ensure data quality.
What you'll do#
- Assist with CRM data migration activities including extraction, transformation, validation, and loading.
- Monitor data pipelines and troubleshoot daily data issues.
- Maintain and improve ETL processes using Python, SQL, or other relevant tools.
- Perform data validation and quality checks to ensure accuracy.
- Work with cloud platforms like GCP for data storage and processing.
- Automate manual processes using scripting or workflow tools.
- Build and enhance reports and dashboards using tools like Power BI.
- Create technical documentation for data processes and workflows.
- Collaborate with stakeholders to define and meet data requirements.
What you'll need#
- Current enrollment in a Computer Science, Data Analytics, Information Systems, or related program.
- Basic knowledge of Python and SQL.
- Familiarity with ETL, data quality, and relational databases.
- Strong analytical, problem-solving, and organizational skills.
- Excellent written and verbal communication.
- Experience with Power BI or Excel is a plus.
- Exposure to cloud platforms like GCP, AWS, or Azure is an asset.
- Familiarity with version control, such as Git, is helpful.
- Understanding of data warehousing concepts and workflow automation tools like Power Automate or Airflow.
- Experience working with APIs or file-based data transfers like SFTP or CSV.
Location & details#
- Location: Mississauga, Ontario.
- Term: January 6, 2027, to April 16, 2027.
- Modality: Hybrid, with up to 1 day remote per week.
- Employment: Full-time paid position.
About Shoppers Drug Mart
Shoppers Drug Mart operates as a retail pharmacy chain across Canada. Founded in Toronto, the company has expanded to include over 1,200 store locations. It maintains a workforce of more than 33,000 employees. The organization focuses on health care services and retail products.
How to get in at Shoppers Drug Mart
Landing an internship at Shoppers Drug Mart requires speed because recruiters review applications as they arrive. Intern Insider sends an instant alert the moment a role matching your target is published, so you apply among the first before the pile grows. Being early in the queue helps your resume stand out to the hiring team. You can also use Intern Insider to surface the recruiters behind the company roles. Reaching out directly to ask about the role or a referral often improves your response rates compared to a standard application.
