Job Requirements

- Minimum 2 years of proven experience as an MIS Executive is mandatory.
- Hands-on experience in preparing and maintaining Sales Performance Dashboards.
- Experience in handling sales and marketing data, reports, and performance analytics.
- Strong expertise in Advanced Microsoft Excel.

Key Responsibilities

1. MIS Reporting & Dashboard Management

- Design, develop, and maintain daily, weekly, and monthly MIS reports.
- Prepare and manage sales performance dashboards using MS Excel.
- Track key business metrics, including leads, calls, conversions, sales, revenue, targets, and productivity.
- Develop team-wise, TL-wise, BDE-wise, and individual performance reports.
- Maintain automated reporting systems to improve reporting efficiency and accuracy.

2. Sales & Marketing Analytics

- Monitor sales performance against assigned targets.
- Analyse lead generation, lead conversion, follow-ups, and sales productivity.
- Prepare marketing performance reports, including lead sources, campaign performance, CPL, and conversion rates.
- Identify performance gaps and provide data-driven insights to management.
- Track daily sales activities and monitor target achievements.

3. Data Management & Analysis

- Collect, consolidate, validate, and maintain large volumes of data.
- Ensure data accuracy, consistency, and timely reporting.
- Identify discrepancies and coordinate with respective teams for corrections.
- Maintain structured databases and ensure proper data management.
- Handle multiple reporting requirements simultaneously.

4. Management Support & Coordination

- Prepare performance reports and presentations for management reviews.




- Provide actionable insights to support business decisions.
- Coordinate with Sales, Marketing, and Operations teams for data collection and reporting.
- Handle urgent reporting requirements and multiple tasks within deadlines.

Required Technical Skills

- Advanced MS Excel: Pivot Tables, VLOOKUP, XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, IF, nested formulas, conditional formatting, data validation, etc.
- Dashboard Development: Interactive sales and marketing dashboards, KPI tracking, charts, and performance analysis.
- Data Management: Data cleaning, data validation, data consolidation, and large dataset handling.
- Reporting: Automated MIS reports and management reporting.
- Additional Advantage: Advance Excel, Google Sheets, SQL

Required Competencies

- Solid analytical and problem-solving skills.
- Excellent attention to detail and data accuracy.
- Ability to multitask and manage multiple reporting requirements.
- Good time management and deadline-handling skills.
- Strong communication and coordination skills.
- Ability to work independently and take ownership of MIS activities.
- Ability to handle confidential business information responsibly.

Preferred Candidate Profile

- Candidates with experience in Sales MIS, Sales Operations, or Marketing Analytics will be preferred.
- Practical experience in developing sales dashboards and analysing business performance is essential.
- Candidates should be able to independently manage end-to-end MIS reporting activities.

Pay: Up to ₹30,000.00 per month

Education:

- Bachelor's (Required)

Experience:

- MIS: 2 years (Required)

Work Location: In person

📌 Sr. MIS Executive (Palarivattom)
🏢 Edtech institution
📍 Palarivattom