Business Analyst Student - (12 months) - Winter Term 2027

Canadian Tire Corporation; Mississauga; On-site; CAD 32,000 - 51,000; Full time

Benefits offered by this job

Store discounts

Triangle Learning Academy

Retirement and savings programs

Mental health benefits up to $5,000

Enhanced flex benefits

Job summary

Canadian Tire Corporation is seeking a university student in a relevant discipline to support data migration, integration, and analytics initiatives across SQL Server, Oracle, IHUB, and Snowden environments. The role emphasizes governance, data quality, and delivering analytics-ready data models.

The position involves building interactive dashboards with Power BI, ThoughtSpot, and Tableau, and collaborating with ecommerce and supply chain teams to drive strategic improvements.

Qualifications

• University student in CS/Data Science/Engineering/Applied Math.
• Experience in data analytics, data engineering, or data science roles.
• Analytical and problem-solving skills.
• Project and Change Management skills.
• Strong written and verbal communication, as well as solid presentation skills.
• Advanced user of MS Word, MS Excel, MS PowerPoint, MS Access, MS Project and Visio.
• Proven experience as liaison between multiple stakeholders.

Responsibilities

• Lead data migration initiatives, migrating data to enterprise data warehouses with scalable, analytics-ready models.
• Design and implement data integration pipelines across environments (SQL Server, Oracle, IHUB, Snowflake).
• Ensure data quality, governance, and cross-system data access.
• Develop and maintain dashboards using Power BI, ThoughtSpot, Tableau.
• Apply Agile project management to drive analysis, design, development, testing, and implementation.
• Collaborate with stakeholders to drive efficiencies and better decision making for the portfolio.
• Work with ecommerce teams to develop strategic processes and solutions.
• Translate large data sets into meaningful information.
• Map processes, build simulations, and document workflows with stakeholders.
• Adhere to deadlines and maintain sustainable process documentation.
• Act as a change agent for initiatives and participate in RFX processes.
• Lead and facilitate regular business reviews and brainstorming sessions.

Skills

Data analytics

Data engineering

Data science

Analytical thinking

Project management

Change management

Communication skills

MS Office

Education

University student in relevant discipline (CS/Data Science/Engineering/Applied Math)

Tools

Power BI

ThoughtSpot

Tableau

Job description

Our Commitment to Students

At Canadian Tire, we are committed to providing students with a supportive and collaborative environment that fosters knowledge sharing and offers key experiences to help them develop their capabilities through projects and objectives. We believe in setting specific and measurable goals that align with our business objectives to support learning and help students achieve their full potential. Our culture emphasizes learning from others, continuous improvement, agility, growth, and innovation, and we are invested in building a talented, diverse workforce for the future of Canada and Canadian Tire. Additionally, we are dedicated to building strong relationships with our student employees by engaging with them throughout their education and career pursuits and creating opportunities for ongoing communication and relationship building.

Our Commitment to Students

At Canadian Tire, we are committed to providing students with a supportive and collaborative environment that fosters knowledge sharing and offers key experiences to help them develop their capabilities through projects and objectives. We believe in setting specific and measurable goals that align with our business objectives to support learning and help students achieve their full potential. Our culture emphasizes learning from others, continuous improvement, agility, growth, and innovation, and we are invested in building a talented, diverse workforce for the future of Canada and Canadian Tire. Additionally, we are dedicated to building strong relationships with our student employees by engaging with them throughout their education and career pursuits and creating opportunities for ongoing communication and relationship building.

Responsibilities

• Lead and support data migration initiatives, including transitioning data from SQL Server environments to enterprise data warehouses (e.g., IHUB), ensuring scalable, reliable, and analytics-ready data models.


• Design and implement data integration pipelines across multiple environments, connecting and working with diverse data sources such as: SQL Server, Oracle, IHUB, Enterprise Data Warehouses, Snowflake


• Enable seamless access to data across platforms, ensuring data quality, governance, and consistency across systems.


• Lead and support data migration initiatives, including transitioning data from SQL Server environments to enterprise data warehouses (e.g., IHUB), ensuring scalable, reliable, and analytics-ready data models.


• Design and implement data integration pipelines across multiple environments, connecting and working with diverse data sources such as: SQL Server, Oracle, IHUB, Enterprise Data Warehouses, Snowflake.


• Enable seamless access to data across platforms, ensuring data quality, governance, and consistency across systems.


• Develop and maintain interactive dashboards and reporting solutions using tools such as: Power BI, ThoughtSpot, Tableau.


• Use of Agile Project Management methodology to lead analysis, design, development, testing, and implementation of key initiatives in support of strategic goals and objectives.


• Collaborate successfully with key stakeholders both internal and external acting as a liaison and a change agent driving efficiencies and better decision making for our portfolio.


• Work closely with multiple ecommerce teams from across the corporation and other key supply chain business teams developing strategic processes and solutions


• Turn large sets of data into meaningful information


• Map current processes, determine alternative methods, create simulation models to test alternatives and build robust process working closely with multiple stakeholders


• Adhere to strict deadlines in support of project implementations and solution designs


• Contribute to the development and maintenance of sustainable process documentation that demonstrates due diligence and compliance


• Act as a change agent or subject matter expert for change initiatives


• Participate and help make key decision in multiple RFX processes.


• Lead and facilitate regular business reviews and brainstorming session

Qualifications

• A University student in a relevant discipline such as Computer Science, Data Science, Engineering, or Applied Mathematics.


• Experience in data analytics, data engineering, or data science roles


• Analytical and problem-solving skills


• Project and Change Management skills


• Strong written and verbal communication, as well as solid presentation skills


• Advanced user of standard desktop tools including MS Word, MS Excel, MS PowerPoint, MS Access, MS Project and Visio


• Proven experience as liaison between multiple stakeholders.

Assets

• Transportation business knowledge


• Knowledge of Project Management methodology and/or experience (both Agile and Waterfall)


• Knowledge of reporting and visualization tools


• Financial knowledge


• Courier and Carrier operational knowledge

Broadband Salary Range

$23.00- $37.00.

Our typical hiring range is between $23.00 and $30.00 CAD Hourly. Salary decisions are also dependent on other factors such as your experience, job-related knowledge, skills and competencies, market location, industry benchmarks, internal equity and other role-specific requirements.

This posting represents an existing vacancy within our organization.

We may use artificial intelligence tools as part of our recruitment process to assist in the initial screening of resumes. All hiring decisions, including candidate evaluation, selection, and disposition, are made by human recruiters.

About Us

Canadian Tire Corporation, Limited (“CTC”) is one of Canada’s most admired and trusted companies. With more than 90 Owned Brands, over 1,600 retail locations, financial services, exemplary e-commerce capabilities, and exciting market-leading merchandising strategies. We dream big and work as one to innovate with purpose for our customers at every level of our business, investing in new technologies and products, and doubling down on top talent to drive the company forward. We offer competitive salaries and wages to CTC employees, as well as store discounts, supported learning through our Triangle Learning Academy, Canadian Tire Profit Sharing, and retirement and savings programs for eligible employees. As part of our enhanced flex benefits program, we offer mental health benefits in the amount of $5,000 per year for benefits-eligible employees and their families, including total well-being, and mental health tools and resources for all employees. Join us in helping to make life in Canada better through living and working our Core Values: we are innovators and entrepreneurs at our core, outcomes drive us, inclusion is a must, we are stronger together and we take personal responsibility. It is an especially exciting time to join CTC and its family of companies where career opportunities are wide-ranging! Join us, where there's a place for you here.

Our Commitment to Diversity, Inclusion and Belonging

We are committed to fostering an environment where belonging thrives, and diversity, inclusion and equity are infused into everything we do. We believe in building an organizational culture where people are consistently treated with dignity while respecting individual religion, nationality, gender, race, age, perceived ability, spoken language, sexual orientation, and identification. We are united in our purpose of being here to help make life in Canada better.

Accommodations

We stand firm in our Core Value that inclusion is a must. We welcome and encourage candidates from equity-seeking groups such as people who identify as racialized, Indigenous, 2SLGBTQIA+, women, people with disabilities, and beyond. Should you require any accommodation in applying for this role, or throughout the interview process, please make them known when contacted and we will work with you to help meet your needs.