Travel Retail Beauty Planner Dubai Based

The Estee Lauder Companies Inc.; Dubai; Sur place; AED 180 000 - 280 000; Plein temps

Résumé du poste

The Estee Lauder Companies Inc. is seeking a Sales & Operations Executive to shape planning, forecasting and stock coordination for a selected retailer portfolio.

You will translate sales and inventory data into actionable plans, working with ASOM and cross-functional teams. You will excel in Excel and reporting, monitor variances, track orders, and support product launches and promotions to ensure product availability and timely delivery.

Qualifications

• Advanced Microsoft Excel skills including PivotTables, XLOOKUP/VLOOKUP, SUMIFS, data reconciliation and large dataset management.
• Strong analytical and numerical skills with the ability to interpret data, investigate variances and recommend practical actions.
• Strong planning and organisational skills with the ability to manage recurring deadlines and changing priorities.
• High attention to detail and a disciplined approach to data accuracy, reporting and follow-through.
• Effective communication and stakeholder coordination skills.
• A proactive, practical approach to resolving operational issues.
• Proficiency in PowerPoint and business reporting tools.

Responsabilités

• Support forecasting and account planning by consolidating sales trends, stock information, retailer requirements and upcoming promotional activity.
• Monitor actual sales against forecasts, investigate variances and highlight where plans may need to be adjusted.
• Monitor retailer stock levels, product availability and stock coverage, highlighting out-of-stock, overstock and potential supply gap risks.
• Coordinate order processing for saleable products, testers and free-of-charge items, ensuring accuracy and timely follow-up.
• Track order status and delivery timelines with relevant teams, escalating delays or discrepancies that could affect availability.
• Support stock allocation and replenishment discussions using sales, inventory and forecast data.
• Coordinate invoicing requirements, account documentation and order queries with retailers and Finance.
• Consolidate, validate and analyse sales, inventory, order and forecast data from multiple sources.
• Develop and maintain planning files, tools, performance trackers, scorecards and regular reports.
• Analyse sell-in and sell-out performance alongside stock availability to identify trends, risks and required actions.
• Prepare clear summaries and recommendations to support planning and business decisions.
• Maintain data accuracy and consistency across reports, investigating discrepancies and following through on corrections.
• Act as a day-to-day contact for retailer planning and operational requirements.
• Coordinate actions across Supply Chain, Brand, Retail, Education and Finance to support product availability and operational delivery.
• Prepare data and updates for retailer meetings and business reviews, recording decisions and tracking agreed actions.
• Communicate operational risks clearly and elevate issues promptly to the ASOM.
• Support the operational planning of product launches, promotions and trade marketing activities.
• Coordinate product, tester and stock requirements with the ASOM, Brand teams and relevant stakeholders.
• Track readiness against key dates and flag availability or delivery risks.
• Review sales and stock performance following launches and promotions to inform future planning.
• Contribute to improvements in forecasting, order coordination, reporting and retailer service

Connaissances

Advanced Excel

PivotTables

Lookup functions

SUMIFS

Data reconciliation

Analytical skills

Planning

Attention to detail

Communication

PowerPoint

Stakeholder comms

Outils

SAP

ERP

Power BI

Power Query

Description du poste

Job Description:

Description

This role supports the [Beauty planning] and operational delivery of an assigned retailer portfolio, working closely with the Area Sales & Operations Manager (ASOM).

This is a planning and analytical role, with a strong focus on forecasting, stock availability, order coordination and reporting.

The role requires someone who is confident working with data, highly proficient in Excel and able to translate sales and inventory information into clear actions.

Working with retailers and internal Brand, Supply Chain and Finance teams, the Sales & Operations Executive helps align product requirements, orders and stock availability with business priorities, launches and promotional activity.

Planning & Forecasting

• Support forecasting and account planning by consolidating sales trends, stock information, retailer requirements and upcoming promotional activity.
• Monitor actual sales against forecasts, investigate variances and highlight where plans may need to be adjusted.

Inventory & Order Coordination

• Monitor retailer stock levels, product availability and stock coverage, highlighting out-of-stock,overstockand potential supply gaprisks.
• Coordinate order processing for saleable products, testers and free-of-charge items, ensuring accuracy and timely follow-up.
• Track order status and delivery timelines with relevant teams, escalating delays or discrepancies that could affect availability.
• Support stock allocation and replenishment discussions using sales, inventory and forecast data.
• Coordinate invoicing requirements, account documentation and order queries with retailers and Finance.

Data Analysis & Reporting

• Consolidate, validate and analyse sales, inventory, order and forecast data from multiple sources.
• Develop and maintain planningfiles,tools, performance trackers, scorecards and regular reports, ensuring information is accurate and current.
• Analyse sell-in and sell-out performance alongside stock availability to identify trends, risks and required actions.
• Prepare clear summaries and recommendations to support planning and business decisions.
• Maintain data accuracy and consistency across reports, investigating discrepancies and following through on corrections.

Retailer & Cross-Functional Coordination

• Act as a day-to-day contact for retailer planning and operational requirements.
• Coordinate actions across Supply Chain, Brand, Retail, Education and Finance to support product availability and operational delivery.
• Maintain action logs, clarify responsibilities and follow up on outstanding issues.
• Prepare data and updates for retailer meetings and business reviews, recording decisions and tracking agreed actions.
• Communicate operational risks clearly and elevate issues promptly to the ASOM.

Launch & Promotional Planning

• Support the operational planning of product launches, promotions and trade marketing activities.
• Coordinate product, tester and stock requirements with the ASOM, Brand teams and relevant stakeholders.
• Track readiness against key dates and flag availability or delivery risks.
• Review sales and stock performance following launches and promotions to inform future planning.
• Contribute to improvements in forecasting, order coordination, reporting and retailer service

Qualifications

Essential

• Advanced Microsoft Excel skills, including PivotTables, lookup functions such as XLOOKUP or VLOOKUP, SUMIFS, data reconciliation and the management of large datasets.
• Strong analytical and numerical skills, with the ability to interpret data, investigate variances and recommend practical actions.
• Strong planning and organisational skills, with the ability to manage recurring deadlines and changing priorities.
• High attention to detail and a disciplined approach to data accuracy, reporting and follow-through.
• Effective communication and stakeholder coordination skills.
• A proactive, practical approach to resolving operational issues.
• Proficiency in PowerPoint and business reporting tools.

Desirable

• Experience insupply chain, demand or supply planning, logistics, inventory management, replenishment or order management.
• Experience supporting retailer or distributor operations in beauty, FMCG, consumer goods or travel retail.
• Familiarity with [SAP, ERP, BI Analysis], inventory or order management systems.
• Experience using Power Query, Power BI or similar tools to improve reporting efficiency.
• Understanding of sell-in, sell-out, stock coverage and forecast accuracy.

Travel Retail is a fast-paced, dynamic and entrepreneurial environment. Candidates should bring a positive, flexible and hands-on approach, with the ability to stay organised and maintain accuracy as business priorities change.