Guerlain Business Analyst Internship

Paris • France

Sunday, January 26, 2025

Guerlain, a prestigious name in the world of luxury fragrances and cosmetics, is part of the esteemed LVMH group, a global leader in luxury goods. As an employer, Guerlain offers a dynamic and innovative environment where creativity and excellence are at the forefront. The brand is committed to nurturing talent and providing opportunities for professional growth within the expansive network of LVMH.

1. Coordinate with the Category and Key Account Management teams to align product assortments with marketing strategies and sales potential.
2. Develop sales arguments for clients regarding the clustering of makeup, skincare, and fragrance ranges.
3. Ensure the implementation and monitoring of assortments in retail locations through tracking tools.
4. Establish and maintain distribution measurement tables by reference and retailer.
5. Conduct ad hoc assortment analyses, such as for specific product lines like Orchidée Impériale.
6. Forecast sell-in for new product placements and monitor their performance in collaboration with KAMs and marketing teams.
7. Co-define product launch quotas by retailer and track placements.
8. Manage RACs (Returns and Allowances) and develop action plans.
9. Assist in determining product discontinuation dates for each retailer.
10. Support the definition of promotional offers with Key Account Managers.
11. Coordinate annual pricing with international teams and the French marketing category.
12. Contribute to sell-out/sell-in analyses and provide recommendations to the Director of Key Accounts.
13. Support internal sales initiatives to boost revenue and reduce RACs.
14. Assist the Director of Key Accounts with business reviews and budgetary analyses for executive presentations.

1. Currently pursuing a Master's degree in Business or a related field, with a focus on finance.
2. Strong organizational skills with the ability to manage multiple priorities proactively.
3. Enthusiastic, autonomous, and curious with recognized teamwork abilities.
4. Excellent analytical skills and a willingness to challenge the status quo.

1. Proficiency in Power BI and Excel, particularly pivot tables and VLOOKUP.
2. Familiarity with tools such as Klee, Okalys, Newvizz, and Orion sell-out is advantageous.
3. Strong interpersonal and communication skills.
4. Adaptability and a proactive approach to problem-solving.

Entry-level position suitable for students or recent graduates.

Pursuing a Master's degree (Bac +4/+5) in Business or a related field.

This internship offers a unique opportunity to gain hands-on experience in a leading luxury brand, with exposure to strategic business operations and the potential for career growth within the LVMH group.

Guerlain fosters a culture of innovation and excellence, encouraging employees to explore their creativity and contribute to the brand's legacy of luxury and sophistication. The workplace is collaborative and dynamic, with a strong emphasis on personal and professional development.