MIS - Sr. Executive - Noida

Key Responsibilities

1. MIS & Data Management

Manage end-to-end MIS, dashboards, trackers, reports, and data inputs for Sales Operations.

Prepare daily, weekly, and monthly sales performance reports.

Analyze Target vs. Achievement, productivity, revenue, sales activity, and other business KPIs.

Ensure data accuracy, completeness, and timely delivery of reports.

Identify data gaps, inconsistencies, and process issues and coordinate with relevant teams for

resolution.

Convert raw data into meaningful insights to support business decisions.

2. Sales Performance & Incentive Reporting

Prepare and maintain Target vs. Achievement reports for Sales employees and leaders.

Design and manage MIS for incentives, KRAs, KPIs, and performance-based programs.

Calculate and validate employee eligibility and achievement against defined incentive criteria.

Track incentive performance and identify gaps or exceptions.

Coordinate with Sales and other stakeholders to resolve incentive-related queries and discrepancies.

3. Contest & Engagement Program Management

Support the design, implementation, and reporting of Sales Contests, Spot Incentives,

Recognition & Rewards (RnR), and engagement programs.

Prepare contest eligibility, achievement, qualification, and payout reports.

Track contest performance and communicate progress to relevant stakeholders.

Analyze the impact of contests and incentive programs on Sales performance.

Ensure accurate and timely closure of contest and incentive reports.

4. Advanced Excel & Google Sheets

Develop and maintain complex reports using Advanced Excel and Google Sheets.

Use advanced formulas, Pivot Tables, Lookups, conditional logic, data validation, and other reporting

techniques.

Automate repetitive reporting activities wherever possible using Excel/Google Sheets capabilities.

Handle large datasets and perform data cleansing, reconciliation, and analysis.

Build user-friendly trackers and dashboards for business teams.

5. Sales Team Coordination

Coordinate regularly with Sales employees, Team Leaders, Managers, and other stakeholders to

collect and validate business data.

Understand business requirements and translate them into effective MIS/reporting solutions.

Follow up on pending data, inputs, and actions to ensure timely report closure.

Handle day-to-day queries related to reports, performance, targets, achievements, incentives, and

contests.

Maintain clear communication with stakeholders and escalate critical issues when required.

6. Process Improvement

Identify opportunities to improve existing reporting and operational processes.

Develop new trackers, reports, and automated solutions to reduce manual effort.

Coordinate with Data/Tech and other cross-functional teams for system or process improvements.

Maintain proper documentation of reporting processes, business rules, and data requirements.

7. Roadmap & Productivity Tracking

Track key business initiatives and ensure timely completion of assigned activities.

Monitor pending actions and follow up with respective stakeholders.

Support productivity improvement initiatives for Sales employees and leaders through data-driven

analysis.

Provide regular updates on progress, gaps, and key observations.

Required Skills

Must Have:

Strong knowledge of Advanced Excel

Strong knowledge of Google Sheets

Excellent understanding of Pivot Tables, Lookup formulas, IF/AND/OR logic, SUMIFS/COUNTIFS,

FILTER, QUERY and other advanced formulas

Good data analysis and reporting skills

Experience in preparing Target vs. Achievement reports

Experience with Sales MIS / Incentive / KRA / KPI reports

Strong coordination and follow-up skills

Good attention to detail and data accuracy

Ability to handle multiple reports and deadlines

Strong problem-solving approach

Quick learner with the ability to understand new processes and business requirements quickly

Good to Have:

Basic knowledge of Power BI

Basic knowledge of SQL

Experience with VBA/Excel automation

Experience working with Sales Force Automation (SFA) or CRM systems

Experience in Sales Operations / Business MIS

Interested Candidates can share their resume at [email removed]