Senior Planning Analyst – Technical Specialist
JOB DESCRIPTION
Financial Planning & Forecasting
- Develop and maintain Merchandise Financial Plans (MFP), WSSI and seasonal budgets
- Own and manage OTB calculations and inventory forecasting models
- Deliver monthly reforecasts with clear variance analysis and risk identification
- Monitor trading performance versus budget and prior year
- Support margin optimisation and markdown modelling
Advanced Excel & Financial Modelling (Critical Requirement)
This role requires a technically advanced Excel practitioner capable of building and maintaining highly complex financial models from first principles.
Responsibilities include:
- Designing structured, scalable planning frameworks with clear architecture
- Building complex spreadsheets capable of handling large data sets
- Developing automated OTB trackers and dynamic forecasting tools
- Creating scenario and sensitivity models to support trading decisions
- Ensuring clean documentation, version control and strong audit discipline
- Continuously improving reporting efficiency and model integrity
Required technical capability:
- Advanced nested formulas
- XLOOKUP / INDEX-MATCH / SUMIFS / OFFSET / array formulas
- Advanced pivot tables and structured data modelling
- Logical file architecture with clear separation of inputs, calculations and outputs
- Power Query (preferred)
- Macro capability (highly regarded)
- Strong governance and documentation standards
The successful candidate must demonstrate the ability to build clean, accurate and auditable financial models that can be relied upon by senior stakeholders.
Inventory & Stock Optimisation
- Analyse sales, margin and sell-through trends
- Maintain optimal stock levels across channels
- Support replenishment and allocation modelling
- Identify stock risks and recommend corrective action
- Assist with stock turn and aged inventory management
Reporting & Commercial Support
- Prepare accurate weekly and monthly reporting packs
- Deliver structured, insight-led analysis to onshore stakeholders
- Proactively highlight risks and opportunities
- Support executive-level planning requirements
REQUIREMENTS
This role is suited to a technically advanced planning professional who takes pride in building structured, scalable and highly accurate financial models.
The ideal candidate is disciplined, detail-oriented and process-driven, with a strong preference for precision over ambiguity. They are calm under pressure, methodical in approach and hold high standards around data integrity and file governance.
This is not a role for a commercially creative planner seeking category ownership. It is a specialist position focused on technical excellence, governance and infrastructure stability.
The successful candidate will demonstrate:
- Advanced and highly technical Excel capability
- Structured and methodical working style
- Strong governance discipline and version control standards
- Exceptional attention to detail
- High accountability for data accuracy
- Clear and confident communication in English
Experience & Qualifications
- 6+ years’ experience in Merchandise Planning, Financial Planning or Retail Planning
- Proven experience managing full MFP / WSSI cycles
- Demonstrated experience building complex Excel-based financial models
- Strong financial and numeracy acumen
- Experience working in remote or offshore support environments preferred
- ERP planning system experience
- BI tools exposure (Power BI, Tableau) desirable
INTERVIEW PROCESS: 2–3 online rounds
JOB LOCATION: Fulltime office/hybrid/remote working
- Office location: IPC Tower, 1489 Nguyen Van Linh, Tan Hung Ward, HCMC (opposite SC Vivo City, District 7)
WHAT WE OFFER
- Competitive salary with 13th-month bonus
- 100% salary during probation
- Fully paid for Social Insurance & PVI Health Insurance, yearly health check
- Tech gear provided
- 12-15 days of annual leave
- Onsite training opportunities in Australia