Data Analyst · Sereko
Mar 2026 - Sep 2026 · 7 mos
Analysing sales, ad spend, and inventory data across marketplaces and the D2C store, and turning it into dashboards and MIS reports that guide management decisions.
- Build and maintain sales, orders, and revenue dashboards across marketplaces and the D2C store
- Track key eCommerce metrics: conversion rate, AOV, CAC, ROAS, return rate, and repeat purchase rate
- Analyse SKU, category, and pricing performance to flag fast movers, slow stock, and margin leaks
- Report on ad spend and campaign performance, with clear recommendations for budget allocation
- Run customer cohort and retention analysis to support LTV and re-marketing decisions
- Forecast demand and inventory needs from sales trends to reduce stock-outs and overstocking
- Clean, validate, and merge data from marketplaces, ad platforms, and the store into one reliable dataset
- Analyse return and cancellation data to identify root causes by product, pincode, and courier
- Prepare profit and loss views by channel and SKU, including fees, discounts, and ad cost
- Automate recurring reports with Excel, Google Sheets, and SQL to save hours every week
- Deliver weekly and monthly MIS reports and insights to management for faster decisions
- Partner with marketing, operations, and catalogue teams to turn data findings into action