Job Description
- 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 a 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.
Requirements & Qualifications
- Bachelor’s degree in Data Analytics, Computer Science or a related field.
- 4–7 years of experience inData Analytics, Business Intelligence, or E-commerce Analytics.
- Strong knowledge ofSQL, Power BI, and Python.
- Hands-on experience withBigQuery or cloud data warehousesand data integration.
- Good knowledge ofGA4, Google Ads, Meta, and other digital platforms.
- Strong knowledge offorecasting, reporting, and KPI analysis.
- Strong analytical and problem-solving skills.
- Excellent communication and presentation skills.
- Very good command of English.
TalentIT Analysis
Quick Role Summary
Opportunity as "E-Commerce Senior Specialist" at L'azurde for Jewelry located in القاهرة on a Full-Time basis, suited for Fresh Graduate candidates. Key details from listing: • Strong SQL skills and hands-on experience working with large, multi-source datasets. • Advanced Power BI skills including data modeling, DAX, Power Query,…
The TalentIT editorial team prepares curated overviews and actionable application guidance for every listing, preserving official employer details.
Application Tips
- Tailor your CV headline to match "E-Commerce Senior Specialist" and feature measurable achievements in the top third of your resume.
- Customize your cover note for القاهرة: explain why this location and work arrangement suit your availability and how you add value to the team.
- Highlight relevant practical experience, key responsibilities, and specific business impact.
- Showcase practical projects, accredited certifications, and strong language skills to complement experience.
- After applying, monitor your status from your dashboard and stay prepared for an interview invitation.
Readiness Checklist
- Updated CV in standard PDF format with a professional filename
- Skills aligned with the stated role requirements
- Availability for work in القاهرة or remote if specified
- Measurable achievement examples prepared for interview talking points
- TalentIT candidate profile ready for application tracking
More Career Guides →
Similar Jobs You Might Like
Ideal Standard International Egypt
Full-Time
📍 شيراتون، مصر
شركة رائدة
Full-Time
📍 الجيزة، مصر
شركة رائدة
Full-Time
📍 شيراتون، مصر
Raya For Electro Mechanical Contracting
Full-Time
📍 السادس من أكتوبر، مصر
RAQMU for Building and Construction
Full-Time
📍 القاهرة، مصر
شركة رائدة
Full-Time
📍 الجيزة، مصر