Travel Retail Beauty Planning & Forecasting Specialist

Estée Lauder Companies; Dubai; On-site; AED 201,000 - 290,000; Full time

Job summary

The Estee Lauder Companies Inc. in Dubai is seeking a Sales & Operations Executive to support planning and forecasting for an assigned retailer portfolio.

You will work with the Area Sales & Operations Manager to ensure stock availability, coordinate orders, and drive accurate reporting. This role emphasizes data analysis, Excel expertise, and translating sales and inventory information into actionable plans.

Qualifications

• Advanced Microsoft Excel skills including PivotTables, XLOOKUP, VLOOKUP, and SUMIFS.
• Strong analytical and numerical skills to interpret data and recommend actions.
• Excellent planning and organizational abilities with tight deadlines.
• High attention to detail and data accuracy in reporting and follow-up.
• Effective communication and stakeholder coordination.
• A proactive approach to resolving operational issues.
• Proficiency in PowerPoint and business reporting tools.

Responsibilities

• Forecasting and account planning by consolidating sales trends and stock information.
• Monitor sales versus forecasts and adjust plans as needed.
• Track retailer stock levels and coordinate product availability and orders.
• Coordinate invoicing and account documentation with retailers and Finance.
• Consolidate sales, inventory and forecast data for planning files and reports.
• Prepare data for retailer meetings and business reviews.

Skills

Advanced Excel

PivotTables

XLOOKUP

VLOOKUP

SUMIFS

Data reconciliation

Large datasets

Analytical skills

Planning & organising

Attention to detail

PowerPoint

Reporting tools

Tools

SAP

ERP

BI Analysis

Power BI

Power Query

Job description

The Estee Lauder Companies Inc. in Dubai is seeking a Sales & Operations Executive to support planning and forecasting for an assigned retailer portfolio.

You will work with the Area Sales & Operations Manager to ensure stock availability, coordinate orders, and drive accurate reporting. This role emphasizes data analysis, Excel expertise, and translating sales and inventory information into actionable plans.