Senior Business Analyst, Transportation

Responsibilities Analyze shipment profiles to identify optimal transportation modes, service levels, and carrier selections Identify shipping inefficiencies, cost outliers, over-serviced shipments, and optimization opportunities Develop recommendations to improve transportation cost efficiency while maintaining service standards Reconcile carrier invoices against contracted rates, shipment data, and client billing records Investigate billing discrepancies, duplicate charges, accessorial fees, and revenue leakage opportunities Develop reporting and trend analysis on transportation spend, cost per shipment, and billing exceptions Design, maintain, and enhance carrier scorecards and transportation KPI reporting Monitor on-time delivery, tender acceptance, cost performance, claims, damage rates, and service recovery metrics Support carrier business reviews with actionable performance analytics Conduct transportation analysis supporting client pricing initiatives, RFPs, and network optimization activities Build transportation cost models, lane analyses, and scenario comparisons Provide data-driven recommendations for pricing strategies and cost-to-serve evaluations Develop and maintain dashboards, data models, and automated reporting solutions using Power BI and related analytics tools Replace manual reporting processes with scalable, automated solutions Identify opportunities to centralize transportation reporting and improve data governance Partner with Operations, Finance, Client Services, Quality, and transportation providers to address business challenges Support client reviews by translating complex transportation data into clear business recommendations Assist with transportation-related escalations through root-cause analysis and corrective action validation Requirements Bachelor's degree in Business, Supply Chain, Logistics, Finance, Analytics, Data Science, or a related field, or equivalent experience Typically 7+ years of experience in transportation analytics, logistics analytics, freight operations, supply chain analytics, or related business analysis roles Advanced Excel skills, including data analysis, modeling, and reporting Experience building dashboards and reports using Power BI SQL experience for data extraction, validation, and analysis Experience with freight auditing, transportation billing reconciliation, carrier invoicing, or accessorial analysis Working knowledge of transportation modes including Parcel, LTL, FTL, and Dedicated Fleet Experience developing KPI reporting, performance scorecards, or operational analytics Strong analytical, problem-solving, and communication skills with the ability to present insights to business stakeholders Preferred experience with Transportation Management Systems (TMS), ERP platforms (SAP or equivalent), and Warehouse Management Systems (WMS) Preferred knowledge of transportation network design, cost-to-serve modeling, and profitability analysis Preferred experience supporting transportation RFPs, pricing analysis, or commercial analytics Preferred Lean, Six Sigma, or process improvement experience Preferred experience automating reporting and business intelligence solutions Preferred knowledge of pharmaceutical, biologics, healthcare distribution, cold-chain, or temperature-sensitive logistics Preferred experience working in a 3PL, transportation, logistics, distribution, or supply chain environment Ability to participate in on-site operational reviews and cross-functional business meetings Core Competencies Demonstrates expertise in transportation analytics, including cost modeling, KPI reporting, and data-driven decision-making. Proficient in utilizing advanced analytical tools such as Power BI and SQL to enhance transportation efficiency and support business objectives. Highest-signal resume keywords Transportation Analytics Power BI Dashboard Development SQL Data Extraction Freight Auditing KPI Reporting Hard Skills Data Analysis Cost Modeling Transportation Billing Reconciliation Carrier Invoicing Performance Scorecards Lean Methodology Six Sigma Transportation Network Design Freight Operations Logistics Analytics Soft Skills Analytical Skills Problem-Solving Communication Skills Industry Keywords Supply Chain Logistics 3PL Healthcare Distribution Cold-Chain Logistics Tools & Technologies Power BI SQL Transportation Management Systems (TMS) ERP Platforms (SAP) Warehouse Management Systems (WMS) #J-18808-Ljbffr Jobtailor