Senior Associate-Procurement

Lazada; Jakarta Pusat; On-site; IDR 180,000,000 - 300,000,000; Full time

Job summary

Lazada is seeking a Rate Card Management & Data Analytics professional to lead rate card governance, Excel modeling, and large-scale data analytics. The role supports procurement, pricing strategy, and supplier negotiations from the Jakarta head office with occasional field visits to logistics hubs.

You will build robust rate cards, validate data quality, and drive cost optimization through data-driven insights and cross-functional collaboration with Operations, Finance, and Logistics teams.

Qualifications

• Bachelor’s degree in Supply Chain Management or related field.
• Experience analyzing large datasets, 4+ years in procurement/logistics.
• Experience with rate cards, pricing tables or freight tariffs preferred.

Responsibilities

• Build, maintain, and govern transportation rate cards.
• Analyze large shipment and billing datasets to identify cost savings.
• Prepare data-backed negotiation packs for suppliers.
• Interface with Operations, Finance, Logistics on purchasing processes.
• Prepare procurement reports and monitor risk or opportunities.

Skills

Advanced Excel

Big Data Analysis

Negotiation Skills

Analytical Thinking

Communication Skills

Education

Bachelor's degree in Supply Chain Management

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.