- Salary
- C$70k – C$80k/yr
- Location
- Mississauga, Ontario, CA
- Type
- Full-time
- Department
- Transportation
- Source
- BetterTeam
Description
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.
- 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.
Skills
ETLExcelSalesforceTableauPower BISEO
