Transportation Pricing Analyst

Job Requirements:We are looking for candidates with 3 + years of supply chain or freight experience.Proficient in Microsoft Excel and Data Analysis based applications.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.