Responsibilities
Prepare daily, weekly, and monthly MIS reports for management.
Create and maintain Excel-based dashboards and performance reports.
Use Advanced Excel formulas, Pivot Tables, VLOOKUP, XLOOKUP, and INDEX-MATCH.
Analyze data to identify trends, gaps, and performance indicators.
AutomKey ate repetitive reporting processes using Google Apps Script.
Develop interactive dashboards and reports using Looker Studio.
Collect, consolidate, validate, and maintain data from different departments.
Ensure data accuracy, consistency, and timely submission of reports.
Prepare ad-hoc reports and provide analytical support to management.
Required Skills
Minimum 2 years of experience in MIS reporting or data analysis.
Advanced Excel proficiency is mandatory.
Strong knowledge of formulas, Pivot Tables, lookup functions, and dashboard creation.
Practical knowledge of Google Apps Script and reporting automation.
Experience with Looker Studio and data visualization.
Strong analytical, problem-solving, and organizational skills.
Good communication skills and attention to detail.
Knowledge of the real estate, EPC, construction, or infrastructure industry will be preferred.
Rahul Jain’s MIS course knowledge is required.