Line of Report: Group Head of E-Commerce
Current Subsidiaries: Egypt, KSA, and UAE (total of 2,200 employees)
Work Location: Egypt, Cairo, Obour City.
Duties & Responsibilities
- Strong SQL skills and hands-on experience working with large, multi-source datasets.
- Advanced Power BI skills including data modeling, DAX, Power Query, dashboard design and performance optimization.
- Strong Python skills for data cleaning, analysis, automation, forecasting and statistical modeling.
- Experience with BigQuery / cloud data warehouses, ETL/ELT pipelines, APIs and automated data refresh processes.
- Solid e-commerce analytics experience across sales, traffic, conversion, AOV, cancellations, returns, payments, delivery and customer retention.
- Hands-on knowledge of GA4 and digital marketing data; ability to combine web analytics, ad-platform and transactional data.
- Strong capability in customer analytics including cohort analysis, RFM, CLV/LTV, repeat purchase, retention and churn analysis.
- Experience with product, category and merchandising analytics including SKU scoring, stock coverage, sell-through and price-point analysis.
- Integrate and reconcile data from BigCommerce, GA4, Google Ads, Meta and other marketing platforms, OMS/CMS, payment gateways, BNPL providers and internal sources.
- Develop scalable BigQuery datasets, SQL models and automated data pipelines with strong data-quality checks and documentation.
- Build customer analytics covering new vs. returning customers, retention, cohort behavior, RFM, CLV/LTV, frequency, churn and reactivation opportunities.
- Create product and merchandising analytics by SKU, business unit, category, price point and market, including SKU performance score using sales, impressions, PDP views, add-to-cart and conversion signals.
- Analyze inventory and stock coverage, identify lost-sales risk, slow movers and replenishment priorities, and support assortment planning by market.
- Support annual budgeting and forecasting with monthly/category projections, scenario modeling, target setting and variance analysis versus budget, forecast and prior year.
- Evaluate marketing efficiency by channel and campaign, including ROAS, CAC, contribution, funnel performance and incremental opportunities through the dashboards.
- Perform root-cause and ad-hoc analyses, clearly quantify business impact, and recommend practical actions to e-commerce, marketing, operations, content and technology teams.
- Present concise weekly/monthly insights to the Group E-commerce Manager and senior stakeholders, with clear risks, opportunities, priorities and measurable next actions.
Education and Experience Requirements
- Bachelor’s degree in Data Analytics, Computer Science or a related field.
- 4–7 years of experience in Data Analytics, Business Intelligence, or E-commerce Analytics.
- Strong knowledge of SQL, Power BI, and Python.
- Hands-on experience with BigQuery or cloud data warehouses and data integration.
- Good knowledge of GA4, Google Ads, Meta, and other digital platforms.
- Strong knowledge of forecasting, reporting, and KPI analysis.
