Business Analyst (FP&A) 1 Year Contract

at  Guerlain

Business reporting and controlling

• Deliver accurate and timely weekly and monthly Sell-in and Sell-out reports for the SEAOC region.
• Timely tracking of retail and sales performance against targets, identifying gaps, and collaborating with teams to develop and implement action plans to meet targets.
• Coordinate and manage monthly net sales estimates, analyzing variances against the budget and reporting to headquarters.
• Deliver insightful monthly flash reports on business sales performance.
• Own standard reporting processes, ensuring they are accurate and delivered on time while continuously seeking improvements.
• Produce monthly reports for key doors and P&L by channel/axis
• Monitor monthly direct retail performance with benchmark against HQ KPI
• Deep dive on post event ROI performance
• Support regional and headquarters teams with ad hoc local reports

PURPOSE OF THE JOB

Market Scope: Singapore, Malaysia, Thailand, Vietnam, Philippines, Indonesia, Australia, New Zealand Local Markets

• L Beauty: Joint Venture between LVMH (French group) and Luxasia (Singaporean group) in charge of the distribution of Guerlain Singapore, Malaysia, Thailand, Philippines, Vietnam
• PT Guerlain Cosmetics Indonesia: Joint Venture between LVMH (French group) and PT Aura (Indonesia company) in charge of Guerlain distribution in Indonesia
• Cosmax: Agent in charge of Guerlain distribution in Australia and New Zealand

The Business Analyst is supporting the Regional Controller and brand team to provide accurate information to drive the business; she/he will be involved in various business controlling aspects of the brand and interacting often with the countries.
Job Description

MAIN RESPONSIBILITIES

• Maintain databases on Retail and Net Sales, and provide analysis

• By country

• By channel/customer

• By door

Business reporting and controlling

• Deliver accurate and timely weekly and monthly Sell-in and Sell-out reports for the SEAOC region.
• Timely tracking of retail and sales performance against targets, identifying gaps, and collaborating with teams to develop and implement action plans to meet targets.
• Coordinate and manage monthly net sales estimates, analyzing variances against the budget and reporting to headquarters.
• Deliver insightful monthly flash reports on business sales performance.
• Own standard reporting processes, ensuring they are accurate and delivered on time while continuously seeking improvements.
• Produce monthly reports for key doors and P&L by channel/axis
• Monitor monthly direct retail performance with benchmark against HQ KPI
• Deep dive on post event ROI performance

• Support regional and headquarters teams with ad hoc local reports.

Budget/Revised Budget/Landing/Strategy plan

• Assist the Business Controller in the forecast process for budgets, revised budgets, and projections, enhancing & refreshing templates.
• Perform detailed analysis on appropriate focuses on for the business (trend per door, sales seasonality, stock-holding, CAPEX…)
• Support the system upload.

• Consolidate part of the forecasting information when required.

Ad hoc

• Participate in the implementation of finance / IT projects for the controlling function.
• Develop and track new business key performance indicators (KPIs).
• Continuously improve operational processes by identifying areas for automation and standardization, enhancing cross-reporting capabilities.

• Collaborate closely with brand managers, local controllers, and accounting teams to gather and analyze business requirements for various finance and regulatory initiatives.

Be involved in monitoring Retail processes

• Ensure Retail Standard Operating Procedures are implemented and followed.
• Support Retail team on system flows understanding and business/financial impacts (interface…)

Qualifications