fbpx

Back

Information Technology

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

Scroll to Top