Key Responsibilities
• Manage and maintain large datasets with high accuracy.
• Prepare daily, weekly, and monthly MIS reports.
• Create and manage Pivot Tables, Pivot Charts, and Dashboards.
• Use advanced Excel functions such as VLOOKUP, HLOOKUP, XLOOKUP, INDEX-MATCH, IF, SUMIF, COUNTIF, IFERROR, and Logical Functions.
• Perform data cleaning, validation, sorting, filtering, and reconciliation.
• Generate reports and present data in a clear and organized format.
• Ensure accuracy and consistency of records.
• Coordinate with internal teams to collect and update data.
• Identify discrepancies and suggest improvements in reporting processes.
Required Skills
• Advanced Microsoft Excel
• Pivot Tables & Pivot Charts
• VLOOKUP, HLOOKUP & XLOOKUP
• INDEX-MATCH
• IF, SUMIF, COUNTIF & IFERROR
• Data Validation & Conditional Formatting
• MIS Reporting
• Dashboard Creation
• Data Cleaning & Data Analysis
• Basic Google Sheets knowledge
Qualifications
• Graduate in any discipline (B.Com, BBA, BCA, M.Com preferred).
• Certification in Advanced Excel will be an added advantage.
Experience Requirements
• Minimum 6 months of experience in Advanced Excel, MIS Reporting, or Data Management.
• Ability to work independently and maintain data accuracy.
Preferred Candidate Profile
• Strong analytical and logical thinking.
• Excellent attention to detail.
• Good communication and coordination skills.
• Proficient in handling large volumes of data.
• Ability to meet deadlines in a fast-paced work environment.
Perks & Benefits
• Professional growth opportunities.
• Skill development and on-the-job training.
• Supportive and collaborative work environment.