MIS Specialist

We are looking for a detail-oriented and analytical MIS Executive with strong Microsoft Excel skills to manage, organize, and analyze business data. The ideal candidate should be able to prepare reports, maintain accurate records, generate insights, and support different departments with timely and reliable information.

Required Skills

• Excellent command of Microsoft Excel.
• Strong knowledge of:
• Pivot Tables
• XLOOKUP/VLOOKUP
• INDEX-MATCH
• IF, SUMIF, COUNTIF
• Conditional Formatting
• Data Validation
• Charts and Dashboards
• Power Query (preferred)
• Basic Macros/VBA (preferred)
• Good analytical and problem-solving skills.
• Strong attention to detail.
• Ability to work with large datasets.
• Good communication and coordination skills.
• Ability to meet deadlines and manage multiple tasks.

Key Responsibilities

• Prepare daily, weekly, and monthly MIS reports.
• Collect, verify, and maintain data from multiple departments.
• Analyze business data and present meaningful insights.
• Create and maintain Excel dashboards and trackers.
• Generate reports using Pivot Tables, VLOOKUP/XLOOKUP, INDEX-MATCH, IF formulas, and other advanced Excel functions.
• Perform data cleaning, validation, and reconciliation.
• Monitor inventory, sales, purchase, and operational reports.
• Coordinate with Sales, Accounts, Operations, and Management for data requirements.
• Ensure data accuracy, consistency, and confidentiality.
• Automate repetitive reporting processes wherever possible.
• Maintain proper documentation and report archives.