Project / Program / ManagementConfidential, Yearly Bonus. Private Medical Insurance. Transportation6 days ago
Experience الخبرة
1 To 3 Years
Career Level المستوى
Entry Level (Junior Level / Fresh Grad)
Education التعليم
Bachelor's Degree
Salary الراتب
Confidential, Yearly Bonus. Private Medical Insurance. Transportation
Skills Required المهارات المطلوبة
Analyst/ResearchSales/RetailSales ForecastingSales AnalysisForecastingDemand PlanningMicrosoft ExcelMicrosoft Power BIPower BIManufacturingVariance AnalysisTime Series AnalysisMAPEfmcg
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.