MIS Intern

Job Overview

We are seeking an MIS Intern to assist in the preparation, maintenance, and updating of management information system reports, dashboards, and business performance indicators. This role involves handling large data sets for cleaning, organization, validation, and data analysis.

Key Responsibilities

• Prepare and keep updated MIS reports, dashboards, and business performance trackers.
• Manage large datasets by cleaning, organizing, validating, and analyzing data.
• Create automated reports utilizing advanced Excel features such as Pivot Tables, XLOOKUP/VLOOKUP, INDEX-MATCH, conditional formatting, and complex formulas.
• Develop visual dashboards to aid management decision-making.
• Explore and apply automation opportunities to repetitive reporting tasks using Python.
• Support data reconciliation efforts, ensure report accuracy, and standardize reporting formats.
• Collaborate cross-functionally to grasp reporting requirements and boost operational processes.

Skills and Qualifications

• Proficiency in advanced Excel functionalities including Pivot Tables, Lookup formulas, and conditional formatting.
• Experience working with and analyzing large datasets.
• Basic understanding of Python for automating data reporting tasks.
• Strong analytical mindset and attention to detail.
• Effective communication skills to liaise with various teams.