Data Analyst - eCommerce (Consumer)

Description

The eCommerce Data Analyst will be responsible for collecting, cleaning, analyzing, and visualizing performance data from all online sales channels to provide actionable insights. This role directly supports the eCommerce Commercial teams in optimizing sales strategies, improving marketing efficiency, and identifying growth opportunities across major marketplaces and quick-commerce platforms (Amazon, Noon, Careem Quick, Tmart, El Grocer, etc.).

• Stakeholder Support: Translate complex analytical findings into clear, non-technical recommendations for the eCommerce Managers, Marketing Teams, and Supply Chain Planners.
• Data Sourcing: Extract, transform, and load (ETL) large, disparate datasets from multiple sources, including platform-specific reports (e.g., Amazon Vendor/Seller Central reports, Noon Partner Portal data) and internal systems (ERP, CRM).
• Process Improvement: Recommend improvements to data collection processes and reporting methodologies to increase efficiency and accuracy.
• Deep Dive Analysis: Conduct comprehensive post-mortem analysis on promotional campaigns, product launches, and seasonal peaks to quantify ROI and identify causal factors for performance variance.
• Data Cleansing: Ensure the accuracy, consistency, and reliability of all eCommerce data (Sales, Inventory, Pricing, Advertising, Customer Reviews) across all reporting tools.
• Database Management: Assist in maintaining and structuring the data warehouse or centralized database specifically for eCommerce channel performance.
• Key Performance Indicator (KPI) Tracking: Develop and maintain automated dashboards and scorecards (using tools like Power BI, Tableau, or Google Data Studio) to monitor critical KPIs, including:
• Forecasting & Modeling: Build predictive models for sales trends, inventory needs, and budget allocation based on historical performance and market factors.

Requirements

2. Performance Analysis & Reporting

JOB PURPOSE: A Power BI eCommerce Data Analyst supporting the FMCG and quick-commerce operations needs to be the strategic brain behind the specialist role, focusing on extracting insights from the vast data generated by these marketplaces.

• Advertising Performance (ACoS, RoAS, CPC, Conversion Rate).
• A structured, logical approach to solving complex business problems using data.
• Expert proficiency in Excel (Power Query, Pivot Tables, advanced formulas).
• Advanced SQL proficiency for data extraction and manipulation.
• Minimum of 3+ years in a Data Analyst role, with at least 2 years focused specifically on eCommerce, Retail, or Marketplace data will be added advantage
• Experience with a statistical programming language (e.g., Python or R) is a significant asset.
• Ability to distill complex data into simple, impactful stories and visualizations.
• Fluency in at least one visualization tool (Power BI, Tableau, Looker Studio) for building interactive dashboards.
• Bachelor’s degree in data science, Statistics, Mathematics, Computer Science, or a related quantitative field. Master's degree is a plus
• Inventory Health (Sell-Through Rate, Stock-Out Rate, OOS Percentage, particularly for Q-Commerce).

Benefits

Training + Development

Interview process

Visa Sponsorship

Security clearance