Planning Coordinator - Operations, Middle Mile, SPX Express (Bustos, Bulacan)

SPX PHILIPPINES INC.; Manila; On-site; PHP 360,000 - 600,000; Full time

Job summary

Shopee Philippines is seeking a Middle Mile Planner to manage the truck network moving parcels from Sorting Centers to Regional Centers and delivery hubs across the country.

You will forecast daily and weekly truck needs, coordinate departures with warehouses, manage 3PL vendors, optimize load space, and prepare for peak seasons like 9.9, 11.11, and 12.12. Strong Excel/Sheets and SQL/Tableau skills are essential.

Qualifications

• Bachelor’s degree in Industrial Engineering, Supply Chain, Logistics, or a related field.
• At least 2 years of experience in truck routing, fleet operations, or logistics planning (e-commerce or express courier experience is a big plus).
• Proficient in Microsoft Excel or Google Sheets (vlookups, index/match, pivot tables); SQL or Tableau a plus.

Responsibilities

• Truck Capacity Planning: Create daily and weekly plans to forecast how many trucks we need based on incoming parcel volumes.
• Schedule Coordination (Ops Clock): Line up truck departure times with sorting schedules to prevent idle parcels.
• Vendor Management: Follow up with 3PLs to ensure promised trucks arrive on time.
• Load Optimization: Monitor truck space to avoid half-empty trucks and map backloads to reduce empty returns.
• Peak Season Preparation: Plan extra truck supply and backup routes for major sales (9.9, 11.11, 12.12).
• Performance Tracking: Build/update sheets to report costs, delays, and utilization.

Skills

Excel

Google Sheets

VLOOKUP

Index/Match

Pivot Tables

SQL

Tableau

Education

Bachelor’s degree in Industrial Engineering, Supply Chain, Logistics, or related field

Tools

SQL

Tableau

Job description

The Operation teams at Shopee covers the operational end-to-end process, from when the buyer searches for a product listed on the Shopee platform, to the moment the buyer receives the products. The team analyzes and monitors operational KPIs across the region and conducts root cause analysis when operation performance fluctuates. The Operations team comprises Customer Service, Payment, Listings, Warehouse, Logistics, Seller Operations and Fraud.

About the Team:

As a Middle Mile Planner, you will manage the truck network that moves parcels from our major Sorting Centers (SOC) to Regional Centers (RC) and delivery hubs across the Philippines. Your main goal is to make sure we have enough trucks ready to handle daily parcel volumes, keep our delivery times fast, and keep transport costs low.

Job Description:

• Truck Capacity Planning: Create daily and weekly plans to forecast how many trucks we need based on incoming Shopee parcel volumes.
• Schedule Coordination (Ops Clock): Work with warehouse teams to line up truck departure times with their sorting schedules, ensuring parcels don't sit idle.
• Vendor Management: Follow up with third-party trucking companies (3PLs) to ensure they send the number of trucks they promised and arrive on time.
• Load Optimization: Monitor truck space (cube utilization) so we aren't paying for half-empty trucks, and map out backloads to avoid empty return trips.
• Peak Season Preparation: Plan out extra truck supply and backup routes ahead of major e-commerce sales (like 9.9, 11.11, and 12.12).
• Performance Tracking: Build and update tracking sheets to report on costs, late departures, and truck utilization to management.

Requirements:

• Bachelor’s degree in Industrial Engineering, Supply Chain, Logistics, or a related field.
• At least 2 years of experience in truck routing, fleet operations, or logistics planning (e-commerce or express courier experience is a big plus).
• You must be highly proficient in Microsoft Excel or Google Sheets (vlookups, index/match, pivot tables) to handle daily data. Experience with SQL or Tableau is a plus.
• Good communication skills to deal with stakeholders, and the ability to solve problems quickly