Transportation Analyst

The Transportation Analyst "Logistics Analytics & Optimization Analyst" is responsible for delivering data-driven insights, cost analytics, and network optimization recommendations that improve transportation efficiency, service performance, and overall supply chain costs. This role serves as a strategic partner to Logistics, Supply Chain, Procurement, and Operations teams by transforming complex transportation and distribution data into actionable business decisions. The analyst will develop freight cost models, monitor logistics performance, identify optimization opportunities across inbound and outbound transportation networks, and support forecasting, S&OP, and continuous improvement initiatives. Through advanced analytics and business intelligence tools, this position drives operational excellence, enhances visibility across the logistics network, and supports the achievement of cost, service, and efficiency objectives.

Principle Accountabilities

JOB DUTIES & RESPONSIBILITIES
Responsibilities

Cost Analytics:

Build and maintain freight cost dashboards across all modes (ocean, air, FTL, LTL, parcel, drayage)
Benchmark freight rates against market indices (DAT, Xeneta, Freightos) monthly
Perform invoice-to-contract audit analytics — identify systematic overcharges
Model cost impact of network changes (e.g., NDC consolidation, mode shifts)
Support RACI by flagging spend outside contracted thresholds in near real-time
Network Optimization:

Continuously model DC network configuration — analyze Memphis/Manassas/NJ split vs. NDC flows
Identify LTL-to-FTL consolidation opportunities by lane and frequency
Analyze parcel vs. LTL threshold optimization by customer/zone
Model air-to-ocean shift opportunities on inbound freight
Evaluate DC bypass opportunities (direct from NDC to wholesaler)
·

Reporting & KPIs:

Own the monthly logistics performance scorecard
Build carrier performance analytics for QBRs
Provide freight forecasting models aligned with commercial forecast
Report on demurrage/detention trends and cost drivers
Support S&OP process with transportation capacity and cost inputs
Tracking Key Metrics
Freight cost per pallet (all modes)
Cost per container (ocean & air)
Network cost vs. benchmark
Optimizations savings identified vs realized
Freight forecast accuracy
Lead change through innovative thinking and active use of packaging improvement tools and techniques.
Management Responsibility

N/A

Reports to

Director, Logistics

Internal/External Contacts

Works with internal stakeholders and service providers as per business

Requirements

Knowledge & Skills

Advanced data analytics, statistical analysis, cost modeling, and financial evaluation of transportation and logistics operations.
Expertise in Microsoft Excel, Power BI/Tableau, business intelligence reporting, dashboard development, and data visualization.
Knowledge of transportation management, freight cost analysis, carrier performance measurement, logistics network optimization, and supply chain processes.
Experience with TMS, SAP/ERP reporting systems, freight market intelligence platforms (Xeneta, DAT, FreightWaves), and logistics data management.
Proficiency in SQL and/or Python for data extraction, modeling, automation, and advanced analytics.
Strong problem-solving, communication, stakeholder management, and continuous improvement skills with the ability to translate data into actionable business recommendations.
Experience & Education

Bachelor’s degree in supply chain, Industrial Engineering, Data Science, or Analytics
2–5 years supply chain or logistics analytics experience
Strong quantitative and data visualization skills
TMS and ERP reporting experience
Pharma industry experience a plus
We believe in fair and transparent pay practices. Actual compensation is determined based on relevant experience, qualifications, skills, and internal equity.

Salary Description
$60,000 - $70,000/ Yearly