Business Data Analyst

Key Responsibilities

1) AOP Planning & Tracking

* Build and maintain AOP planning models (monthly/weekly splits, SKU-level targets, channel splits).

* Track plan vs. actuals across revenue, gross margin, contribution margin.

* Highlight gaps, risks, and required run-rate to achieve targets.

* Run scenario simulations (price changes, mix changes, discounting, cost shifts).

2) Revenue & Margin Dashboards

* Create automated dashboards for:

* Total revenue vs plan

* Gross margin % and absolute

* Category / subcategory / model performance

* Channel-wise performance (online, offline, marketplaces)

* ASP, discount, and mix trends

* Ensure single source of truth across teams.

3) SKU / Model-Level Performance

* Track model-wise:

* Sales

* Margin

* Inventory turns

* Aging

* Sell-through

* Identify hero / tail / declining SKUs.

* Recommend assortment and pricing actions.

4) Provisional P&L Support

* Work with business finance to prepare provisional P&L:

* Net revenue

* COGS

* Gross margin

* Marketing spends

* Contribution

* Monthly variance vs AOP.

* Drivers of deviation (price, cost, mix, channel).

5) Decision Support & Insights

* Provide category reviews with:

* Performance insights

* Root-cause analysis

* Corrective actions

* Support pricing decisions and promotions.

* Analyze impact of campaigns and launches.

6) Data Infrastructure & Automation

* Build automated reporting pipelines.

* Maintain clean master datasets:

* SKU master

* Cost sheets

* Price lists

* Channel mappings

* Reduce manual Excel dependency.

Deliverables / Outputs

* AOP tracker (live)

* Revenue & margin dashboards

* SKU performance tracker

* Monthly provisional P&L

* Category review deck

* Scenario planning tools

Skills Required

Core

* Advanced Excel / Google Sheets (must)

* Business analytics

Analytical

* Variance analysis

* Cohort / mix analysis

* Margin decomposition

* Forecasting basics

Business Understanding

* Retail / D2C / category business economics

* Pricing and margin structures

* Inventory & sell-through dynamics

Experience Profile : 25 years in:

* Business analytics

* Category analytics

* Revenue analytics

* Consumer / retail / ecommerce preferred.

KPIs for Role Success

* Accuracy of AOP tracking

* Timeliness of dashboards

* Reduction in manual reporting effort

* Forecast accuracy improvement

* Category margin visibility

* Decision turnaround time

Ideal Candidate Traits

* Structured thinker

* Commercially oriented (not just reporting)

* Comfortable with ambiguity

* Detail-obsessed with numbers

* Communicates insights clearly