Senior Associate-Procurement

Lazada Group; Jakarta Pusat; In loco; IDR 120.000.000 - 260.000.000; Tempo pieno

Descrizione del lavoro

Lazada Group in Jakarta is seeking a Rate Card Management & Data Analytics professional to own rate cards, analyze large datasets, and support procurement operations.

You will collaborate with Operations, Finance, and Logistics to ensure accurate pricing, cost control, and compliant procurement processes.

Competenze

• Bachelor's degree in SCM or related field.
• 4+ years of procurement/purchasing experience in logistics/3PL.
• Experience with rate cards and tariff structures.
• Experience analyzing large datasets for cost insights.
• Experience with Excel models and data reconciliation.

Mansioni

• Rate Card Management: build and govern lane-level pricing and surcharges.
• Procurement Execution: raise POs, support supplier negotiations, track savings.
• Supplier & Stakeholder Management: interface between suppliers and internal teams; resolve issues.
• Reporting & Compliance: produce spend analyses and ensure SOP adherence.

Conoscenze

Advanced Excel

Big Data Analysis

Negotiation

Analytical skills

Communication

Attention to detail

Time management

Stakeholder relations

Formazione

Bachelor's degree in Supply Chain Management

Data analytics certifications (advantage)

Strumenti

Power Query

PivotTables

SQL

Python

Power BI

Descrizione del lavoro

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.