Data Analyst

Role & responsibilities

• Prepare daily, weekly, and monthly MIS reports for operational and management teams.
• Collect, clean, validate, and analyze data from multiple sources.
• Develop and maintain Excel-based dashboards, trackers, and performance reports.
• Monitor operational KPIs such as Turnaround Time (TAT), productivity, workload, and quality metrics.
• Generate ad-hoc reports and analytical insights as required by management.
• Ensure data accuracy, consistency, and completeness across reports.
• Automate repetitive reporting tasks using advanced Excel functions where possible.
• Coordinate with operations teams to gather data and resolve discrepancies.
• Identify trends, patterns, and opportunities for process improvement through data analysis.
• Maintain proper documentation of reports and MIS processes.

Preferred candidate profile

• Advanced MS Excel (Pivot Tables, XLOOKUP/VLOOKUP, INDEX-MATCH, IF, SUMIFS, COUNTIFS, Conditional Formatting, Data Validation).
• Experience in creating dashboards and MIS reports.
• Good understanding of data analysis and reporting techniques.
• Basic knowledge of Power Query, Power Pivot, or Excel automation is an added advantage.
• Familiarity with Power BI or SQL will be an added advantage.

Work Schedule

• Weekly rotational offs.
• Night Shifts
• No cab facility