The MIS Executive is responsible for collecting, analyzing, maintaining, and presenting business data to support management decision-making. The role requires advanced Microsoft Excel skills, excellent analytical ability, and accuracy in preparing reports, dashboards, and data analysis.
Key Responsibilities
- Prepare daily, weekly, and monthly MIS reports.
- Analyze sales, service, inventory, finance, and operational data.
- Create and maintain Excel dashboards for management reporting.
- Generate reports using formulas, Pivot Tables, Pivot Charts, and advanced Excel functions.
- Verify data accuracy and identify discrepancies.
- Consolidate data from multiple sources into meaningful reports.
- Track KPIs and prepare performance analysis reports.
- Coordinate with different departments to collect and validate data.
- Maintain and update databases and reporting formats.
- Support management with ad-hoc reports and business analysis.
- Ensure timely submission of all scheduled MIS reports.
- Maintain confidentiality of business data.
Required Excel Skills
- Advanced Excel Formulas (VLOOKUP, XLOOKUP, INDEX-MATCH)
- Pivot Tables & Pivot Charts
- Conditional Formatting
- IF, SUMIF, COUNTIF, IFS Functions
- Data Validation
- Lookup & Reference Functions
- Text Functions
- Date & Time Functions
- Excel Dashboards
- Data Cleaning and Data Analysis
- Charts & Graphs
- Power Query (Preferred)
- Basic Macros/VBA (Preferred)
Required Skills
- Strong analytical and problem-solving skills.
- Excellent knowledge of Microsoft Excel.
- Good understanding of MIS reporting and data management.
- High level of accuracy and attention to detail.
- Strong communication and coordination skills.
- Ability to work under deadlines.
- Good knowledge of MS Office applications.
Pay: ₹18,000.00 - ₹22,000.00 per month
Work Location: In person
