Business Analyst

Guerlain

Main Responsibilities

SELL-OUT LOADING & REPORTING

• Manage the monthly sell-out data loading process into the BI system for both local market and travel retail channels.
• Oversee door creation and project evolution follow-up related to key platforms such as Google Cloud Platform (GCP) and Anaplan.
• Develop and provide the team with specific reports and analysis to help all departments pilot performance.
• Mastery of Excel and Power BI for data analysis and visualization.
• Serve as the key contact for all departments (sole sell-out referent) to ensure effective performance piloting. Influence strategy and provide dedicated analysis.
• Key contributor to budget and board presentations.

COMMERCIAL PARTNERSHIP

• Work closely with the commercial team to provide weekly analysis (with a Sephora focus) and challenge sales managers to influence strategy based on trends, rankings, and market share.
• Marketing Collaboration:
• Conduct product analysis and identify key leverages, working closely with Chalhoub (or relevant partner) to gather market information.

TRADE ANALYSIS

• Perform deep dives into trade performance, improving the understanding of profitability by accurately analyzing strategic podium performance (actual costs with amortization, actual sell-out).
• Propose trade arbitrage when necessary and fill out sell-out estimations for upcoming animations.

REATIL PERFORMANCE LEADERSHIP

• Lead the performance retail weekly meeting with Comex.
• Conduct further analysis on the #1 channel, and help the team create a retail vision and understand how to grow the business and adapt the 360 operational behind the boutiques.
• Drive acceleration on KPIs use.
• Provide Reattainment / Novelties / Trade performance analysis.

FINANCE ALIGNMENT

• Work closely with the finance team to respect HQ processes (distribution file, market book, door mapping).
• Travel Retail Expertise:
• Deep dive into customer analysis within the Travel Retail channel to achieve the same level of insight as the Local Market.

RELATIONSHIP WITH HQ

• Maintain constant communication with HQ on a monthly, weekly, and even daily basis.
• Participate in bi-monthly BA community meetings, providing explanations of Middle East performance, animation plans, and justifications for both positive and negative results.
• Provide weekly sales updates with qualitative feedback.
• Engage in daily exchanges with HQ to provide necessary details such as door mapping, trend analysis, and business commentary.

Profile