Transportation Analytics Lead - Cost & Carrier Insights

McKesson; Shepherdsville (KY); Hybrid; USD 89,000 - 148,000; Full time

Job summary

McKesson is seeking a highly analytical Senior Transportation Business Analyst to optimize transportation costs and drive data-informed decisions across 3PL operations. You will partner with Operations, Finance, and carrier partners to improve service, reduce costs, and strengthen client outcomes.

The role requires strong analytics, reporting, and BI skills, plus experience in freight billing, carrier performance, and pricing analytics. Hybrid work near Louisville area is available.

Qualifications

• Bachelor's degree or equivalent experience in a related field.
• 7+ years of experience in transportation analytics or related roles.
• Strong Excel, BI, and SQL skills for data analysis and reporting.
• Experience with freight auditing, billing reconciliation, and KPI reporting.

Responsibilities

• Analyze shipment profiles to optimize modes, service levels, and carrier selections.
• Reconcile carrier invoices, investigate billing discrepancies, and analyze spend.
• Build and maintain carrier scorecards and transportation KPI reporting.
• Develop cost models, lane analyses, and scenario comparisons for pricing and networks.
• Create automated Power BI dashboards and centralized transportation reporting.

Skills

Advanced Excel

Power BI dashboards

SQL

Freight auditing

KPI reporting

Analytical thinking

Communication

Education

Bachelor's degree in Business, Supply Chain, Logistics, Finance, Analytics, Data Science, or related field

Tools

TMS

SAP

WMS

Job description

McKesson is seeking a highly analytical Senior Transportation Business Analyst to optimize transportation costs and drive data-informed decisions across 3PL operations. You will partner with Operations, Finance, and carrier partners to improve service, reduce costs, and strengthen client outcomes.

The role requires strong analytics, reporting, and BI skills, plus experience in freight billing, carrier performance, and pricing analytics. Hybrid work near Louisville area is available.