Job Requirements 3+ years of supply chain or freight experience. Proficient in Microsoft Excel and data‑analysis applications. Canadian citizen or permanent resident. Job Responsibilities Develop rates and pricing in cost models and templates. Ensure rate accuracy in UFOS – TMS as per customer contracts. Manage RFQs and develop freight rate packages for new business development and current customers. Perform timely and accurate preparation of cost estimates and profitability analysis on various products and services offered by the company. Complete costing of all accounts to ensure customer profitability and volume analysis as required. Audit rates in the system to ensure up‑to‑date billing accuracy. Maintain database of all interline/partner rates, assist operations in determining best fit based on cost and service. Provide management with reports specifying and comparing factors affecting prices and profitability of products or services. Assist rates team with spot quotes. Maintain all tariff agreements and terms & conditions. Perform other tasks as may be assigned periodically. Technical Skills Proficiency with computers, ability to work in most Windows applications, especially Microsoft Office. Technical knowledge of industry trends that may create opportunities and challenges. SQL Server: joins, subqueries, indexing. Microsoft Excel: advanced functions, INDEX‑MATCH, IF statements, pivot tables, VLOOKUP, HLOOKUP, VBA. Microsoft Access: extract, transform, and load data into Microsoft Access for analysis and reporting. Data visualization: Tableau, Power BI, DAX formulas, reporting and dashboard development, data storytelling. Transportation & logistics: carrier sourcing, LTL & full truckload logistics. Data management & analytics: market research, web analytics, Siebel, Salesforce, search engine optimization, stakeholder management. Soft skills: strategic thinking, communication, stakeholder engagement, time management, problem solving. #J-18808-Ljbffr
Transportation Pricing Analyst
ITN LOGISTICS
mississauga, mississauga
Published 21 days ago
Report job