PG India - Executive - MIS Ecommerce

Publicis Groupe Holdings B.V.; Gurugram District; On-site; INR 350,000 - 550,000; Full time

Job summary

Publicis Groupe Holdings B.V. in Gurgaon is seeking an Executive MIS - E-commerce to manage day-to-day e-commerce operations and reporting, with a strong focus on Excel, bulk report generation, data management, and process automation.

The role will handle large datasets, develop dashboards, and automate repetitive reporting to improve accuracy and efficiency across marketplaces like Amazon, Flipkart, and Blinkit, delivering daily, weekly, and monthly MIS outputs.

Qualifications

• Strong Advanced Excel skills.
• Hands-on experience with Macros/VBA and report automation.
• Experience handling large/bulk datasets and bulk report generation.
• Strong understanding of MIS, data analysis, and reporting.
• Good attention to detail and problem-solving skills.
• Experience with marketplaces such as Amazon, Flipkart, and Blinkit is preferred.

Responsibilities

• Manage day-to-day e-commerce operations and reporting.
• Generate and manage bulk reports across e-commerce/marketplace platforms.
• Work extensively on MS Excel, including advanced formulas, Pivot Tables, VLOOKUP/XLOOKUP, and data analysis.
• Create and maintain Excel macros/VBA-based automation to reduce manual effort and improve reporting efficiency.
• Automate repetitive operational and reporting processes.
• Consolidate, clean, and analyze large datasets from multiple sources.
• Track key operational metrics, sales data, inventory, orders, and campaign performance.
• Prepare daily, weekly, and monthly MIS and performance reports.
• Identify data discrepancies and ensure data accuracy across reports.
• Develop dashboards and automated reporting formats for stakeholders.
• Work with internal teams and marketplace partners to resolve operational and data-related issues.
• Continuously identify opportunities for process improvement and automation.

Skills

Excel

Bulk reports

Data management

Automation

Pivot Tables

VLOOKUP/XLOOKUP

Macros/VBA

Data analysis

Reporting

MIS

Job description

Job Description:

Overview

Job Description – Executive - MIS E-commerce

Experience: 1 - 2 YearsLocation: Gurgaon

About the Role:

We are looking for an Executive MIS - E-commerce professional with strong expertise in Excel, bulk report generation, data management, and process automation. The ideal candidate should be comfortable working with large datasets and developing efficient reporting and operational processes.

Key Responsibilities:

• Manage day-to-day e-commerce operations and reporting.
• Generate and manage bulk reports across e-commerce/marketplace platforms.
• Work extensively on MS Excel, including advanced formulas, Pivot Tables, VLOOKUP/XLOOKUP, and data analysis.
• Create and maintain Excel macros/VBA-based automation to reduce manual effort and improve reporting efficiency.
• Automate repetitive operational and reporting processes.
• Consolidate, clean, and analyze large datasets from multiple sources.
• Track key operational metrics, sales data, inventory, orders, and campaign performance.
• Prepare daily, weekly, and monthly MIS and performance reports.
• Identify data discrepancies and ensure data accuracy across reports.
• Develop dashboards and automated reporting formats for stakeholders.
• Work with internal teams and marketplace partners to resolve operational and data-related issues.
• Continuously identify opportunities for process improvement and automation.

Must Have :

• 1-2 years of experience in E-commerce Operations / MIS / Business Operations / Reporting.
• Strong Advanced Excel skills.
• Hands-on experience with Macros/VBA and report automation.
• Experience handling large/bulk datasets and bulk report generation.
• Strong understanding of MIS, data analysis, and reporting.
• Good attention to detail and problem-solving skills.
• Experience with marketplaces such as Amazon, Flipkart, and Blinkit is preferred.