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

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

Benefits offered by this job

Store discounts

Triangle Learning Academy

Profit Sharing

Retirement and Savings programs

Mental health benefits

Job summary

Canadian Tire Corporation, Limited is seeking a student-focused data professional to lead data migration efforts from SQL Server to enterprise warehouses and to build scalable analytics pipelines. You will develop dashboards using Power BI, ThoughtSpot, and Tableau, while collaborating with ecommerce and supply chain teams on data-driven initiatives.

The role emphasizes Agile project management and stakeholder engagement, with opportunities for hands-on learning, training and career development

Qualifications

• Experience in data analytics, data engineering, or data science roles.
• Strong analytical and problem-solving abilities.
• Excellent verbal and written communication and presentation skills.
• Ability to manage projects and change initiatives using Agile and Waterfall methodologies.

Responsibilities

• Lead and support data migration from SQL Server to enterprise data warehouses (e.g., IHUB).
• Design and implement data integration pipelines across multiple environments.
• Develop interactive dashboards and reporting with Power BI, ThoughtSpot, and Tableau.
• Collaborate with stakeholders to drive data-driven decisions and process improvements.
• Adhere to deadlines and ensure data quality, governance, and consistency across systems.

Skills

Data analytics

Data engineering

Data science

Analytical thinking

Project management

Communication skills

Presentation skills

Education

University student in Computer Science / Data Science / Engineering / Applied Mathematics

Tools

Power BI

ThoughtSpot

Tableau

MS Excel

MS Word

MS PowerPoint

MS Access

MS Project

Visio

Job description

Our Commitment to StudentsAt 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, SnowflakeEnable 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 solutionsTurn large sets of data into meaningful informationMap current processes, determine alternative methods, create simulation models to test alternatives and build robust process working closely with multiple stakeholdersAdhere to strict deadlines in support of project implementations and solution designsContribute to the development and maintenance of sustainable process documentation that demonstrates due diligence and complianceAct as a change agent or subject matter expert for change initiativesParticipate and help make key decision in multiple RFX processes.Lead and facilitate regular business reviews and brainstorming sessionQualificationsA 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 rolesAnalytical and problem-solving skillsProject and Change Management skillsStrong written and verbal communication, as well as solid presentation skillsAdvanced user of standard desktop tools including MS Word, MS Excel, MS PowerPoint, MS Access, MS Project and VisioProven experience as liaison between multiple stakeholders.AssetsTransportation business knowledgeKnowledge of Project Management methodology and/or experience (both Agile and Waterfall)Knowledge of reporting and visualization toolsFinancial knowledgeCourier and Carrier operational knowledgeBroadband 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.#LI-CD1This 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 UsCanadian 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 BelongingWe 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.AccommodationsWe 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.