Job Summary

We are looking for a detail-oriented and analytical MIS Executive with strong hands-on experience in Advanced Excel, data analysis, MIS reporting, dashboards, and sales analytics. The candidate will be responsible for preparing daily, weekly, and monthly MIS reports, analyzing business data, maintaining databases, and providing actionable insights to the Sales and Management teams.

The ideal candidate should have excellent command of Advanced Excel, be comfortable working with large datasets, and have the ability to automate recurring reports and dashboards.

Key Responsibilities

MIS & Reporting
- Prepare daily, weekly, and monthly MIS reports for Sales and Management.
- Maintain and update various business and sales databases.
- Generate sales performance reports by:
- Region
- State
- Territory
- Distributor
- SKU
- Salesperson
- Channel
- Track Primary Sales, Secondary Sales, Target vs. Achievement and Growth.
- Prepare management dashboards and business review reports.
- Ensure accuracy and timely submission of all MIS reports.

Advanced Excel




- Robust hands-on experience in Advanced Excel is mandatory.
- Work extensively with:
- Pivot Tables & Pivot Charts
- XLOOKUP / VLOOKUP / HLOOKUP
- INDEX & MATCH
- SUMIFS / COUNTIFS
- IF / IFS / Nested IF
- TEXT, DATE & logical functions
- Conditional Formatting
- Data Validation
- Advanced Filters
- Dynamic Tables
- Excel Dashboards
- Use Power Query for data cleaning, transformation, and consolidation.
- Automate repetitive reports using Excel-based solutions.
- Develop user-friendly dashboards for management review.

Sales Analytics
- Track sales targets versus actual achievement.
- Analyze sales trends and identify gaps.
- Prepare salesperson and territory-wise productivity reports.
- Track SKU-wise sales performance.
- Analyze distributor-wise performance.
- Identify high-performing and underperforming territories.
- Prepare sales growth and variance analysis.

Data Management
- Maintain accurate and up

📌 Mis Executive (Mumbai)
🏢 Keya Foods International
📍 Mumbai