Business Analyst Intern, Travel Retail

SmartRecruiters, Inc.; Singapore; On-site; SGD 17,000 - 20,000; Full time

Benefits offered by this job

Daily learning opportunities

Career development opportunities

Job summary

Parfums Christian Dior in Singapore offers a 6-month full-time internship from January 2027 to June 2027. You will support retail and commercial teams by turning performance data into actionable insights, aiding in planning, budgeting, and market research across travel retail outlets.

The role requires advanced Excel, Power BI, Power Query, and strong communication skills to collaborate with stakeholders and deliver high-quality performance packs.

Qualifications

• Must commit to 6 months full-time internship from Jan 2027 to Jun 2027.
• Bachelor’s degree in Business, Economics, Finance or related field.
• Strong Excel skills including Pivot Tables, Power Query and Excel functions.
• Proficiency in Power BI and PowerPoint.
• Analytical thinking and structured problem-solving; able to manage multiple workstreams.
• Comfortable working with commercial stakeholders; strong communication skills.
• Python/R is a bonus.

Responsibilities

• Prepare weekly/monthly performance summaries (sell-out, productivity, door performance) with commentary and action points.
• Track retail KPIs and follow up on initiatives (staffing productivity, stock availability, promo execution).
• Present insights in weekly commercial/retail meetings; document actions.
• Assist with expense tracking vs budget and last year; analyze variances and drivers.
• Support ROI/business case inputs for door investments/renovations with guidance.
• Support market research on trends, customer preferences, and competitor activity in travel retail beauty.

Skills

Advanced Excel

Pivot Tables

Power Query

Power BI

PowerPoint

Analytical thinking

Problem solving

Multitasking

Stakeholder comms

Python/R

Education

Bachelor's degree in Business, Economics, Finance or related field

Tools

Power BI

Excel

Power Query

Pivot Tables

Python/R

PowerPoint

Job description

Since 1947, the men and women of Parfums Christian Dior have embodied the founding "couturier-perfumer's" unique spirit of excellence, creativity and expertise, both in France and throughout the world. Our House is an open and highly-focused collective, a leader that thrives on the creativity of all its stakeholders. Our collective passion and our heritage, full of authenticity and dream, make us move forward and reinvent ourselves.

By revolutionizing the codes of French style and luxury through perfumes, and combining tradition with daring makeup and innovative skincare, we are reinventing every day the Dior style and its compelling, joyful and absolute beauty. Our stimulating missions give our employees the opportunity to develop new skills, overcome spectacular challenges and reveal their talent.

To go further, with Dior.

Job Description

YOUR MISSION _________

Support retail and commercial teams through performance analysis, operational cadence, and on-the-ground retail exposure, translating data into actions to improve execution across doors/stores.

Core Responsibilities

Performance Reporting & Business Insights

• Prepare weekly/monthly performance summaries (sell-out, productivity, door performance) with commentary and action points.
• Track key retail KPIs and follow up on initiatives (e.g., staffing productivity, stock availability, promo execution—customize to your reality).
• Present insights in weekly commercial/retail meetings; ensure actions are documented and closed.
• Support expense tracking vs budget and last year; highlight variances and drivers.
• Assist with simple ROI/business case inputs for door investments/renovations (with guidance).
• Support market research on trends, customer preferences, and competitor activity in travel retail beauty.
• Analyze performance across countries/doors (sales, margin/profitability, expense efficiency) and highlight opportunities/risks.
• Help define and track commercial KPIs and contribute to weekly commercial meeting materials (insights, recommendations, actions).

Management Reporting

• Translate analysis into clear presentations for stakeholders (structured storylines, key takeaways, recommendations).

Deliverables / Success Measures

• High-quality commercial performance packs with clear insights and actions
• Variance analysis and scenario models that support decision-making
• Market/competitive summaries with implications for strategy
• Strong stakeholder-ready presentations and recommendations

Qualifications

Requirements

• Able to commit 6 months full time internship from Jan 2027 to Jun 2027
• Bachelor’s degree in Business, Economics, Finance or related field
• Strong Excel (advanced functions, Pivot Tables, Power Query); PowerPoint; Power BI
• Analytical thinking, structured problem-solving, able to manage multiple workstreams
• Comfortable working with commercial stakeholders; strong communication skills
• Python/R is a bonus

Additional Information

WHAT CAN WE OFFER? _________

• A challenging role in a fast moving, ambitious environment, with daily learning opportunities and passionate team members.
• Beyond this role, your development is a pillar of our ambition. Parfums Christian Dior, as part of LVMH, offers a Career perspective with a worldwide presence and continuous growth within 75 distinguished Houses.

So, How Far Will You Take Dior?