Transportation Analyst - Freight Payments

Ultimate Staffing; Fountain Valley (CA); On-site; USD 48,000 - 55,000; Full time

Job summary

Ultimate Staffing in Fountain Valley, CA seeks a Transportation Analyst - Freight Payments (Long-Term Temp) to administer weekly freight payment processing for inbound and outbound shipments. The role collaborates with freight payment vendors and Finance to ensure accurate cost processing, variance resolution, and timely reporting across logistics and finance.

Ideal candidates have 5+ years in logistics or transportation with freight bill auditing, carrier management, analytics, and strong

Qualifications

• Bachelor's degree or equivalent relevant experience.
• Minimum 5 years of experience in logistics or transportation, including freight bill auditing, carrier management, and related operations.
• 5 years of analytics experience within logistics or transportation industries.
• 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 with Finance.
• Analyze freight payment data; research and resolve variances.
• Maintain monthly landed cost reporting and update rates in AMOS.
• Pull and report freight data using Access and SQL queries.
• Provide ad hoc reports and cost analyses for management and HQ (Seoul).
• Backup Transportation Analyst support for scheduling as needed.

Skills

Microsoft Word

Microsoft Excel

Analytical skills

Attention to detail

Communication

Education

Bachelor's degree or equivalent relevant experience

Tools

Access

SQL

Job description

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

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

• Bachelor's degree or equivalent relevant experience

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
• Work in a collaborative, data‑driven logistics environment
• Gain exposure to complex transportation and freight payment operations
• Long‑term temporary role with meaningful responsibility and visibility

All qualified applicants will receive consideration for employment without regard to race, color, national origin, age, ancestry, religion, sex, sexual orientation, gender identity, gender expression, marital status, disability, medical condition, genetic information, pregnancy, or military or veteran status. We consider all qualified applicants, including those with criminal histories, in a manner consistent with state and local laws, including the California Fair Chance Act, City of Los Angeles' Fair Chance Initiative for Hiring Ordinance, Los Angeles County Fair Chance Ordinance, and San Francisco Fair Chance Ordinance.