Merchandise Financial Planner

RPG Commerce; Selangor; On-site; MYR 150,000 - 200,000; Full time

Job summary

A leading direct-to-consumer e-commerce company in Selangor is seeking a Merchandise Financial Planner. This role involves developing financial frameworks to support merchandising strategies, managing budgets, and conducting performance analysis. Candidates should have a minimum of 7 years in financial planning within retail and possess strong analytical skills along with advanced Excel proficiency. The position fosters collaboration with multiple teams to ensure alignment with corporate goals, contributing to the company's growth and success.

Qualifications

• Minimum 7 years of experience in financial planning & analysis, merchandise financial planning, or commercial finance.
• Strong command of retail metrics: sales, margin, markdown, GMROI, stock turn.
• Experience managing OTB, forecasting cycles, and cross-functional alignment.

Responsibilities

• Develop seasonal and annual merchandise financial plans covering sales, gross margin, markdowns, and inventory.
• Lead monthly and quarterly reforecasting of sales, margin, and inventory.
• Analyze performance across categories, collections, and channels.

Skills

Retail math and metrics

Analytical skills

Communication skills

Advanced Excel proficiency

Education

Bachelor’s Degree in Finance, Business, or related field

Tools

Planning software/tools

Merchandise management systems

Job description

Founded in 2017, RPG Commerce is a leading direct-to-consumer (DTC) social e-commerce company dedicated to building cutting‑edge everyday essentials. With an in‑house portfolio ranging from innovative active wear to home and living products, RPG currently carries an in‑house brand portfolio of brands, including Montigo, OiYO by Montigo and Casebang.

Recently securing a Series B funding round of RM127 million, RPG Commerce has over 100+ employees in KL and Singapore who work everyday to develop, design and produce high‑quality products all over the world. To find out more, please visit https://www.rpg.ventures/.

About The Job

The Merchandise Financial Planner acts as the financial architect of Montigo’s merchandising strategy, responsible for developing and managing financial frameworks that guide assortment, inventory, and sales decisions.

This role bridges finance, merchandising, and operations, ensuring the business meets sales, margin, and inventory targets through effective planning, forecasting, and in‑season management. The MFP partners closely with the Merchandise Planning Manager and Finance to translate company goals into actionable merchandise investment plans.

Key Responsibilities

Financial & Merchandise Planning

• Develop seasonal and annual merchandise financial plans covering sales, gross margin, markdowns, and inventory.
• Set financial guardrails and investment guidance for the merchandise planning and buying teams.
• Build and manage Open-to-Buy (OTB) budgets by category, channel, and region.
• Partner with Finance and Commercial teams to align merchandise plans with corporate revenue and profitability goals.

Forecasting & Performance Management

• Lead monthly and quarterly reforecasting of sales, margin, and inventory, based on actual performance and market trends.
• Partner with Demand Planner to validate forecast assumptions and adjust inventory plans accordingly.
• Conduct variance analyses to identify risks, opportunities, and recommend course corrections.
• Support scenario planning for new product launches, promotions, and channel expansions.

Business & Financial Analysis

• Analyze performance across categories, collections, and channels to understand drivers of growth and profitability.
• Monitor key retail metrics sell‑through, turn, WOS, GMROI, markdown %, and aged inventory.
• Translate insights into strategic actions: buy adjustments, price/margin optimization, or promotional guidance.
• Provide weekly/monthly performance dashboards and executive summaries to senior management.
• Track and review seasonal forecasts on a bi‑weekly or monthly basis to develop actionable data‑driven recommendations, proactively maximize opportunities and minimise risks across the business.

Process & System Development

• Lead the implementation and optimization of merchandise planning tools, templates, and processes.
• Drive consistent reporting standards and planning calendar cadence across teams.
• Contribute to building a data‑driven culture by championing analytical decision‑making within the function.

What You Need To Have

• Bachelor’s Degree in Finance, Business, Merchandising, or related field.
• Minimum 7 years of experience in financial planning & analysis (FP&A), merchandise financial planning, or commercial finance within retail, consumer goods, or lifestyle brands.
• Strong command of retail math and metrics: sales, margin, markdown, GMROI, stock turn.
• Experience managing OTB, forecasting cycles and cross‑functional alignment.
• Excellent analytical and communication skills able to present complex data in a clear, strategic narrative.
• Advanced knowledge of MS Office applications; proficiency in advanced Excel including creating spreadsheets, complex formulas, pivot tables, etc. Experience with planning software/tools and merchandise management systems is preferred.
• Experience managing a small team is an advantage.