Freight Payments Analyst — Data-Driven Logistics

Ultimate Staffing; Fountain Valley (CA); Sur place; USD 48 000 - 55 000; Plein temps

Résumé du poste

Ultimate Staffing is seeking a Transportation Analyst - Freight Payments in Fountain Valley, CA, to manage weekly freight payment processing for inbound and outbound shipments. The role requires strong Excel/SQL skills and extensive analytics experience in logistics, in-office, Monday–Friday, $35–$40/hour.

Responsibilities include variance resolution, data reporting, and collaboration with Finance and vendors. Automotive logistics background preferred. Long-term temp with growth potential.

Qualifications

• Bachelor's degree or equivalent relevant experience.
• 5 years of experience in logistics or transportation functions, including freight bill auditing, freight rates and carrier management, and related operations.
• 5 years of analytics experience within logistics or transportation industries.

Responsabilités

• 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.

Connaissances

Excel

SQL/Access

Analytical skills

Attention to detail

Communication

Formation

Bachelor's degree or equivalent relevant experience

Outils

Access

SQL

Description du poste

Ultimate Staffing is seeking a Transportation Analyst - Freight Payments in Fountain Valley, CA, to manage weekly freight payment processing for inbound and outbound shipments. The role requires strong Excel/SQL skills and extensive analytics experience in logistics, in-office, Monday–Friday, $35–$40/hour.

Responsibilities include variance resolution, data reporting, and collaboration with Finance and vendors. Automotive logistics background preferred. Long-term temp with growth potential.