Transportation Analyst

WHSmith; Las Vegas (NV); On-site; USD 68,000 - 83,000; Full time

Job summary

WHSmith Distribution Center in Las Vegas, NV is seeking a Transportation Analyst to analyze data, costs and service levels to improve the transportation network. You will build dashboards, monitor KPIs, and collaborate with internal teams and carriers to identify opportunities for efficiency and cost reduction.

The role requires 2–5 years of transportation analysis experience, advanced Excel, and familiarity with TMS and ERP systems.

Qualifications

• Bachelor’s degree in a related field or equivalent experience.
• 2-5 years of experience in transportation analysis.
• Advanced Excel skills for data modeling and analysis.
• Experience with TMS or ERP systems and performance metrics.

Responsibilities

• Analyze transportation data to identify trends, risks, and opportunities.
• Monitor KPIs: on-time delivery, cost, carrier performance, utilization.
• Develop dashboards and reports to show transportation performance.
• Provide insights and recommendations to stakeholders on actions.
• Track spend and compare actuals to budgets and forecasts.
• Support route optimization and carrier selection initiatives.

Skills

2-5 years transportation analysis

Advanced Microsoft Excel

Data analysis

Analytical thinking

Education

Bachelor’s degree in Supply Chain Management, Logistics, Business, Data Analytics, or related discipline

Tools

TMS

ERP systems

Job description

Job Title

Transportation Analyst

Location

Distribution Center - Las Vegas, NV 89118 US (Primary)

Job Type

Full-time

Category

Warehouse

Job Description

Transportation Analyst

Pay: $75,000

Location - Distribution Center - Las Vegas NV

Job Purpose

The Transportation Analyst is responsible for using data, analysis, and operational insight to improve the performance, efficiency, and cost-effectiveness of the transportation network.

The role will analyze transportation activity, costs, service levels, and operational performance to identify trends, risks, and opportunities for improvement. Working closely with internal teams, carriers, and transportation partners, the Transportation Analyst will translate data into actionable recommendations that improve service, reduce costs, and support informed business decision-making.

Key Responsibilities

Performance Analysis & Reporting

• Analyze transportation data to identify trends, inefficiencies, risks, and opportunities for improvement.
• Monitor and report on key performance indicators (KPIs), including on-time delivery, transportation cost, carrier performance, vehicle utilization, and service levels.
• Develop and maintain accurate dashboards, reports, and performance analysis to provide clear visibility of transportation performance.
• Provide regular insight and recommendations to operational and management teams, highlighting key issues, trends, and required actions.
• Track transportation spend and analyze actual costs against budgets, forecasts, and agreed targets.

Transportation Optimization

• Analyze transportation activity to identify opportunities to improve route efficiency, vehicle utilization, delivery performance, and overall network productivity.
• Identify opportunities to reduce transportation costs while maintaining or improving service levels.
• Analyze carrier performance and support the development of improvement plans where performance falls below agreed standards.
• Support the evaluation and selection of carriers and transportation solutions.
• Analyze transportation capacity and demand to support effective resource planning.
• Identify opportunities to improve transportation processes, systems, and ways of working.
• Measure the impact of improvement initiatives and ensure benefits are tracked and sustained.
• Challenge existing processes and develop data-led recommendations for more effective ways of working.
• Build effective working relationships with internal stakeholders across Transport, Distribution, Supply Chain, Finance and Operations.
• Work closely with carriers and third-party transportation providers to monitor performance and identify opportunities for improvement.
• Provide clear, concise, and commercially relevant analysis to support operational and strategic decision-making.
• Communicate performance issues and improvement opportunities clearly to relevant stakeholders.

Cost & Commercial Analysis

• Monitor transportation expenditure and identify cost-saving opportunities.
• Analyze freight rates, carrier costs, and other transportation-related expenditure.
• Investigate and resolve transportation cost variances and billing discrepancies.
• Support the development of transportation budgets and forecasts.

Job Requirements

Required Qualifications & Experience

• Bachelor’s degree in Supply Chain Management, Logistics, Business, Data Analytics, or a related discipline, or equivalent relevant experience.
• 2-5 years of experience in transportation analysis
• Advanced Microsoft Excel skills, including pivot tables, lookups, data analysis, and data modeling.
• Experience working with transportation or ERP systems, ideally including a Transportation Management System (TMS).
• Good understanding of transportation operations and key transportation performance measures.

Preferred Qualifications & Experience

• Experience in transportation network analysis, route optimization, or network design.
• Experience with using SQL to analyze datasets
• Experience with freight auditing, billing, cost analysis, and rate benchmarking.
• Data-driven decision making - Uses data and evidence to identify issues, evaluate options, and make sound recommendations.
• Analytical thinking - Able to interpret complex information, identify patterns, and determine root causes.
• Commercial awareness - Understands the relationship between transportation cost, service, capacity, and operational performance.
• Organization & prioritization - Effectively manages multiple activities and competing priorities.
• The role involves regular collaboration with Transport, Distribution, Supply Chain, Finance and other operational teams.
• The role will also involve interaction with external carriers and third-party transportation providers.
• Occasional travel may be required to Distribution Centers, operational sites, or supplier locations.