MIS Executive – Amazon Advertising - Mumbai

Grassroots Solutions & Services; Hinoba-an; On-site; PHP 398,000 - 597,000; Full time

Job summary

Grassroots Solutions & Services is seeking a detail-oriented MIS Executive to support our Amazon Advertising Operations Team in Mumbai. You will prepare daily, weekly, and monthly MIS reports, track KPIs, and maintain data accuracy.

The role requires advanced Excel skills, dashboards, and the ability to handle large datasets. You will collaborate with Operations Managers and provide actionable insights to drive performance.

Qualifications

• 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.

Responsibilities

• 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.

Skills

Advanced MS Excel

Pivot Tables

Pivot Charts

VLOOKUP/XLOOKUP

INDEX-MATCH

SUMIFS/COUNTIFS

Data Validation

Excel Dashboards

Power Query

Power BI

SQL basics

Education

Graduate in B.Com / BBA / BBM / BSc / BCA / Statistics / Mathematics / Computer Applications

Tools

Power BI

Power Query

SQL

Job description

Others 2–3 years in MIS, Reporting, Business Analytics, Operations MIS, Closed

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.

Key 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
• 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.
• 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.

Required Skills

Technical Skills

• Advanced MS Excel – Mandatory

Strong knowledge of:

INDEX & MATCH

SUMIFS / COUNTIFS

• Conditional Formatting
• Data Validation
• Excel Charts & Dashboards
• Knowledge of Power Query is preferred.
• Knowledge of Power BI is an added advantage.
• Basic knowledge of SQL or database reporting is an advantage.

Analytical Skills

• Strong analytical and problem-solving ability.
• Ability to interpret large datasets.
• Strong attention to detail.
• Ability to identify data inconsistencies and trends.
• Good understanding of performance metrics and targets.

Communication Skills

• Good written and verbal communication skills.
• Ability to present reports and insights clearly to management.
• Ability to coordinate effectively with Operations, Team Leaders, and other stakeholders.

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.
• Strong 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.