Air Freight Spot-Quote Analyst

Caterpillar Asia Pte Ltd; Singapore; On-site; SGD 60,000 - 80,000; Full time

Job summary

Caterpillar Asia Pte Ltd is seeking a Logistics Analyst to manage end-to-end air freight forwarding spot quotes, assess rate requests, source spot pricing, and coordinate with internal stakeholders and freight forwarders for timely execution.

The role requires meticulous cost calculations, proficiency with Excel and related systems, and strong cross-functional communication across procurement, sourcing, rate-management, reporting, and operations to ensure accurate, audit-ready records.

Qualifications

• Strong analytical ability and attention to detail in rate validation and cost calculations.
• Ability to manage multiple requests, systems, and deadlines in a fast-paced environment.
• Proficiency with Excel and basic Word/Outlook/Teams for cost analysis and reporting.
• Ability to learn and navigate procurement, sourcing, rate-management, CRM, and reporting platforms.
• Clear written and verbal communication skills for cross-functional coordination.

Responsibilities

• Manage assigned air freight rate requests from intake through closure, including RFIs and time-sensitive spot requests.
• Review shipment details for completeness and accuracy including origin, destination, service level, and dates.
• Research contracted rates, routing guides, rate validity, and lane coverage to determine contract applicability.
• Validate calculations and terms against approved sources; identify missing or non-applicable rates.
• Create and maintain rate-request records across systems such as Salesforce, RateCloud, Keelvar, Power BI, and Excel.
• Prepare and issue RFIs to support planning and cost-estimate decisions with documented assumptions.
• Launch actual-move spot requests to qualified air freight forwarders and monitor responses to meet deadlines.
• Compare supplier offers for price, transit time, routing, capacity, and service levels; seek clarifications as needed.
• Calculate total move cost, normalize currencies/units, and document all assumptions.
• Provide clear quote comparisons and recommendations with total cost, routing, and risks.
• Collaborate with trade-lane teams, facilities, dealers, factories, procurement, operations, and forwarders.
• Confirm awards, obtain booking references, and update the request through final closure.
• Maintain complete documentation in accordance with process, compliance, and audit requirements.
• Track open requests, aging items, savings, and escalation of urgent/high-risk cases.
• Follow export-control, confidentiality, procurement, and reporting requirements; identify improvement opportunities.

Skills

Analytical thinking

Attention to detail

Communication skills

Time management

Prioritization

Tools

Microsoft Excel

Microsoft Word

Outlook

Microsoft Teams

Salesforce

RateCloud

Power BI

Keelvar

Job description

Caterpillar Asia Pte Ltd is seeking a Logistics Analyst to manage end-to-end air freight forwarding spot quotes, assess rate requests, source spot pricing, and coordinate with internal stakeholders and freight forwarders for timely execution.

The role requires meticulous cost calculations, proficiency with Excel and related systems, and strong cross-functional communication across procurement, sourcing, rate-management, reporting, and operations to ensure accurate, audit-ready records.