MIS Executive

About the Role

We are seeking a meticulous and analytical MIS Executive to be based at DLF Cyber City Sector 24, Gurgaon. The ideal candidate should have between 1 to 3 years of suitable experience. This role involves managing data efficiently, preparing regular and accurate management information system reports, maintaining dynamic MIS dashboards, and offering valuable business insights to inform strategic decisions.

Responsibilities

• Gather, consolidate, validate, and manage data sourced from various departments.
• Generate daily, weekly, and monthly MIS reports tailored for management review.
• Create and update Excel-based reports, interactive dashboards, and tracking tools.
• Track key performance indicators, identifying deviations and emerging trends.
• Ensure punctual and precise submission of all reporting deliverables.
• Maintain comprehensive and updated databases.
• Collaborate with multiple teams to collect necessary information.
• Perform data analysis to provide actionable insights to leadership.
• Implement automation techniques to streamline repetitive reporting tasks.
• Detect data inconsistencies and liaise with relevant parties for corrections.
• Keep documentation and report formats well organized and standardized.
• Support management with special reports and data investigations on an as-needed basis.

Required Skills

• Proficient in advanced Microsoft Excel functions: Pivot Tables, VLOOKUP/XLOOKUP, INDEX-MATCH, SUMIFS/COUNTIFS, IF formulas, conditional formatting, and chart/dashboard creation.
• Strong analytical thinking and problem-solving abilities.
• Meticulous attention to detail ensuring data accuracy.
• Effective communication and interpersonal coordination skills.
• Capability to manage large datasets efficiently.
• Familiarity with general MS Office applications.

Qualification

Graduation degree in any discipline.

Key Performance Indicators (KPIs)

• Accuracy and reliability of MIS reports.
• Timeliness in delivering required reports.
• Maintaining data integrity and completeness.
• Enhancing reporting automation and efficiency.
• Responsiveness to management’s reporting needs.