Job Summary

We are looking for a detail-oriented and analytical MIS Executive to support our Amazon Advertising Operations Team in Mumbai. The role will be responsible for preparing daily, weekly, and monthly MIS reports, tracking operational and advertising performance, maintaining data accuracy, and providing actionable insights to the Operations and Management teams. The ideal candidate should have strong Advanced Excel skills, excellent attention to detail, and the ability to work with large datasets and multiple performance metrics.

Responsibilities

- MIS Reporting : Prepare and publish Daily, Weekly, and Monthly MIS reports for the Amazon Advertising team. Track team productivity, performance, attendance, login adherence, and operational KPIs. Prepare dashboards and performance reports for management review. Consolidate data from multiple sources and ensure timely reporting. Maintain daily trackers and operational databases. Identify data discrepancies and coordinate with relevant teams for correction. Maintain historical MIS records and ensure proper version control.
- Amazon Advertising Reporting : Track key advertising campaign metrics and prepare performance reports. Monitor campaign-level and team-level performance. Prepare reports covering metrics such as: Ad Spend, Sales / Revenue, Impressions, Clicks, CTR, CPC, Conversion Rate, ACOS, ROAS. Campaign Performance. Support the Operations and Amazon Advertising teams with data required for performance reviews. Highlight performance trends, deviations, and exceptions to the management team.
- Data Analysis : Analyze large datasets to identify trends, gaps, and performance deviations.



Prepare variance analysis against targets and previous periods. Identify productivity and performance gaps at individual and team levels. Provide actionable insights to Operations Managers and Team Leaders. Develop automated reports wherever possible to reduce manual effort.
- Dashboard Automation : Develop and maintain Excel dashboards and management reports. Use Pivot Tables, Pivot Charts, VLOOKUP / XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, IF formulas, and other advanced Excel functions. Automate repetitive MIS activities using Excel formulas, Power Query, macros/VBA, or other available tools. Maintain data validation and reporting accuracy.
- Operations Support : Coordinate with Team Leaders, Operations Managers, and other stakeholders for daily reporting requirements. Provide ad-hoc reports and analysis as requested by management. Support workforce and productivity analysis. Track SLA, productivity, utilization, absenteeism, shrinkage, and other operational parameters. Escalate reporting gaps or unusual performance trends on time.
- Key Performance Indicators (KPIs) : 100% accuracy of MIS reports. Timely submission of Daily / Weekly / Monthly reports. Data reconciliation and error-free reporting. Accuracy of campaign and operational performance analysis. Timely identification of performance deviations.



Reduction in manual reporting effort through automation. Stakeholder satisfaction with MIS and analytical support.

Requirements Qualifications

Educational Qualification

- Graduate in B.Com / BBA / BBM / B.Sc / BCA / Statistics / Mathematics / Computer Applications or any relevant discipline.
- Additional certification in Advanced Excel, Power BI, Data Analytics, or MIS is an advantage.

Experience

- 2-3 years of experience in MIS, Reporting, Business Analytics, Operations MIS, or a similar role.
- Experience in BPO / ITES / E-commerce / Amazon / Digital Advertising is preferred.
- Candidates with experience handling large operational datasets will be preferred.

Preferred Candidate Profile

- The candidate should be: Highly analytical and data-driven.
- Comfortable working with large volumes of data.
- Robust in Excel and reporting automation.
- Detail-oriented with a high level of accuracy.
- Proactive in identifying reporting gaps.
- Able to work under deadlines.
- Comfortable working with multiple stakeholders.
- Willing to support business requirements during peak periods.

Location

Mumbai, Maharashtra

Skills

- Advanced MS Excel
- Pivot Tables
- Pivot Charts
- Vlookup / xlookup
- Index match
- Sumifs / countifs
- IF formulas
- Power Query
- Power BI

Disclaimer: This job posting and Location has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.

📌 MIS Executive - Amazon Advertising - Mumbai (Bengaluru)
🏢 Grassroots BPO
📍 Bengaluru