Senior Associate-Procurement

Lazada Group; Indonesia; On-site; IDR 1,080,886,000 - 1,621,329,000; Full time

Job summary

Lazada Group in Jakarta is seeking a Rate Card Management & Data Analytics professional to own lane pricing, surcharges, and service-type variations, ensuring accuracy and version control. You will design advanced Excel models, analyze large shipment and billing data, and produce decision-ready reports for management while benchmarking should-cost for negotiations.

The role sits in Jakarta Head Office with occasional visits to the warehouse.

Qualifications

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

Responsibilities

• Rate Card Ownership: Build, maintain, and govern transportation rate cards including lane-level pricing, surcharges, and service-type variations.
• Advanced Excel Modeling: Design and maintain complex Excel models to manage rate card datasets.
• Big Data Analysis: Analyze large shipment and billing datasets to identify discrepancies, cost anomalies, and optimization opportunities; summarize findings for management.
• Should-Cost & Benchmarking: Conduct should-cost analyses and market benchmarking for transportation services to establish defensible baselines for negotiation.
• Process Automation: Automate rate card updates and data reconciliation workflows to improve accuracy and efficiency.

Skills

Advanced Excel

Big Data Analysis

Negotiation analytics

Attention to detail

Communication & influencing

Time management

Pressure handling

Relationship building

Education

Bachelor’s degree in Supply Chain Management / related field

Tools

Power BI

Tableau

SQL

Python

Job description

Rate Card Management & Data Analytics

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