Guerlain Analytics & Planning Intern

Guerlain, a distinguished name in the Perfumes & Cosmetics sector, is renowned for its commitment to innovation, luxury, and excellence. As part of a prestigious conglomerate, the brand offers unparalleled opportunities for professional growth and development within a dynamic and sophisticated environment.

1. Analyze existing reports for stakeholders, identify process gaps, and optimize for company-wide standardization.
2. Manage end-to-end analyses, identifying issues, gathering information, analyzing data, interpreting patterns and trends, building models, and providing recommendations for insightful data and automated reports.
3. Translate business needs into business intelligence reports with unique use cases for key users.
4. Automate and validate newly created reports, developing corrective actions to enhance data integrity and quality.
5. Set up and maintain business intelligence tools, infrastructure, and integration with internal and external data sources.
6. Support ad-hoc data requests and reporting.

1. Proficiency in data visualization tools such as Power BI.
2. Knowledge of database management (Python, SQL) and CRM tools (Salesforce, Adobe Campaign) is preferred.
3. Excellent skills in Microsoft Office Suite, especially Excel, Power Apps, and Power Automate.
4. Analytical with strong business acumen, capable of working with large data sets to discover patterns and trends.
5. Creative and curious, with the ability to independently research and propose new processes and solutions.
6. Excellent communication and data storytelling skills.
7. Team player with the ability to function effectively in a dynamic, fast-paced environment.
8. Quick learner with proven ability to handle multiple projects concurrently.

1. Data analysis and visualization
2. Database management
3. Business intelligence reporting
4. Problem-solving
5. Communication and storytelling
6. Team collaboration
7. Project management

Beginner level experience in data analysis or related fields.

On track to graduate with a bachelor's degree in Business, Statistics, Mathematics, Computer Science, Finance, or any other analytical field.

Opportunity to work in a hybrid model, combining remote and in-office work, within a leading luxury brand.

Guerlain fosters a culture of innovation and excellence, encouraging creativity and strategic thinking. The workplace is dynamic and fast-paced, offering a collaborative environment where team members are empowered to contribute to the brand's legacy of luxury and sophistication.