MIS Executive

Key Responsibilities

• Prepare and maintain daily, weekly, and monthly MIS reports.
• Collect, consolidate, and validate data from different departments.
• Maintain accurate and updated databases and Excel records.
• Analyze data and prepare management reports.
• Prepare Achievement, Performance, Sales, Productivity, and Variance reports.
• Identify data discrepancies, errors, and missing information and coordinate for corrections.
• Create and maintain Excel dashboards, Pivot Tables, charts, and trackers.
• Maintain proper documentation and reporting formats.
• Coordinate with internal departments for timely data collection.
• Monitor key performance indicators (KPIs) and prepare performance summaries.
• Provide data and reports to management whenever required.
• Ensure confidentiality and accuracy of business information.
• Support management in data analysis and decision-making through meaningful reports.

Required Skills

• Strong knowledge of MS Excel.
• Good knowledge of VLOOKUP, XLOOKUP, INDEX-MATCH, IF, SUMIFS, COUNTIFS, Pivot Tables, Charts, and Conditional Formatting.
• Knowledge of Excel Dashboards and Data Visualization.
• Good analytical and numerical skills.
• Strong attention to detail.
• Good communication and coordination skills.
• Ability to handle large volumes of data.
• Good time-management and organizational skills.