Job Description

Company Description

My Way Egypt Group, established in 2002, is the country’s leading direct selling company with an extensive presence across 46 branches nationwide. With a diverse portfolio of over 1,200 products, the company operates three factories and employs more than 3,000 professionals. My Way is also the proud owner of two successful retail sub-brands: 5 Mins, specializing in food mixes and spices, and Maderra, focusing on detergents and home care solutions.

Location: Al-Obour First Industrial Zone

Working Conditions: Sunday to Thursday

Working Hours: 08:00 AM to 04:30 PM

Key Responsibilities

1. Sales Forecasting & Historical Analysis:

• Develop and execute monthly and annual sales forecasts by analyzing historical data, market trends, and seasonal patterns across all product lines.
• Use statistical modeling and data-driven insights to predict future sales volumes for existing and new products.
• Perform regular audits and cleansing of sales data to ensure the foundation of the forecast is accurate.

2. Forecast Modeling & Development:

• Build and maintain advanced statistical forecast models (e.g., time series, regression) to support high-level business planning.
• Adjust baseline sales forecasts based on specific promotional calendars, marketing events, and market intelligence.
• Prepare detailed demand estimates for New Product Introductions (NPI) to ensure optimal stock levels from day one.

3. Accuracy Monitoring & Variance Analysis:

• Measure and track Sales Forecast Accuracy (e.g., MAPE, WAPE, Bias) and identify the root causes of any forecast errors.
• Analyze the “gap” between actual sales and forecasted figures, providing actionable insights to management to minimize future deviations.

4.Cross-Functional Demand Alignment:

• Lead monthly meetings with Sales and Marketing teams to gather field intelligence and incorporate it into the Sales Forecast.
• Communicate the final demand plan to the Supply Chain and Production departments to ensure alignment with operational capacity.

Requirements

• Education: Bachelor’s degree in Business Administration, Finance, Statistics, Supply Chain, or a related field.
• Experience: 1-3 years of experience in demand planning or Sales Forecasting  analytical role.
• Mandatory experience in the Cosmetics industry or FMCG.
• Proven track record of managing high number of product lines (diverse SKUs) simultaneously.

Technical Skills:

• Expert-level proficiency in Microsoft Excel (Advanced formulas, Pivot tables, Macros).
• Familiarity with Power BI or other data visualization tools.

Competencies: 

•  Strong quantitative skills with the ability to interpret complex data from various sources.
• Excellent communication skills for presenting complex data to stakeholders.