Key Responsibilities
- Prepare and maintain daily, weekly, and monthly MIS reports.
- Collect, clean, validate, and analyze operational data.
- Develop and maintain Excel dashboards and trackers.
- Create reports using advanced Excel functions.
- Ensure data accuracy and timely submission of reports.
- Coordinate with different departments to collect required information.
- Monitor KPIs and highlight trends or discrepancies.
- Automate repetitive reporting tasks wherever possible.
- Maintain databases and ensure proper documentation.
- Support management with ad-hoc reports and data analysis.
Required Skills
- Excellent command of Microsoft Excel (Mandatory)
- Advanced Formulas (VLOOKUP, XLOOKUP, INDEX-MATCH, IF, SUMIFS, COUNTIFS, etc.)
- Pivot Tables & Pivot Charts
- Data Validation
- Conditional Formatting
- Dashboard Creation
- Data Cleaning & Data Analysis
- Strong analytical and logical thinking.
- Good understanding of MIS reporting.
- Attention to detail and accuracy.
- Ability to work under deadlines.
- Good communication and coordination skills.
Pay: Up to ₹25,000.00 per month
Work Location: Hybrid remote in Bhopal, Madhya Pradesh (Bhopal)
