Job Overview
We are looking for a detail-oriented and analytical MIS Executive with strong expertise in Advanced MS Excel and data management. The candidate will be responsible for preparing MIS reports, analysing business data, maintaining dashboards, and providing actionable insights to support management decisions.
Key Responsibilities
- Prepare, maintain, and publish daily, weekly, and monthly MIS reports.
- Collect, consolidate, validate, and analyse data from multiple sources.
- Develop and maintain Excel-based dashboards and performance trackers.
- Handle large datasets and perform data analysis to identify trends and discrepancies.
- Prepare business performance reports, productivity reports, and operational trackers.
- Automate repetitive reporting processes to improve accuracy and efficiency.
- Coordinate with different departments to collect and validate required data.
- Ensure timely submission of reports to management.
- Maintain proper documentation and data accuracy across all MIS reports.
Required Skills & Qualifications
- Advanced MS Excel is mandatory.
- Strong command of:
- VLOOKUP / HLOOKUP / XLOOKUP
- INDEX & MATCH
- Pivot Tables & Pivot Charts
- IF, SUMIF, SUMIFS, COUNTIF, COUNTIFS
- Conditional Formatting
- Data Validation
- Advanced Excel Formulas
- Dashboard Creation & Data Visualization
- Knowledge of Power Query and Macros/VBA will be an added advantage.
- Good analytical and problem-solving abilities.
- Strong attention to detail and accuracy.
- Good communication and coordination skills.
- Ability to work with large volumes of data and meet deadlines.
Candidate Profile
- Graduate in any discipline (B.Com / BBA / BCA preferred).
- 24 years of relevant experience in MIS, Reporting, or Data Management.
- Should be highly proficient in Excel and comfortable handling complex data.