Guerlain Data Business Intelligence Intern

About Guerlain

Founded in Paris in 1828, Guerlain is one of the world’s most storied maisons of fragrance, beauty and skincare, renowned for its artisanal excellence, scientific innovation and enduring sense of French elegance. As an employer, Guerlain offers the opportunity to contribute to a living heritage where creativity, craftsmanship and responsible luxury meet. Its teams span perfumery, retail excellence, research, marketing, supply chain and corporate functions, united by a passion for exceptional products and client experience. With a strong commitment to biodiversity, sustainability and the preservation of savoir-faire, Guerlain attracts talents who aspire to shape the future of beauty while honoring nearly two centuries of legacy.

Role & Responsibilities

• Participate in international data transformation initiatives focused on sell-out and distribution data reconciliation and valuation
• Support the migration to Google Cloud Platform as part of Guerlain's core data strategy
• Contribute to the redesign and creation of Power BI dashboards and reporting frameworks
• Maintain recurring reports while ensuring consistency and reliability of data outputs
• Optimize existing reports to enhance efficiency and business relevance
• Verify data coherence and completeness across market submissions
• Monitor system refresh functionality and alert to operational irregularities
• Provide operational support to regional subsidiaries on sell-out data entry tools

Qualifications

• Pursuing a Master's degree (Bac +4/5) in engineering, data science, business analytics, or related discipline
• Proficiency in Power BI (including DAX and Power Query modeling)
• Advanced Excel skills (formulas, pivot tables, data manipulation)
• Competency in SQL for database queries and analysis
• Fluent English (written and oral, essential for the role)
• First hands-on experience with data analysis tools or project management
• Strong curiosity and rapid learning capability in a transformational technology environment
• Ability to work independently while collaborating effectively within international teams
• Excellent communication skills across diverse stakeholder groups (Business Analysts, IT teams, project managers, international markets)

Skills

Experience

Entry-level experience or demonstrated capability in data analysis, Power BI dashboarding, SQL querying, or project management within a professional or academic setting.

Education

Master's-level degree (Bac +4/5) in engineering, computer science, business analytics, data science, or equivalent discipline, with specialization in Data, Business Intelligence, or Analytics.

Workplace

Culture

Guerlain cultivates a refined workplace culture rooted in French artistry, exceptional craftsmanship, and a deep respect for its heritage in fragrance and beauty. As an employer, it values creativity, excellence, and sustainability, encouraging teams to combine innovation with the Maison’s enduring sense of elegance and purpose.

About Cerulean

Cerulean is the definitive career portal for the global luxury industry. We match exceptional professionals with exclusive opportunities at the world's most prestigious brands. From haute couture and fine watchmaking to prestige beauty, hospitality, and boutique retail, Cerulean centralises luxury employment to help you find the career for which you were destined.