Transportation Analyst

Granules Pharmaceuticals, Inc.; Suffolk (VA); On-site; USD 60,000 - 70,000; Full time

Job summary

Granules Pharmaceuticals, Inc. seeks a Transportation Analyst to deliver data-driven insights, cost analytics, and network optimization recommendations that improve transportation efficiency and supply chain costs.

You will partner with Logistics, Supply Chain, Procurement, and Operations to turn complex transportation data into actionable decisions. The role involves developing freight cost models, maintaining dashboards, monitoring performance, and supporting forecasting, S&OP, and continuous

Qualifications

• Advanced data analytics, statistical analysis, and cost modeling for transportation and logistics.
• Expertise in Excel, Power BI/Tableau, BI reporting, dashboards, and data visualization.
• Knowledge of TMS, SAP/ERP reporting, freight market intelligence platforms.
• SQL and/or Python for data extraction, modeling, automation, and analytics.
• Strong problem-solving, communication, stakeholder-management skills.

Responsibilities

• Build and maintain freight cost dashboards across all modes.
• Benchmark freight rates against market indices monthly.
• Perform invoice-to-contract audit analytics — identify overcharges.
• Model cost impact of network changes and consolidation opportunities.
• Own the monthly logistics performance scorecard and KPIs.
• Support S&OP with transportation capacity and cost inputs.

Skills

Advanced data analytics

Excel, Power BI/Tableau

Transportation management knowledge

SQL and Python

Communication & stakeholder management

Education

Bachelor's degree in supply chain / Industrial Engineering / Data Science / Analytics

Tools

TMS

SAP/ERP

Xeneta

DAT

FreightWaves

Job description

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

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