Financial Planning and Analysis Specialist

CHARLES & KEITH GROUP; Singapore; On-site; SGD 60,000 - 90,000; Full time

Job summary

CHARLES & KEITH GROUP in Singapore is seeking a finance-minded merchandising planner to drive revenue forecasting and long-range planning. You will link targets to merchandising plans, inventory, launches, and category strategies to enable accurate budgeting and informed decisions.

The role requires building monthly/quarterly forecasts, translating stock-to-sales data into sales outcomes, and performing variance analysis to support proactive business actions.

Qualifications

• Bachelor’s degree in Finance, Business, Economics, Merchandising, Retail Management, or related field.
• 2–3 years’ experience in merchandising planning, demand planning, or commercial planning within retail.
• Strong Excel and PowerPoint skills; Power BI or planning tools is an advantage.
• Ability to turn data into clear insights, recommendations, and stakeholder-ready storytelling.
• Confident partnering with merchandising, commercial, operations, and finance stakeholders.
• Detail-oriented, analytical, and able to balance commercial judgement with financial discipline.

Responsibilities

• Sales Budgeting: support budget and long-range sales planning by linking revenue targets to merchandising plans, inventory availability, product launches, and category strategies.
• Rolling Forecasts: build monthly or quarterly forecasts using key retail and merchandising drivers, including traffic, conversion, ATV, sell-through, stock cover, replenishment timing, and launch phasing.
• Driver-Based Modelling: translate inventory cover, sell-through, replenishment, markdown, and seasonal assumptions into sales outcomes.
• Actual vs. Plan Tracking: perform weekly and monthly variance analysis on retail sales against forecast and budget.
• Channel & Category Analytics: analyse sales performance by store, category, assortment mix, and region to identify growth opportunities, stock constraints, and sales risks.
• Promotional & Markdown ROI: assess campaign, markdown, loyalty, and clearance performance, including impact on sell-through, stock liquidation, sales uplift, and margin.
• Business Partnering: partner with commercial, merchandising, operations, and marketing teams to align pricing, assortment, stock-to-sales goals, and revenue forecasts.

Skills

Revenue forecasting

Merchandising planning

Stock-to-sales translation

Retail analytics

Variance analysis

Commercial storytelling

Business partnering

Education

Bachelor’s degree in Finance, Business, Economics, Merchandising, Retail Management, or related field

Tools

Excel

PowerPoint

Power BI

Job description

• Sales Budgeting: Support budget and long-range sales planning by linking revenue targets to merchandising plans, inventory availability, product launches, and category strategies


• Rolling Forecasts: Build monthly or quarterly forecasts using key retail and merchandising drivers, including traffic, conversion, ATV, sell-through, stock cover, replenishment timing, and launch phasing


• Driver-Based Modelling: Translate inventory cover, sell-through, replenishment, markdown, and seasonal assumptions into sales outcomes

Performance & Variance Analysis

• Actual vs. Plan Tracking: Perform weekly and monthly variance analysis on retail sales against forecast and budget


• Channel & Category Analytics: Analyse sales performance by store, category, assortment mix, and region to identify growth opportunities, stock constraints, and sales risks


• Promotional & Markdown ROI: Assess campaign, markdown, loyalty, and clearance performance, including impact on sell-through, stock liquidation, sales uplift, and margin

Business Partnering & Reporting

• Business Partnering: Partner with commercial, merchandising, operations, and marketing teams to align pricing, assortment, stock-to-sales goals, and revenue forecasts

Requirements

• Bachelor’s degree in Finance, Business, Economics, Merchandising, Retail Management, or a related field


• Key skills: Revenue forecasting, merchandising planning, stock-to-sales translation, retail analytics, variance analysis, commercial storytelling, and business partnering


• 2 to 3 years’ experience in merchandising planning, demand planning, or commercial planning within a retail environment


• Strong understanding of how assortment mix, stock availability, sell-through, markdowns, and replenishment cycles impact sales forecasts and revenue performance


• Experience in Merchandising, allocation, retail planning, or demand planning who can connect stock-to-sales planning with commercial finance and business actions is an advantage


• Strong Excel and PowerPoint skills; experience with Power BI or planning tools is an advantage


• Ability to turn data into clear insights, recommendations, and stakeholder-ready storytelling


• Confident partnering with merchandising, commercial, operations, and finance stakeholders


• Comfortable working with ambiguity, improving planning processes, and solving business problems


• Detail-oriented, analytical, and able to balance commercial judgement with financial discipline