Job Summary
We are looking for a detail-oriented and motivated MIS Executive to join our team. The ideal candidate should have a good understanding of MS Excel, data management, reporting, and basic analysis.
The candidate will be responsible for preparing regular MIS reports, maintaining accurate data, updating trackers, analyzing information, and providing timely reports to management and different departments.
Key Responsibilities1. MIS Reporting
- Prepare daily, weekly, and monthly MIS reports as required.
- Collect data from different departments and consolidate it into standard formats.
- Maintain department-wise and employee-wise reports.
- Ensure reports are accurate and submitted within defined timelines.
- Prepare management reports based on business requirements.
2. Data Management
- Maintain and update Excel sheets, trackers, and databases.
- Enter and organize data accurately.
- Verify data received from different departments.
- Identify missing, duplicate, or incorrect information.
- Maintain proper records for future reference.
3. Data Analysis
- Analyze data and prepare basic summaries and comparisons.
- Track performance, targets, attendance, productivity, sales, and other operational data as assigned.
- Identify variations or discrepancies in reports.
- Highlight important observations to the reporting manager.
4. Excel & Dashboard Management
- Create and maintain Excel-based trackers and reports.
- Use basic Excel formulas and functions.
- Prepare tables, charts, and summaries for management review.
- Support the preparation of dashboards and automated reports.
- Maintain data in a structured and easy-to-understand format.
5. Team Coordination
- Coordinate with HR, Accounts, Sales, Operations, and other departments to collect required data.
- Follow up with team members for pending information.
- Ensure timely receipt of data for report preparation.
- Communicate any discrepancies or delays to the reporting manager.
6. Daily Work Updates
- Maintain daily work trackers.
- Submit daily/weekly work status reports.
- Complete assigned reporting activities within deadlines.
- Maintain confidentiality of company and employee data.
Required Knowledge
Candidates should have basic knowledge of:
- MS Excel
- Data Entry & Data Management
- MIS Reporting
- Basic Data Analysis
- Microsoft Word
- Email & Internet
- Google Sheets
Excel Skills Preferred
The candidate should be willing to learn and work with:
- VLOOKUP / XLOOKUP
- SUMIF / SUMIFS
- COUNTIF / COUNTIFS
- IF formulas
- Pivot Tables
- Filters & Sorting
- Conditional Formatting
- Charts & Graphs
- Data Validation
- Basic Dashboard Preparation
Pay: ₹15,000.00 - ₹18,000.00 per month
Work Location: In person
