Transportation Analyst

Ultimate Staffing Services; Fountain Valley (CA); On-site; USD 100,289,000 - 114,616,000; Full time

Job summary

Ultimate Staffing Services in Fountain Valley, CA is seeking a Transportation Analyst – Freight Payments for a long-term temp assignment. The role focuses on weekly freight payment processing, variance resolution, and reporting for inbound/outbound shipments, with collaboration across Finance and Logistics.

The position requires 5+ years in logistics analytics, expertise with SQL/Access, and strong attention to detail.

Qualifications

• 5+ years analytics experience in logistics or transportation.
• 5 years of experience in logistics or transportation functions including freight bill auditing and carrier management.
• Automotive industry experience strongly preferred.

Responsibilities

• Process weekly freight payment files for inbound and outbound shipments using internal workflows.
• Create weekly check requests for freight bills in coordination with Finance.
• Analyze freight payment data; research and resolve payment variances.
• Maintain pending WebRes lines at or below targets.
• Communicate discrepancies to freight payment vendors and coordinate corrections.
• Audit and report international and domestic accessorial charges on a weekly/monthly basis.
• Administer monthly Inbound Landed Cost reporting and update LDC rates in AMOS.
• Assign appropriate GL accounts to freight payment transactions.
• Pull, analyze, and report freight payment data using Access/SQL.
• Provide ad hoc reports and cost analyses for management and HQ (Seoul).
• Backup Transportation Analyst support for FTL scheduling as needed.
• Identify and support improvements to freight payment/data processes.

Skills

Microsoft Word

Microsoft Excel

SQL

Access

Analytical skills

Attention to detail

Communication skills

Tools

Access

SQL

Job description

Transportation Analyst (JN -092025-404978) Fountain Valley, California

Salary: USD35 - USD40 per hour

Job Title: Transportation Analyst – Freight Payments (Long-Term Temp)

Location: Fountain Valley, CA (In Office)

Schedule: Monday to Friday, 8 AM - 5 PM

Pay: $35-$40 per hour

Job Purpose

The Transportation Analyst – Freight Payments is responsible for administering weekly freight payment processing for inbound and outbound transportation. This role works closely with freight payment vendors and internal systems to ensure accurate cost processing, variance resolution, and timely reporting across logistics and finance. This position also serves as a subject matter expert (SME) on freight payment issues while supporting ad hoc analysis and continuous process improvement.

Key Responsibilities

• Process weekly freight payment files for inbound and outbound shipments using customized internal workflows
• Create weekly check requests for freight bills in coordination with Finance
• Analyze VTM/WebRes freight payment data; research and resolve payment variances
• Maintain pending WebRes lines at or below departmental targets
• Communicate discrepancies to freight payment vendors and coordinate corrections
• Audit and report international and domestic accessorial charges on a weekly and monthly basis
• Administer monthly Inbound Landed Cost (LDC) reporting and update LDC rates in AMOS
• Assign appropriate GL accounts to freight payment transactions
• Pull, analyze, and report freight payment data using Access databases and SQL queries
• Provide ad hoc reports, cost studies, and analysis for management and company HQ (Seoul)
• Backup Transportation Analyst support for FTL truckload scheduling as needed
• Identify and support improvements to internal freight payment and data processes
• Complete required MPA Academy training annually

Additional Responsibilities

• Weekly freight payment processing and check requests (Inbound/Outbound) – 30%
• Carrier issue investigation, variance resolution, and freight research – 30%
• Monthly landed cost reporting and inbound freight reporting – 20%
• International and domestic accessorial fee reporting - 10%
• Required training completion - 10%

Required Qualifications

Education

Experience

• Minimum 5 years of experience in logistics or transportation functions, including:
  • Freight bill auditing
  • Freight rates and carrier management (sea, air, and land)
  • Logistics, traffic, parts warehouse, or accounting operations
• 4-5 years of general logistics operations experience required
• Automotive industry experience strongly preferred
• 5 years of analytics experience within logistics or transportation industries required

Skills

• Intermediate proficiency in Microsoft Word and Excel
• Experience working with relational databases (Access, SQL)
• Strong analytical and problem-solving skills
• Ability to work with limited standardization in a fast-paced environment
• Strong attention to detail and communication skills

Why Join This Team?

• Be part of a global automotive technology leader
• Gain exposure to complex transportation and freight payment operations
• Long-term temporary role with meaningful responsibility and visibility