Freight Analyst
Agilent Technologies
full-time
Posted on:
Location Type: Office
Location: Memphis • Tennessee • Texas • United States
Visit company websiteExplore more
Salary
💰 $80,800 - $126,250 per year
About the role
- Perform advanced quantitative analysis on large freight and transportation data sets to identify cost-saving and optimization opportunities.
- Analyze and benchmark transportation carrier freight rates across multiple shipping modes (LTL, FTL, parcel, intermodal, ocean, air).
- Develop financial models and business cases to support carrier sourcing decisions, RFP events, and contract negotiations.
- Forecast, manage, and monitor freight budgets; proactively identify risks, cost drivers, and trends.
- Translate complex data into clear insights and executive-ready reporting to influence transportation strategy.
- Maintain and optimize SAP transportation routes, condition tables, and master data (e.g., PWeaver or equivalent).
- Leverage advanced Excel (Power Query, Pivot Tables, advanced formulas), Power BI, and other analytical tools to build dashboards and automated reporting solutions.
- Generate KPI reporting for freight spend, carrier performance, and network efficiency.
- Partner with Freight Audit & Pay to resolve complex data discrepancies and systemic issues.
- Lead and support cross-functional transportation optimization projects.
- Identify process gaps through data analysis and recommend scalable solutions.
- Maintain awareness of transportation market trends, cost structures, and capacity dynamics to proactively guide decision-making.
Requirements
- Bachelor’s degree from an accredited institution in Business, Supply Chain, Logistics, Finance, Engineering, or related analytical discipline (required).
- 4+ years of experience in transportation analytics, freight analysis, supply chain analytics, or related strategic analytical role.
- Demonstrated advanced proficiency in Excel (complex formulas, data modeling, pivot tables, large data manipulation).
- Experience working with large data sets and performing advanced quantitative analysis.
- Experience using SAP (transportation, logistics, or finance modules).
- Proven ability to develop data-backed business cases and drive measurable logistics savings.
- Strong written and verbal communication skills with the ability to present complex analysis clearly to stakeholders at multiple levels.
Benefits
- Health insurance
- 401(k) matching
- Paid time off
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
quantitative analysisfinancial modelingdata analysisKPI reportingdata manipulationcost-saving analysisoptimizationforecastingcontract negotiationprocess improvement
Soft Skills
communicationstakeholder engagementproblem-solvingleadershipcross-functional collaborationanalytical thinkingpresentation skillsstrategic thinkinginfluencingrisk management