Mis Executive

Kairos Human Consulting Panchkula; Chandigarh; On-site; INR 350,000 - 550,000; Full time

Job summary

Kairos Human Consulting Panchkula in Chandigarh, India, seeks an MIS Analyst to convert raw data into structured MIS reports, design and maintain dashboards, and perform data analysis to uncover trends and opportunities. Proficiency in Excel/Google Sheets and advanced formulas is required, with the ability to handle large datasets.

The role focuses on building reliable reporting workflows and actionable insights for business decisions, using dynamic dashboards and well-structured reports.

Qualifications

• Proficiency in Excel and Google Sheets is essential.
• Strong knowledge of formulas such as VLOOKUP, INDEX-MATCH, SUMIFS/COUNTIFS, IF/IFS, COUNTIF and ARRAYFORMULA.
• Ability to handle large datasets efficiently.

Responsibilities

• Convert raw data into structured MIS reports.
• Design, develop, and maintain dynamic dashboards and reports.
• Perform data analysis to identify trends, discrepancies, and business opportunities.

Skills

Excel

Google Sheets

VLOOKUP

INDEX-MATCH

SUMIFS

COUNTIFS

IF

IFS

COUNTIF

ARRAYFORMULA

Large datasets

Job description

1. Convert raw data into structured MIS reports.
2. Design, develop, and maintain dynamic dashboards and reports.
3. Perform data analysis to identify trends, discrepancies, and business opportunities.

Required Candidate profile

1. Strong in Excel/Google Sheets
2. Knowledge about Formulas like VLOOKUP / INDEX-MATCH, SUMIFS / COUNTIFS, IF / IFS, COUNTIF and ARRAYFORMULA
3. Ability to work with large datasets