Data Analyst-E-Commerce
Summary
Data analyst for a reputed consumer-goods (FMCG) client, tracking sales, pricing, promotions, digital shelf, market share, and inventory across Amazon, Flipkart, and quick-commerce platforms like Blinkit, Zepto, and Swiggy Instamart. Core stack is advanced Excel and Power BI, with SAP and vendor-portal dashboards.
About Client - Reputed Consumer Goods Industry __________________________________________________________________
Position: Data Analyst - E-Commerce
Location: Mumbai
Reporting to: Sr. Digital Account Manager
Criteria: Graduate with 3+ years of experience in Data Analytics, E-Commerce Analytics, BI, or Commercial Analytics, preferably handling Amazon and Quick Commerce analytics, with FMCG, Consumer Durables, Consumer Healthcare, or Retail industry experience.
Skills and Knowledge
- Data Management & Analytical skills
- Advanced MS Excel (Pivot Tables, XLOOKUP, Dashboards, Power Query).Power BI
- Working experience in SAP preferred
- Working knowledge of platform dashboards (Blinkit Vendor Portal, Zepto Supplier Portal, Swiggy Partner App).
Interactions (Internal & External)
- SKAM
- Product/Brand Managers
- HR
- Sr.MIS/MIS Manager
- Finance
- Sales Co-ordinators
- Key Account Executive
Desired Behaviour
- Innovation
- Value for Customer
- Entrepreneurial
- Empowered
- Accountable
- Integrity & Winning Spirit
Job Purpose: Responsible for analyzing E-Commerce and Quick Commerce business performance across platforms such as Amazon, Flipkart, Blinkit, Zepto, Swiggy Instamart, BigBasket, JioMart and other online channels. Will support leadership by providing actionable insights on sales, pricing, assortment, promotions, market share, availability, and customer behavior to accelerate growth.
Key Responsibilities
- Sales Performance Analysis- Track Daily/Weekly/Monthly sales performance by Platform, Category, brand, SKU & Region/City, Growth trends. Identify key performance gaps & growth Drivers including - NPI, listings, OSA & Fill Rate tracking
- Pricing & Promotion Analysis: MRP vs SP impact on sales trend, competitor data mapping & analysis, evaluate category share. Check impact of Deals, Coupon, Bundles & visual campaigns
- Digital Shelf Analysis: Product Ranking, Search Performance, Conversion Rates & content score. Monitor & Recommend- Product listings, reviews, ratings, image compliance & A+ Content
- Category & Market Share Analysis: Category growth, brand share, consumer behaviour, emerging opportunity. Use data source like NIQ, Kantar, platform dashboard & internal Source
- Dashboard & Automation:Develop & maintain dashboard using Power BI, Excel etc to regulate reporting on Sales, Distribution, Pricing, Promotion, Market Share. Transform manual working into digital dash boards
- Inventory & Supply Analysis : Forecast Accuracy, Fill rate, Ageing, Coverage
Additional Responsibilities
- Provide Ad-hoc value-add reports analysing peak hour sales spikes, stock-out patterns, and fast-moving SKU metrics
- Track account-wise financial reconciliation—including platform debit notes, damage claims, and fill-rate penalty deductions.
- Integrate 3rd party tools data with internal data
Skills
Sign in to read and join the discussion.