Position: MIS Executive

Department: MIS / Operations

Location: Pune

Employment Type: Full-Time

Experience: 1–3 Years

Job Summary

We are looking for a detail-oriented and analytical MIS Executive with strong proficiency in Advanced Excel and Google Sheets. The candidate will be responsible for preparing daily, weekly, and monthly MIS reports, maintaining accurate data, analyzing business information, and providing timely reports and insights to management.

Key Responsibilities

- Prepare and maintain Daily, Weekly, and Monthly MIS Reports.
- Collect, verify, organize, and maintain data from various departments and branches.
- Create and maintain Excel and Google Sheets reports and dashboards.
- Use Pivot Tables, Pivot Charts, VLOOKUP/XLOOKUP, INDEX-MATCH, IF, SUMIF/SUMIFS, COUNTIF/COUNTIFS, and other advanced Excel functions.
- Prepare branch-wise, department-wise, and employee-wise reports.
- Analyze data and identify discrepancies, trends, and variations.
- Maintain accurate records and ensure data integrity.
- Generate reports related to Sales, Inventory, Attendance, HR, Payroll, and Operations.
- Consolidate data received from multiple branches and prepare management reports.
- Develop automated and easy-to-understand Excel reports wherever possible.
- Track pending reports and coordinate with concerned departments for timely data submission.
- Support management with data analysis and decision-making reports.
- Maintain proper documentation and version control of MIS files.
- Ensure all reports are accurate and submitted within the required timelines.

Required Skills – Advanced Excel
- Excellent knowledge of MS Excel.
- Advanced formulas and functions.
- Pivot Tables and Pivot Charts.
- VLOOKUP / XLOOKUP.
- INDEX & MATCH.




- IF / Nested IF.
- SUMIF / SUMIFS.
- COUNTIF / COUNTIFS.
- Conditional Formatting.
- Data Validation.
- Sorting & Filtering.
- Data Cleaning and Data Consolidation.
- Basic knowledge of Excel Dashboards and Charts.
- Knowledge of Power Query will be an added advantage.

Google Sheets
- Good knowledge of Google Sheets.
- Data sharing and collaboration.
- Formulas and Pivot Tables.
- Google Sheets reporting and data management.

Educational Qualification
- Graduate in B.Com, BBA, B.Sc., BCA, Mathematics, Statistics, or any relevant field.
- Candidates with a strong Mathematics or Statistics background will be preferred.

Candidate Profile
- Strong analytical and mathematical ability.
- Excellent attention to detail.
- Good numerical and logical reasoning skills.
- Ability to work with large volumes of data.
- Strong problem-solving skills.
- Valuable communication and coordination skills.
- Ability to meet deadlines.
- Comfortable handling multiple reports simultaneously.
- High level of accuracy in data entry and reporting.
- Ability to maintain confidentiality of company and employee information.

Preferred Experience Candidates with experience in MIS, Data Analysis, Reporting, Operations, HR MIS, Sales MIS, Inventory MIS, or Business Reporting will be preferred.

Experience Required: 1–3 Years

Key Performance Indicators (KPIs)

- Accuracy of MIS reports.
- Timely submission of reports.
- Data integrity and error-free reporting.
- Quality of data analysis.
- Timely identification of discrepancies.
- Automation and improvement of reporting processes.
- Responsiveness to management reporting requirements.

Why Join Us? Pay: ₹25,000.00 - ₹30,000.00 per month

Work Location: In person

📌 MIS Executive (Peth)
🏢 MB Ashtekar Jewellers
📍 Peth