Job Description

Key Responsibilities

Maintain, update, and manage daily, weekly, and monthly MIS reports

Collect, clean, validate, and analyze large datasets from multiple sources

Prepare management dashboards and performance reports using Excel

Generate automated reports using formulas, pivot tables, and macros (if applicable)

Track KPIs, productivity metrics, and operational data

Ensure data accuracy, consistency, and timely submission of reports

Explain reports and data trends clearly to internal stakeholders

Support departments such as HR, Sales, Finance, or Operations with MIS data

Maintain proper documentation and version control of reports

Required Skills & Competencies

Mandatory Technical Skills

Advanced Microsoft Excel (Strong Hands-on Knowledge) including:

VLOOKUP / HLOOKUP / XLOOKUP

INDEX & MATCH

Pivot Tables & Pivot Charts

Advanced formulas (IF, COUNTIF, SUMIF, TEXT, DATE functions)

Conditional Formatting

Data Validation

Excel Dashboards & Charts

Basic knowledge of MS Word and PowerPoint

Additional Skills (Good to Have)

Basic knowledge of Google Sheets

Understanding of MIS concepts and reporting formats

Exposure to basic Macros / VBA (added advantage)

Basic SQL or Power BI knowledge (optional)

Soft Skills

Strong analytical and problem-solving skills

High attention to detail and data accuracy

Good communication and presentation skills

Ability to meet deadlines and handle repetitive data tasks

Willingness to learn and adapt quickly

Preferred Candidate Profile

Fresher with certification or practical exposure to Advanced Excel

Internship or project experience in reporting or data analysis is a plus

Candidates willing to work in a fast-paced reporting environment

Job Types: Full-time, Permanent

Pay: ₹11,991.20 - ₹31,425.22 per month

Benefits:

Health insurance Provident Fund
Work Location: In person