Key Responsibilities

- Collect, consolidate, clean, validate, and analyse data received from various University departments.
- Prepare IQAC-related MIS, analytical reports, dashboards, and management reports.
- Support data preparation for NAAC, NIRF, AISHE, NBA and other accreditation/ranking requirements.
- Use Python for data cleaning, analysis, automation, and processing of large datasets.
- Use Advanced MS Excel for data analysis, reconciliation, reporting, Pivot Tables, Pivot Charts, XLOOKUP/VLOOKUP, INDEX-MATCH, SUMIFS/COUNTIFS, and advanced formulas.
- Identify data discrepancies, duplication, missing information, and inconsistencies and coordinate with concerned departments for correction.
- Develop standardized data formats, templates, and reporting systems for different departments.
- Prepare trend analysis, comparative analysis, performance reports, and data summaries for IQAC and management.
- Automate repetitive data-processing and reporting activities using Python and Excel.
- Prepare charts, graphs, dashboards, and presentations for institutional performance analysis.
- Coordinate with Academic, Examination, HR, Admissions, Finance, Research, Student Affairs, and other departments for timely data collection.




- Maintain accurate records and documentation of institutional data.
- Ensure confidentiality, accuracy, consistency, and timely submission of institutional data.
- Support IQAC in accreditation, ranking, audit, quality assessment, and institutional review activities.
- Perform other data analysis and reporting responsibilities assigned by the Head – IQAC/Management.

Mandatory Skills
- Minimum 3 years of relevant experience in Data Analysis/MIS/Institutional Data Management.
- Strong hands-on knowledge of Python – Mandatory.
- Advanced MS Excel – Mandatory.
- Strong knowledge of data cleaning, validation, transformation, and analysis.
- Working knowledge of Pandas, NumPy and Matplotlib/Seaborn preferred.
- Experience in preparing MIS reports and dashboards.
- Strong analytical and problem-solving skills.
- Excellent attention to detail and data accuracy.
- Valuable communication and cross-functional coordination skills.

Preferred Experience Candidates having experience in Universities, Colleges, Higher Education Institutions, IQAC, NAAC/NIRF, Accreditation, Ranking Data, MIS or Institutional Data Analysis will be preferred.

Pay: ₹25,000.00 - ₹40,000.00 per year

Work Location: In person

📌 Data Analyst (Gurugram)
🏢 SGT University
📍 Gurugram