Senior Associate-Procurement

Luca; San Francisco (CA); On-site; USD 11,000 - 18,000; Full time

Job summary

Luca is seeking a Procurement Analyst to own rate card governance and drive data-driven decision making from Jakarta Head Office. You will build complex Excel models, analyze large shipping datasets, and support negotiations with suppliers.

The role requires 4+ years in procurement, strong Excel expertise, and the ability to translate data into actionable insights. Occasional visits to the warehouse are expected.

Qualifications

• Bachelor’s degree in Supply Chain Management, Business Administration, Statistics, Mathematics, Economics, Engineering, or related field.
• Relevant coursework or certifications in data analytics are an advantage.

Responsibilities

• Rate Card Ownership: Build and govern lane pricing, surcharges, and service-type variations.
• Advanced Excel Modeling: Design complex models to manage thousands of lane-rate combinations.
• Big Data Analysis: Analyze large shipment and billing datasets to identify anomalies and opportunities.
• Should-Cost & Benchmarking: Develop defensible cost baselines for negotiations.
• Process Automation: Automate rate card updates and data reconciliation using Excel/Power Query.

Skills

Advanced Excel

Big Data Analysis

Negotiation

Analytical thinking

Communication skills

Attention to detail

Time management

Stakeholder management

Power BI/Tableau

SQL/Python (basics)

Education

Bachelor’s degree in SCM/Business

Data analytics coursework/certifications

Tools

Excel (PivotTables, Power Query)

Power BI/Tableau

SQL/Python basics

Job description

Job Description

• Rate Card Ownership: Build, maintain, and govern transportation rate cards covering lane-level pricing, weight breaks, surcharges (fuel, tolls, peak season), and service-type variations. Ensure rate cards are accurate, current, and version-controlled.


• Advanced Excel Modeling: Design and maintain advanced Excel models (complex nested formulas, INDEX/MATCH, SUMPRODUCT, Power Query, PivotTables) to manage, validate, and audit large rate card datasets spanning thousands of lane-rate combinations.


• Big Data Analysis: Analyze large shipment and billing datasets (volumes, weights, distances, actual vs. quoted rates) to identify billing discrepancies, cost anomalies, and optimization opportunities. Summarize findings into clear, decision-ready reports for management.


• Should-Cost & Benchmarking: Conduct should-cost analysis and market benchmarking for transportation services, translating raw market data into defensible cost baselines for negotiation.


• Process Automation: Automate recurring rate card updates and data reconciliation workflows where possible (Excel automation, Power Query, or basic scripting) to improve accuracy and efficiency.

Procurement Execution

• Purchasing Operations: Purchase logistics services and materials for transportation categories, mainly 3PL services and trucks, from PR to PO: prepare and raise purchase orders and order schedules in line with procurement SOPs.


• Negotiation Support: Support contract negotiation by preparing data-backed negotiation packs — rate comparisons, volume analyses, cost breakdowns, and savings scenarios — that strengthen the team’s commercial position with suppliers.


• Savings Validation: Track realized savings against negotiated rates, validate supplier invoices against contracted rate cards, and flag variances for recovery.

Supplier & Stakeholder Management

• Interface Role: Act as an interface between suppliers and internal departments (Operations, Finance, Logistics) on purchasing processes, new projects, and rate-related queries.


• Issue Resolution: Contact suppliers to resolve price, quality, delivery, or invoice issues. Escalate complex disputes with supporting data and root-cause analysis.


• Supplier Evaluation: Assess and evaluate suppliers and contribute to performance reviews (quality, delivery, cost, service) to ensure contract compliance and rate adherence.


• Relationship Management: Build and maintain professional, ethical, and productive relationships with suppliers, staff, and stakeholders.

Reporting & Compliance

• Prepare procurement reports and updates (spend analysis, rate movements, savings tracking, supplier performance) as required by management.


• Monitor and advise on issues that present risk or opportunity to the management, supported by data evidence.


• Adhere to company guidelines, purchasing policies, procurement SOPs, and delegated authority thresholds at all times.


• Maintain accurate and audit-ready procurement documentation,

Job Requirements

Education

• Bachelor’s degree in Supply Chain Management, Business Administration, Statistics, Mathematics, Economics, Engineering, or a related field.


• Relevant coursework or certifications in data analytics are an advantage.

Experience

• Minimum 4 years of procurement/purchasing experience, preferably in logistics transportation or third-party logistics (3PL) services.


• Demonstrated hands-on experience analyzing large datasets — shipment records, billing files, rate tables — for cost or operational insights.


• Experience maintaining or working with transportation rate cards, pricing tables, or freight tariff structures is strongly preferred.


• Exposure to e-commerce or logistics industry environments is beneficial.

Skills & Competencies

• Advanced Excel (core): Expert-level Microsoft Excel proficiency is a core requirement: advanced formulas (INDEX/MATCH, SUMPRODUCT, array formulas, IFERROR), PivotTables, Power Query, conditional formatting, and data validation. Ability to build and audit complex rate card models with accuracy.


• Big Data Analysis: Comfortable handling and analyzing large volumes of data (100k+ rows) — cleaning, reconciling, and transforming raw data into insights. Familiarity with data visualization tools (Power BI, Tableau) or basic SQL/Python is a plus.


• Commercial & Negotiation Acumen: Solid commercial instinct with the ability to support negotiations using data-driven arguments — cost breakdowns, benchmark evidence, and savings scenarios.


• Analytical and numerically astute with strong demonstrated problem-solving abilities.


• Good communication, negotiation, interpersonal, and influencing skills.


• Keen attention to detail and accuracy — critical for rate card governance and invoice validation.


• Able to manage time effectively, prioritize tasks, and achieve set targets.


• Able to work well under pressure and handle fast-paced, emergency, and changing situations.


• Able to build and maintain effective and productive relationships with staff, stakeholders, and suppliers.

Language Requirements

• English fluency (written and spoken) for working and reporting purposes.


• Mandarin fluency is an advantage.

Work Location & Others

• Based in Jakarta Head Office with occasional visit to our Warehouse is Depok 1 time per week.


• Preferable joining date: ASAP.