Sales Analyst

Описание

"LVMH-Perfumes & Cosmetics Kazakhstan" is a division of the French multinational luxury goods concern LVMH (Louis Vuitton Moet Hennessy). Our brands are such historic Houses such as Parfums Christian Dior, Parfums Givenchy and Guerlain, Kenzo, Loewe.

The company operates on the market of luxury cosmetics since 1998 and currently we are proud to occupy the leading positions on the market. Our mission is «All are driven by the same values: a quest for excellence, creativity, innovation and perfect mastery of their image».

Responsibilities:

Data Management - Monthly

1. ERP – Cube Loading

• Collect and upload Sell-out / stock data from retailers by the end of each month (excel files), connect to Power BI
• Upload ranking data in the local ERP
• Check consistency of data by applying theoretical stock calculation vs retailers’ data (twice a year)
• Correct deviations in terms of dimensions (if any)

2. Collect data from retailers for presentations, reporting (Market share / ranking by categories / bestsellers / brand overall ranking) quarterly

3. Optimization of the current database and on further development in the context of ERP change

4. HQ/RHQ reporting

5. Anaplan working (performance) (Natural Demand calculation, POS management)

Budget and Revisions Processes (R0, R1, R2)

1. Sales Forecast preparation

• Sales forecast preparation for all Brands along with Brand Managers and Commercial Manager (Sell-out per customers / Sell-in per customers / Stock target simulation by year-end)

2. Anaplan working (performance)

• Natural Demand setting together with Brand Teams and consequent uploading to Anaplan

3. Stock Analysis in the Trade and Returns risks (on demand)

• Stock Analysis per SKUs and per customers in order to evaluate the returns risks in the trade
• Define action plan with Brand Managers and Trade Marketing Specialists
• Returns risk to be reviewed with Finance Team and validated prior to P&L building

4. Market books completion for all brands together with HR, Finance and Brand Teams
5. Templates preparation for revisions and targets (annually)
6. PPT preparation for all brands together with brand teams

Monthly Sales Forecasts (Outlook)

1. Review of major variances vs Budget / Revisions and define clear comments on the performance YTD and YTG with local management (Commercial / Brand Managers and Finance)
2. Monthly Outlook building along with Brands’ team and controlling team
3. Review of the Sell-in projections with split of Basic and Novelties

Monthly Sales Reports

1. Sell-out report per customers/POS/Brands revision
2. Overall presentation (Monthly Market Review) after SO/SI/Stock analysis with recommendations with Brand Teams, Commercial Team and General Manager (on demand)

Monthly Sell-out Targets Setup (Contest)
1. Target setup and templates preparation for motivation programs (retailers’ BCs and LVMH BCs) per shop proposal to be sent to the Brands for review and approval

Ad-hoc Analysis

1. Key contributor in the preparation of specific Brand’s request (Power BI included)
2. Key contributor to the issuance of the monthly Report for Brands
3. Key launches analysis (volume / value / stock) with possible effect (cannibalization on other lines / stock situation)
4. POS management in Anaplan
5. HQ requests