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

• 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

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.

• Transportation Analytics
• Power BI Dashboard Development
• SQL Data Extraction
• Freight Auditing
• KPI Reporting

• Data Analysis
• Cost Modeling
• Transportation Billing Reconciliation
• Carrier Invoicing
• Performance Scorecards
• Lean Methodology
• Six Sigma
• Transportation Network Design
• Freight Operations
• Logistics Analytics

• Analytical Skills
• Problem-Solving
• Communication Skills

• Supply Chain
• Logistics
• 3PL
• Healthcare Distribution
• Cold-Chain Logistics

• Power BI
• SQL
• Transportation Management Systems (TMS)
• ERP Platforms (SAP)
• Warehouse Management Systems (WMS)