Transportation Analyst

Logistics Analytics & Optimization AnalystThe 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.Job Duties & ResponsibilitiesResponsibilitiesCost 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) monthlyPerform invoice-to-contract audit analytics — identify systematic overchargesModel cost impact of network changes (e.g., NDC consolidation, mode shifts)Support RACI by flagging spend outside contracted thresholds in near real-timeNetwork Optimization:Continuously model DC network configuration — analyze Memphis/Manassas/NJ split vs. NDC flowsIdentify LTL-to-FTL consolidation opportunities by lane and frequencyAnalyze parcel vs. LTL threshold optimization by customer/zoneModel air-to-ocean shift opportunities on inbound freightEvaluate DC bypass opportunities (direct from NDC to wholesaler)Reporting & KPIs:Own the monthly logistics performance scorecardBuild carrier performance analytics for QBRsProvide freight forecasting models aligned with commercial forecastReport on demurrage/detention trends and cost driversSupport S&OP process with transportation capacity and cost inputsTracking Key MetricsFreight cost per pallet (all modes)Cost per container (ocean & air)Network cost vs. benchmarkOptimizations savings identified vs realizedFreight forecast accuracyLead change through innovative thinking and active use of packaging improvement tools and techniques.Management ResponsibilityN/AReports to Director, LogisticsInternal/External ContactsWorks with internal stakeholders and service providers as per businessRequirementsKnowledge & SkillsAdvanced 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 & EducationBachelor's degree in supply chain, Industrial Engineering, Data Science, or Analytics2–5 years supply chain or logistics analytics experienceStrong quantitative and data visualization skillsTMS and ERP reporting experiencePharma industry experience a plusWe believe in fair and transparent pay practices. Actual compensation is determined based on relevant experience, qualifications, skills, and internal equity.