Business Analyst (Two Open Roles)

Canadian Tire Corporation • Mississauga, ON

3d • CA$53,000 - CA$88,000

About The Position

The Transportation Ecommerce Operations Team manages the relationship between the Corporation and its Courier Partners, overseeing day-to-day operations for ecommerce last mile execution, replenishment activities, and transportation leveraging courier small parcel. The team develops and refines standard operating procedures to support daily operations and enhances Courier Capacity, aiming to build a reliable network of couriers for a great customer experience. They provide project management and subject matter expertise for key initiatives supporting the Corporation’s True North Strategy, focusing on ecommerce, courier centers of excellence, and improving courier network capacity, coverage, service levels, and cost-effectiveness. This role is for a motivated, innovative, self-directed Business Analyst who will drive process improvement initiatives, support a courier center of excellence, provide analytical support, and insights to increase courier capacity, improve service levels, reduce costs, and enhance decision-making. Responsibilities include leading data migration from SQL Server to enterprise data warehouses (e.g., IHUB), designing and implementing data integration pipelines across diverse sources (SQL Server, Oracle, IHUB, Snowflake), and ensuring data quality, governance, and consistency. The role also involves developing interactive dashboards and reporting solutions using Power BI, ThoughtSpot, and Tableau, utilizing Agile Project Management methodology, collaborating with internal and external stakeholders as a liaison and change agent, and turning large datasets into meaningful information. The Business Analyst will map current processes, simulate alternatives, build robust processes, adhere to deadlines, maintain process documentation, act as a subject matter expert for change initiatives, and participate in RFX processes and business reviews.

Requirements

• A University degree in a relevant discipline such as Computer Science, Data Science, Engineering, or Applied Mathematics.
• Proven experience in data analytics, data engineering, or data science roles.
• Proven 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.
• Transportation business knowledge.
• Experience in a Supply Chain role (CTR) with a minimum 2-4 years in a Supply Chain project or analytical role.
• 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.
• Past working experience on ecommerce (supply chain, home delivery- last mile, technology, etc.).

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.
• 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.

Benefits

• Comprehensive benefits and retirement programs
• Performance incentives
• Continuing Education Programs
• Other perks to support your well-being
• Career growth opportunities
• Product discounts
• Mental health benefits in the amount of $5,000 per year for benefits-eligible employees and their families
• Total well-being, and mental health tools and resources for all employees

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level