Role Purpose To strengthen the eCommerce teams data, MIS and reporting capability by building reliable, simplified and presentation-ready dashboards and analytical outputs. The role is expected to convert multiple raw data sources into accurate business insights, automate recurring reporting requirements, and enable faster decision-making across category, platform, media and business review forums.

What Is Expected From the Role

- Own recurring eCommerce MIS and data consolidation requirements across market share, offtake, RDM, media spends,

promotions, budgets, platform trackers and business update inputs.
- Convert large and fragmented datasets into clean, structured and easy-to-consume dashboards for business reviews and

stakeholder discussions.
- Bring efficiency into current ways of working by automating repetitive reports, reducing manual effort and improving data

consistency.
- Simplify complex data into sharp, actionable insights that can be used directly in presentations, review decks and leadership

updates.
- Maintain strong accuracy discipline by validating data before circulation and highlighting anomalies, gaps or inconsistencies

proactively.
- Partner with eComm, BU, KAM, media and cross-functional stakeholders to ensure information is timely, reliable and decision

ready.

Core Responsibility Areas

1. MIS, Data Compilation & Governance

- Maintain structured recurring MIS files and master trackers for eCommerce business requirements.
- Ensure data sources, file versions and calculations are clearly defined and easy to audit.
- Create standard formats to reduce rework and improve consistency across recurring reports.

1. Dashboarding & Business Visualization





- Build presentable dashboards that summarize performance across categories, brands, platforms and key business metrics.
- Use clear visual hierarchy so leadership and stakeholders can quickly understand the current status, risks and opportunities.
- Translate Excel / Power BI outputs into presentation-ready charts, summaries and review inputs.

1. Automation & Process Simplification

- Identify manual, repetitive reporting steps and automate them using Excel formulas, Power Query, Power BI or other approved tools.
- Simplify recurring workflows so that business teams can access the required output faster and with fewer manual dependencies.
- Develop reusable templates and trackers that improve speed, accuracy and continuity.

1. Stakeholder Support & Review Readiness

- Provide timely responses to business data requests while maintaining quality and accuracy standards.
- Ensure outputs are easy to interpret, visually neat and ready for stakeholder consumption.

Key Skills Required

Advanced Excel

Strong command over formulas, pivots, lookups, data cleaning, conditional formatting and structured reporting formats.

Power BI / Dashboarding

Ability to create dashboards, define measures, visualize trends and convert datasets into business-friendly views.

Automation Mindset

Data Interpretation

Ability to simplify repetitive manual reports through Power Query,



templates,

workflow improvements or approved automation tools.

Ability to move beyond compilation and identify patterns, exceptions, risk areas and actionable business insights.

Presentation Readiness

Accuracy & Ownership

Ability to convert analysis into clear charts, crisp summaries and polished inputs for review decks.

High attention to detail, strong validation discipline, timely closure and comfort working with multiple stakeholders.

Expected Deliverables

- Automated or semi-automated recurring MIS reports with minimum manual intervention.
- Power BI / Excel dashboards that are clean, scalable and easy to refresh.
- Validated business inputs for category, platform, RDM, media, promo and offtake reviews.
- Insight-led summaries that clearly call out what changed, why it matters and what requires action.
- Standardized templates and trackers that improve continuity and reduce dependency on individual working styles.
- Presentation-ready outputs that can be directly used in internal reviews and stakeholder discussions.

Suggested Candidate Profile
- Experience in MIS, analytics, sales operations, eCommerce reporting, commercial analytics or business intelligence support.
- Comfortable working with large datasets and multiple input sources from platforms, agencies, internal stakeholders or business

systems.
- Strong Excel capability is essential; Power BI and automation exposure should be considered important selection criteria.
- Strong communication and visualization ability to convert data into explicit business narratives.
- High ownership, accuracy, speed and stakeholder-management orientation.

📌 eCommerce - MIS (Gurugram)
🏢 Nestlé
📍 Gurugram