Job
Description
Roles and Responsibilities : Analyze category performance across sales channels (D2C, marketplaces, offline). Track KPIs like revenue, ASP, margin, sell-through, stock cover, and inventory turns. Conduct pricing, discount, and profitability analysis at SKU and category levels. Identify top-performing or underperforming products and uncover performance drivers. Build dashboards and automated reports for category health and inventory planning. Collaborate with marketing, SCM, and category teams to inform business decisions. Perform trend, seasonality, and cohort analysis to improve demand forecasting. Use customer behavior data (views, clicks, conversions) to support assortment planning. Automate reporting workflows and optimize SQL/Python pipelines. Support new product launches with benchmarks and success prediction models. Skills & Qualifications : 0–2 years of experience in a data analytics role, preferably in E- commerce or Retail. Proficiency in MySQL: writing complex queries, joins, window functions. Advanced Excel/Google Sheets: pivot tables, dynamic dashboards, conditional formatting. Experience in Python: Pandas, automation scripts, statsmodels/scikit- learn. Comfort with data visualization: Power BI / Tableau / Looker Studio. Understanding of product lifecycle, inventory metrics, pricing levers, and customer insights. Strong foundation in statistics: descriptive stats, A/B testing, forecasting models. Excellent problem-solving, data storytelling, and cross-functional collaboration skills. Preferred / Bonus Skills : Experience with Shopify, Magento, or other e-commerce platforms. Familiarity with Google Analytics 4 (GA4). Knowledge of merchandising or visual analytics. Exposure to machine learning (e.g., clustering, success prediction). Experience with VBA or Google Apps Script for reporting automation. Show more Show less
