MIS Executive

ProLegion; Gurugram District; On-site; INR 300,000 - 520,000; Full time

Job summary

ProLegion in Gurugram is seeking an MIS Executive with 2-3 years of MIS reporting experience. The role involves preparing weekly and monthly MIS reports, coordinating with PAN India branches, and maintaining accurate management reports using Google Sheets.

You will apply advanced Excel skills, work with Google Sheets, and develop MIS documentation to support smooth operations. Strong analytical skills and attention to detail are essential.

Qualifications

• 2-3 years of MIS reporting experience.
• Proven ability to independently prepare and manage MIS reports.
• Advanced Excel skills with Pivot Tables, VLOOKUP/XLOOKUP, INDEX-MATCH; Power Query preferred.
• Hands-on experience with Google Sheets.
• Ability to write and run basic Google Apps Script.
• Strong analytical, reporting, and problem-solving skills.

Responsibilities

• Prepare weekly and monthly MIS reports.
• Coordinate with PAN India branches to collect and consolidate data.
• Generate and maintain accurate management reports using Google Sheets.
• Provide support and maintenance for existing MIS systems.
• Develop and maintain MIS documentation for smooth operations.
• Recommend improvements to enhance reporting efficiency and consistency.
• Perform data analysis and prepare periodic reports for management.
• Develop MIS systems for customer management and internal communication.
• Provide analytical and reporting support to the management team.

Skills

Analytical thinking

Attention to detail

Reporting

Tools

Microsoft Excel

Google Sheets

Google Apps Script

Job description

Job Title: MIS Executive

Location: Gurugram

Experience: 2-3 Years

Key Responsibilities:

• Prepare weekly and monthly MIS reports.
• Coordinate with PAN India branches to collect and consolidate data.
• Generate and maintain accurate management reports using Google Sheets.
• Provide support and maintenance for existing MIS systems.
• Develop and maintain MIS documentation for smooth operations.
• Recommend improvements to enhance reporting efficiency and consistency.
• Perform data analysis and prepare periodic reports for management.
• Develop MIS systems for customer management and internal communication.
• Provide analytical and reporting support to the management team.

Requirements:

• 2-3 years of experience in MIS reporting.
• Proven ability to independently prepare and manage MIS reports.
• Advanced Microsoft Excel skills (Pivot Tables, VLOOKUP/XLOOKUP, INDEX-MATCH, Power Query preferred).
• Hands-on experience with Google Sheets.
• Ability to write and run basic Google Apps Script and filter-based automation.
• Strong analytical, reporting, and problem-solving skills.