Business Analyst (FP&A) 1 Year Contract
- Contract
- Job Category: Finance and accounting
Company Description
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
PERSON SPECIFICATION
- Relevant experience through internships or apprenticeship, preferably in FP&A in the luxury, retail, and/or beauty industry.
- Proficiency in data management and manipulation, with hands-on experience in SAP, Excel, Power BI. Expertise in managing complex Excel spreadsheets is essential.
- Ability to deliver information in a clear, concise manner.
- Ability to communicate effectively.
- Fluency in English is a must have.
- A strong collaborator, communicator and team player and is comfortable working in a multicultural environment.
- Highly adaptable and flexible, able to thrive in a changing and complex business environment.