Company: Nile Projects & Trading Co. (NPTCO)
Department: Supply Planning
Reports To: Business Development Analyst
Location: Alexandria
Employment Type: Full-time
Job Purpose
The Planning Data Analyst bridges supply chain operations and data analytics — automating supply planning workflows, maintaining core analytics tools, and driving ERP enhancements to optimize inventory health. This role turns raw operational data into clear, predictive insights that mitigate shortages, evaluate supplier reliability, and refine lead time accuracy.
Key Responsibilities
- Data Automation & Modeling: Build, maintain, and enhance automated Excel simulation sheets and Power BI dashboards to track stock coverage, order arrivals, and supplier performance.
- Operational Performance Analytics: Conduct deep-dive analyses on lead times, shipping pattern compliance, order variance, and stockout risks to proactively identify bottlenecks.
- ERP & System Optimization: Partner with IT and supply chain stakeholders to support ERP system development, master data, and data pipeline improvements for planning workflows.
- Data Cleaning: Clean, unpivot, and transform complex datasets from multiple operational sources to ensure data integrity and reliable reporting.
- Strategic Collaboration: Translate analytical findings into actionable recommendations for cross-functional teams (Logistics, Finance, Sales & Marketing) to optimize order cycles and inventory turnover.
Required Skills & Competencies
- Advanced Excel: complex formulas, data modeling, dynamic scenario modeling.
- Strong Power BI proficiency (DAX, data modeling, What-If parameters, dynamic parameters, visual layout design).
- Clear understanding of supply chain metrics: lead time dynamics, safety stock calculations, supplier compliance metrics (e.g., volume-weighted performance).
- Experience with data cleaning, data architecture within ERP environments, and structured problem-solving.
- Basic SQL knowledge for data extraction, manipulation, and predictive analytics is a strong plus.
Qualifications & Requirements
- Bachelor's degree in Supply Chain Management, Business Analytics, Computer Science, Engineering, or a related quantitative field.
- 1–3 years of experience in data analytics and supply chain planning, or inventory control.
- Experience with Power BI, advanced Excel/Power Query, and ERP systems (e.g., SAP, Oracle, or proprietary planning software).
- Ability to present complex technical data as concise executive summaries and operational action plans.
To Apply: Send your updated CV to [email protected] with "Planning Data Analyst - Alexandria" in the subject line.