About the Role
We are looking for a detail-oriented and analytical Sales MIS Executive to support our sales team with accurate and timely reporting, data management, and performance analysis.
The ideal candidate should have strong MS Excel skills, good analytical ability, attention to detail, and the ability to work with large volumes of sales data and prepare meaningful reports for management.
Key Responsibilities
- Prepare daily, weekly, and monthly sales MIS reports.
- Collect, consolidate, verify, and maintain sales data from different sources.
- Track sales targets, achievements, revenue, orders, leads, conversions, and other key sales KPIs.
- Prepare sales performance reports for management and sales teams.
- Monitor individual and team-wise sales performance against targets.
- Maintain and update sales databases, trackers, and dashboards.
- Identify data discrepancies and coordinate with sales teams to resolve them.
- Prepare region-wise, product-wise, salesperson-wise, and channel-wise sales reports.
- Track leads, follow-ups, conversions, pending orders, and other sales activities.
- Maintain proper documentation and ensure data accuracy and confidentiality.
- Support the sales team in planning, forecasting, and performance tracking.
- Automate repetitive reporting tasks wherever possible.
- Coordinate with Sales, Operations, and other departments for data collection and reconciliation.
Required Skills
- Strong knowledge of MS Excel is essential.
- Good understanding of Pivot Tables, VLOOKUP/XLOOKUP, SUMIF/SUMIFS, COUNTIF/COUNTIFS, IF formulas, filters, sorting, and charts.
- Experience in preparing MIS reports and dashboards.
- Strong analytical and problem-solving skills.
- Excellent attention to detail and accuracy.
- Good communication and coordination skills.
- Ability to manage multiple reports and deadlines.
- Basic knowledge of CRM/ERP systems will be an advantage.
- Knowledge of Power BI or other reporting tools will be an added advantage.
Key Performance Indicators (KPIs)
- Accuracy and timeliness of MIS reports.
- Sales data accuracy and completeness.
- Timely submission of daily/weekly/monthly reports.
- Quality of sales dashboards and analysis.
- Reduction of manual reporting errors.
- Responsiveness to management and sales-team reporting requirements.
Educational Qualification
Bachelor's degree in Commerce, Business Administration, Statistics, Computer Applications, or a related field.
Preferred Candidate Profile
- 1–3 years of relevant experience in Sales MIS / MIS Executive / Sales Coordinator / Business Analyst roles.
- Strong Excel and data-handling skills.
- Comfortable working with large datasets.
- Highly organized and detail-oriented.
- Ability to work under pressure and meet reporting deadlines.
- Proactive approach toward identifying data issues and improving reporting processes.
Pay: ₹20,000.00 - ₹25,000.00 per month
Work Location: In person