Designation: Business Analytics & MIS (Ecommerce)
Experience: 2 to 5 yrs
Roles & Responsibilities:
MIS & Reporting:
- Prepare and automate daily, weekly, and monthly E-Commerce MIS reports.
- Design dashboards for management review.
- Ensure accuracy and timely availability of business reports.
- Standardize reporting formats across marketplaces.
Business Analytics:
- Analyze sales trends and business performance.
- Identify top and bottom-performing SKUs.
- Monitor category, brand, and marketplace performance.
- Perform root cause analysis for fluctuations in sales and profitability.
- Provide actionable recommendations based on data insights.
Marketplace Performance:
- Analyze marketplace-wise sales.
- Monitor pricing, discounts, promotions performance.
- Track advertising spend and ROI.
- Evaluate marketplace profitability and growth opportunities.
Operations & Inventory Analytics:
- Monitor inventory ageing and stock availability.
- Identify stock-outs and overstock situations.
- Analyze order fulfillment, cancellations, returns, and delivery performance.
- Coordinate with warehouse and operations teams to improve service levels.
Finance Coordination:
- Validate sales, returns, claims, and settlements.
- Support reconciliation of marketplace payments and deductions.
- Monitor gross margins and contribution by SKU and marketplace.
- Highlight revenue leakages and cost optimization opportunities.
Cross-Functional Coordination:
- Work closely with E-Commerce Team, Finance, Operations, Warehouse, Customer Service and Marketing.
Mandatory:
- Advanced Microsoft Excel
- Pivot Tables
- Power Query
- Power BI
- Knowledge about Marketplace Seller Portals and its working and availability of reports.
- SQL
- Google Sheets
- Tableau
Pay: ₹20,000.00 - ₹25,000.00 per month
Work Location: In person
