Transportation Pricing Analyst

Job Requirement:

• We are looking for candidates with 3 + years of supply chain or freight experience.
• Proficient in Microsoft Excel and Data Analysis based applications.
• The candidate should be Canadian Citizen or a 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.
• Maintaining all tariff agreements and terms & conditions.
• Perform other tasks as may be assigned periodically.

KNOWLEDGE AND SKILLS REQUIRED:

Technical Skills:

• Proficiency with computers, ability to work in most Windows applications, especially Microsoft Office.
• Technical knowledge of the industry trends as they might create opportunities and challenges.
• SQL Server: Joins, Subqueries, Indexing.
• Microsoft Excel: Advanced Functions, INDEX-MATCH, IF Statements, Pivot Tables, VLOOKUP, HLOOKUP, VBA.
• Microsoft Access: Extracted, transformed, and loaded (ETL) 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 (SEO), Stakeholder Management.
• Soft Skills: Strategic Thinking, Communication, Stakeholder Engagement, Time Management, Problem Solving.

ITN/SCAN takes your business personally. We deliver fast, seamless solutions by building our business on five pillars – commitment, flexibility, trust, reliability, and passion, supported by our belief in taking your business personally. Tailoring solutions that meet your specific needs is what sets us apart, and it’s how we constantly exceed your expectations. ITN/SCAN LOGISTICS is Canadian based – with worldwide connections. Each component of the Group has a focus on a logistics specialty. We provide our customers with integrated combinations of all elements of the international import and export logistics process. Air and Sea Freight Forwarding – Worldwide Industrial Project Management – Worldwide Transborder Transportation – USA CANADA MÉXICO, Warehouse and Distribution Services, Enhanced Logistics Services, Intermodal Transportation. Our personnel have extensive industry experience and are well qualified to assist our clients with the many details associated with international trade. We strive to anticipate the needs of our customers and to create efficient and economical solutions based on their unique needs. ITN/SCAN operates its own import and export consolidation system between Canada and many international commercial markets. Therefore we have a direct involvement in the routing, status and location of goods as they move through the supply-chain process.