Job Summary
The MIS Executive is responsible for collecting, managing, analyzing, and presenting organizational data to support business operations and decision-making. The role involves preparing accurate reports, maintaining databases, ensuring data integrity, and providing timely MIS reports to management.
Key Roles & Responsibilities
Data Management
- Collect, compile, and maintain data from various departments.
- Ensure data accuracy, consistency, and confidentiality.
- Update and maintain daily, weekly, and monthly MIS records.
- Verify and clean data before generating reports.
Report Preparation
- Prepare Daily, Weekly, Monthly, and Quarterly MIS reports.
- Generate dashboards and performance reports for management.
- Analyze business data and highlight trends, variances, and key insights.
- Present reports in a clear and professional format.
Excel & Data Analysis
- Create advanced Excel reports using Pivot Tables, VLOOKUP/XLOOKUP, HLOOKUP, INDEX-MATCH, IF formulas, Conditional Formatting, and Charts.
- Perform data validation and reconciliation.
- Automate repetitive reporting tasks wherever possible.
System & Database Management
- Maintain MIS databases and ensure timely updates.
- Coordinate with different departments to collect required information.
- Assist in ERP/CRM data entry and report generation.
- Maintain backup and security of organizational data.
Coordination
- Work closely with HR, Sales, Finance, Purchase, Production, and Operations teams.
- Provide reports required for management reviews and audits.
- Support management with ad hoc data analysis and reporting.
Qualifications
- Bachelor's Degree in B.Com, BBA, BCA, B.Sc (Computer Science/Mathematics/Statistics), or any relevant discipline.
- Certification in Advanced Microsoft Excel or Data Analytics is an added advantage.
Experience
- 1–3 years of experience as an MIS Executive or Data Analyst.
Required Skills
- Advanced Microsoft Excel (Pivot Tables, VLOOKUP/XLOOKUP, INDEX-MATCH, IF Functions, Charts)
- Microsoft Office (Word, PowerPoint)
Pay: ₹15,000.00 - ₹18,000.00 per month
Benefits:
Work Location: In person
