Business Analyst, Transportation Analysis and Development
Core
Transform operational transportation data into insights, reporting, and recommendations to optimize cost, service, capacity, and network performance for Canadian Tire Corporation.
Role type
Business Analyst (Transportation Analytics & Operations)
Builds
Transportation dashboards, scorecards, analytical models, and business cases for freight spend, service, and carrier performance.
Domain
Retail / Transportation / Supply Chain
Deliverable
dashboards & analysis
Required skills
Data analytics, SQL, Power BI, Python, Power Query, VBA, Advanced Excel, Data modeling, Scenario analysis, Financial analysis, Carrier management, Network optimization, Rate management, System governance
Preferred skills
AI-enabled tools (Microsoft Copilot), Oracle Transportation Management (OTM), JDA Transport, Rate Management System (RMT), Transportation Management Systems (TMS), Retail/Distribution/3PL experience
Technologies
Power BI, SQL, Python, Power Query, VBA, Power Automate, Microsoft Access, Oracle Transportation Management (OTM), JDA Transport, Rate Management System (RMT)
Responsibilities
Develop transportation dashboards and analytical models; Analyze carrier, mode, lane, and network data to identify trends and cost-saving initiatives; Support transportation projects, carrier RFPs, and contract reviews; Maintain transportation rates, fuel surcharge programs, and master data; Partner with stakeholders to resolve issues and improve processes; Act as a liaison between business and technical teams.
Seniority
Mid-level, hands-on IC
