Organization- Empower Pragati Learning Solutions Limited
Job Description- MIS Executive (2–3 Years’ Experience)
Role Overview
The MIS Executive will be responsible for managing data, generating reports, and supporting business decision-making through accurate and timely insights. The role requires strong proficiency in Advanced Excel, data handling, and basic analytics.
Key Responsibilities
Collect, clean, and maintain large datasets from multiple sources
Generate daily, weekly, and monthly MIS reports
Design and maintain dashboards for performance tracking
Automate recurring reports using Excel tools (Power Query, Macros if possible)
Validate data accuracy and ensure consistency across reports
Coordinate with cross-functional teams for data requirements
Identify trends, gaps, and anomalies in data
Support management with actionable insights
Required Skills (Core)
Advanced Excel (Mandatory)
Pivot Tables, Power Query, VLOOKUP/XLOOKUP, INDEX-MATCH
Data cleaning, conditional formatting, dashboards
Strong data management and data cleaning ability
Good understanding of reporting structures and KPIs
Basic knowledge of databases (SQL preferred but not mandatory)
Attention to detail and accuracy
Preferred / Good-to-Have Skills
Exposure to Power BI or any data visualization tool
Basic understanding of data analysis concepts (trend analysis, variance analysis)
Experience with automation (Macros / VBA – optional but valuable)
Familiarity with Google Sheets / Looker Studio
Understanding of business processes (sales, operations, finance, etc.)