Business Analyst, Transportation Analysis and Development

Canadian Tire Corporation; Mississauga; On-site; CAD 53,000 - 88,000; Full time

Benefits offered by this job

Comprehensive benefits and retirement

Performance incentives

Continuing Education Programs

Career growth opportunities

Product discounts

Job summary

Canadian Tire Corporation invites a Business Analyst specializing in Transportation Analysis to turn operational data into actionable insights. You will partner with Transportation, Finance, Procurement, and Operations to drive cost, service, and network improvements.

You will build Power BI dashboards, models, and dashboards, leveraging SQL, Python, and automation tools. Experience with OTM, TMS, and rate management is valued; advanced Excel skills are a must.

Qualifications

• 3+ years in Transportation, Supply Chain, Logistics Analytics, or related field.
• Strong analytical and problem-solving skills with large datasets.
• Proficiency in data analytics, reporting, and automation tools (Power BI, SQL, Python, Power Query, VBA, Power Automate, Access).
• Experience with AI-enabled tech and TMS/OTM is an asset.

Responsibilities

• Develop transportation dashboards, scorecards, reporting, and models across freight spend, service, capacity, KPIs.
• Analyze carrier, mode, lane, and network data to identify trends, risks, opportunities, and savings.
• Translate data into recommendations, business cases, forecasts, and savings assessments.
• Support transportation projects, carrier RFPs, contract reviews, bid evaluations, and cost initiatives.
• Maintain transportation rates, fuel surcharges, master data, and governance; support OTM processes.

Skills

Power BI

SQL

Python

Power Query

VBA

Power Automate

Microsoft Access

Microsoft Copilot

Advanced Excel

Data analysis

Education

Bachelor's degree in Business, Logistics, or related field

Tools

Oracle Transportation Management (OTM)

JDA Transport

Rate Management System (RMT)

Transportation Management Systems (TMS)

Job description

What You'll Do

The Business Analyst, Transportation Analysis and Development supports Canadian Tire Corporation’s Transportation Operations Support and Analytics team by turning operational data into clear insights, reporting, and recommendations that improve cost, service, capacity, and network performance. This role works closely with Transportation, Finance, Procurement, Operations, carriers, and other cross‐functional partners to support rate management, reporting, RFP analysis, system governance, and continuous improvement across the transportation network.

Analytics, Reporting, and Decision Support

• Develop transportation dashboards, scorecards, reporting, and analytical models across freight spend, service, capacity, carrier performance, fuel, equipment movement, and KPIs.
• Analyze carrier, mode, lane, and network data to identify trends, risks, opportunities, and cost‐saving initiatives.
• Translate complex data into clear recommendations, business cases, executive summaries, forecasts, and savings assessments.

Transportation Operations, Sourcing, and Continuous Improvement

• Support transportation projects, carrier RFPs, contract reviews, bid evaluations, equipment planning, allocation, and freight cost initiatives.
• Partner with stakeholders to resolve issues, improve processes, reduce manual work, strengthen data quality, and support proactive decisions.

Rate Management, Systems, and Data Governance

• Maintain transportation rates, fuel surcharge programs, accessorial charges, master data, and related governance to support compliance and financial accuracy.
• Support Oracle Transportation Management (OTM) processes, carrier onboarding, rate maintenance, data governance, and system‐related issue resolution.
• Maintain documentation and process discipline to support reliable reporting, controls, cross‐training, and continuity.

Automation, Tools, and Technology

• Develop Power BI dashboards, reporting tools, and visualizations that improve visibility into transportation performance, cost, and service.
• Use SQL, Power BI, Power Automate, Python, Power Query, AI tools, or similar technologies to extract, validate, analyze, and automate data.

Stakeholder Partnership and Communication

• Build effective relationships across Transportation, Finance, Procurement, Planning, IT, Domestic Transportation, Vancouver Operations, Network Management, Transportation Assets, carriers, and partners.
• Act as a liaison between business and technical teams, communicating findings clearly for operational, technical, and leadership audiences.

What You Bring

• 3+ years of experience in Transportation, Supply Chain, Logistics Analytics, Business Analytics, Procurement Analytics, Operations Support, or a related field; Retail, Distribution, Transportation, or 3PL experience is an asset.
• Strong analytical and problem‐solving skills, with experience working with large datasets and translating findings into business recommendations.
• Proficiency in data analytics, reporting, and automation tools, including Power BI, SQL, Python, Power Query, VBA, Power Automate, and Microsoft Access. Experience with AI‐enabled technologies such as Microsoft Copilot and transportation or supply chain systems, including Oracle Transportation Management (OTM), JDA Transport, Rate Management System (RMT), or Transportation Management Systems (TMS), is considered an asset.
• Advanced Excel skills, including data modelling, scenario analysis, financial analysis, and validation.
• Exposure to Transportation Operations, Carrier Management, Freight Costing, Sourcing, Network Optimization, or Logistics Operations.
• Post‐secondary education or equivalent experience in Business, Supply Chain, Logistics, Commerce, Finance, Engineering, Mathematics, Economics, Analytics, Computer Science, or a related field.
• Clear communicator and strong team player with storytelling, stakeholder management, prioritization, ownership, collaboration, attention to detail, and the ability to deliver time‐sensitive analysis.

We’re always looking for great talent! In addition to competitive pay, we offer:

• Comprehensive benefits and retirement programs
• Performance incentives, Continuing Education Programs
• Other perks to support your well‐being
• Career growth opportunities and product discounts

Boadband Salary Range :$53,000.00 and $88,000.00 per annum.

Our typical hiring range is between $65,000.00 and $70,000.00 per annum. 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 racialised, 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.