Guerlain Junior Business Analyst Intern, Latin America Export
Title: Junior Business Analyst Intern, Latin America
Location: Miami, FL
Department: Guerlain Latin America Export
Reporting to: Jean-David Sebaoun, Regional Director
Full time, 6-month internship, non-exempt
OBJECTIVES:
---Learn to work in a global multicultural environment.
---Analyzing sales data for the region, under supervision.
---Learn in depth how the commercial aspect of retail is monitored.
---Work in conjunction with the marketing team to meet defined objectives.
DESCRIPTION:
1- FINANCIAL
2- COMMERCIAL PART
Analyze the Sell In – Sell Out equation for the clients and alert the Area Manager upon issues in the stock coverage for the future months
Sell In / Sell Out
- Integrate the Sell In and Sell Out quarterly objectives in the analysis to be coherent with the annual performance expected.
- Analyze catalog, animations and novelties orders vs. best-sellers performance and proposals and alert when OOS risks
- Liaise with the sales assistant to follow up the daily Shipments vs Outlook and Monthly financial target.
Stock
- Coordinate the store checks on the stock coverage with the Area Managers
- Propose push order by location when necessary
- Alert the Area Manager on potential high level for discontinuations or overstock items
Pricing
- Process pricing analysis to alert Area Managers and clients on sensitive vs non-sensitive price alignments
Assortment
- Analyze and understand the assortment by sub-market and location
- Analyze the actual assortments and MAX SKUs and alert when there are missing references
Launches
- Define together with the marketing team the Sell Out potential of the new initiatives
- Support the marketing team to create monthly alert Sell in in order to prevent OOS for new launch (ex: 3 month before the OCD).
- Liaise with the sales assistant to follow up the daily Shipments vs Outlook and Monthly financial target.
- Liaise with the sales assistant to assure the proper completion of the template for the products, testers and discontinuations
Animations
- Define together with the Area Manager the Sell Out potential vs the animations initiatives
- Analyze the promotional uplift of the different kind of animations
- Liaise with Marketing regarding the template for POSM and GWP
Visual Merchandising
- Analyze the impact of the Visual Merchandising strategy in the performances
REQUIREMENTS:
Location: Miami, FL
Department: Guerlain Latin America Export
Reporting to: Jean-David Sebaoun, Regional Director
Full time, 6-month internship, non-exempt
OBJECTIVES:
---Learn to work in a global multicultural environment.
---Analyzing sales data for the region, under supervision.
---Learn in depth how the commercial aspect of retail is monitored.
---Work in conjunction with the marketing team to meet defined objectives.
DESCRIPTION:
1- FINANCIAL
- Managing the Sell Out process:
- Uploading and reformatting data into the Orion system.
- Analyze the performances with the operational teams (Marketing / Commercial and Management)
- Managing the CAPEX expenses follow up:
- Coordinating the financial flow with Accounting and Architecture team.
- Controlling the payment and communicating the time schedule.
- Anticipating the Forecast (Budget line and new projects) and building the costs analysis.
2- COMMERCIAL PART
Analyze the Sell In – Sell Out equation for the clients and alert the Area Manager upon issues in the stock coverage for the future months
Sell In / Sell Out
- Integrate the Sell In and Sell Out quarterly objectives in the analysis to be coherent with the annual performance expected.
- Analyze catalog, animations and novelties orders vs. best-sellers performance and proposals and alert when OOS risks
- Liaise with the sales assistant to follow up the daily Shipments vs Outlook and Monthly financial target.
Stock
- Coordinate the store checks on the stock coverage with the Area Managers
- Propose push order by location when necessary
- Alert the Area Manager on potential high level for discontinuations or overstock items
Pricing
- Process pricing analysis to alert Area Managers and clients on sensitive vs non-sensitive price alignments
Assortment
- Analyze and understand the assortment by sub-market and location
- Analyze the actual assortments and MAX SKUs and alert when there are missing references
Launches
- Define together with the marketing team the Sell Out potential of the new initiatives
- Support the marketing team to create monthly alert Sell in in order to prevent OOS for new launch (ex: 3 month before the OCD).
- Liaise with the sales assistant to follow up the daily Shipments vs Outlook and Monthly financial target.
- Liaise with the sales assistant to assure the proper completion of the template for the products, testers and discontinuations
Animations
- Define together with the Area Manager the Sell Out potential vs the animations initiatives
- Analyze the promotional uplift of the different kind of animations
- Liaise with Marketing regarding the template for POSM and GWP
Visual Merchandising
- Analyze the impact of the Visual Merchandising strategy in the performances
REQUIREMENTS:
- Bachelor’s degree in fields of Business, Finance, or Marketing
- Advanced Excel skills (vlook-up, pivot tables, find/replace, formulas, filtering, database management, etc.)
- Strong relational skills
- Organized, methodical, detail oriented, self-motivated
- Interested in sales analysis, managing a retail business
- Fluency in Spanish and English; French and/or Portuguese a plus
- Sensitivity to luxury business