Business Analyst

LVMH Perfumes & Cosmetics; Singapore; On-site; USD 50,000 - 90,000; Full time

Job summary

An established industry player is seeking a detail-oriented data analyst to support their finance team. In this role, you will maintain databases, deliver insightful reports, and analyze sales performance. Your expertise in Excel, SAP, and Power BI will be crucial in providing accurate business insights. This position offers a dynamic environment where collaboration with multicultural teams is encouraged, and your analytical skills will directly impact business strategies. If you thrive under pressure and enjoy problem-solving, this opportunity is perfect for you.

Qualifications

• At least 3 years of relevant experience in data/business analysis.
• Proficiency in managing complex Excel spreadsheets and data manipulation.

Responsibilities

• Deliver accurate weekly and monthly Sell-in and Sell-out reports.
• Analyze retail and sales performance against targets.

Skills

Data Analysis

Excel Spreadsheets

SAP

Power BI

Business Acumen

Problem-Solving

Education

University Degree in Accounting

Tools

SAP

Power BI

Excel

Job description

Job Description

KEY 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 region.
• Track retail and sales performance against targets, identify gaps, and understand actions from the commercial team to meet targets.
• Coordinate and manage monthly retail & net sales estimates, analyze variances against the budget, and report to headquarters.
• Provide insightful monthly flash reports on business sales performance.
• Support the business controller in developing standard reporting processes, ensuring accuracy and timeliness, with continuous improvements.
• Prepare monthly management reports with commentary on variances between actuals, forecasts, and budgets.
• Assist regional and headquarters teams with ad hoc local reports.
• Conduct data analysis on sales and activation trends as required.

Budget/Revised Budget/Landing/Strategy plan

• Assist in the forecast process for budgets, revised budgets, and projections.
• Ensure accurate rollover of working templates across planning cycles.
• Analyze key focus areas such as trend per door, seasonality, stock-holding, and CAPEX.
• Support system uploads and submission package preparations.
• Gather and consolidate inputs from markets and stakeholders.
• Maintain cost control jointly with the Business Controller.

Ad hoc

• Participate in finance/IT project implementations for controlling.
• Track new business KPIs.
• Improve operational processes through automation and standardization.
• Collaborate with brand managers, controllers, and accounting teams to analyze business requirements for finance and regulatory initiatives.

Qualifications

Skills & experience

• University Degree, preferably in accounting.
• At least 3 years of relevant experience in data/business analysis.
• Proficiency in managing complex Excel spreadsheets, SAP, Power BI, and data manipulation.
• Ability to analyze data and communicate insights effectively to stakeholders.
• Some commercial understanding, preferably retail experience.
• Strong problem-solving skills and business acumen.

Personal attributes

• Collaborative, communicative, and team-oriented, comfortable in multicultural environments.
• Highly adaptable and flexible to change.
• Excellent planning, organization, and time management skills.
• Ability to work under pressure and meet deadlines, with meticulous attention to detail.