Travel Beauty Planner: Forecast, Stock & Launch Expert

The Estee Lauder Companies Inc.; Dubai; On-site; AED 180,000 - 280,000; Full time

Job summary

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.

Responsibilities

• 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

Skills

Advanced Excel

PivotTables

Lookup functions

SUMIFS

Data reconciliation

Analytical skills

Planning

Attention to detail

Communication

PowerPoint

Stakeholder comms

Tools

SAP

ERP

Power BI

Power Query

Job description

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.