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,

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.