MIS Executive

MIS & Reporting

• Prepare and maintain daily, weekly, monthly, and quarterly MIS reports covering sales, business performance, productivity, quality, and other key operational metrics.
• Consolidate data from multiple sources and ensure timely and accurate reporting.
• Maintain and update MIS trackers, dashboards, and reporting templates.
• Monitor business performance against defined targets and highlight key deviations.
• Ensure accuracy, completeness, and consistency of data across all reports.
• Publish regular performance reports to relevant stakeholders within defined timelines.

Data Analysis & Insights

• Analyse sales and operational data to identify trends, gaps, anomalies, and performance issues.
• Prepare variance analysis comparing actual performance against targets, budgets, or previous periods.
• Generate meaningful insights from data to support business and operational decision-making.
• Track key performance indicators (KPIs) at centre, team, and employee levels.
• Support management with ad-hoc reports and analysis as required.

Excel & Dashboard Management

• Develop and maintain Excel-based reports, trackers, dashboards, and analytical models.
• Use advanced Excel functions such as VLOOKUP/XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, IF functions, Pivot Tables, Pivot Charts, and data validation.
• Clean, format, and organize large datasets for reporting and analysis.
• Automate repetitive reporting activities wherever possible using Excel.
• Maintain data structures and templates to improve reporting efficiency.

Data Quality & Process Management

• Conduct regular checks and audits to ensure the accuracy and authenticity of business data.
• Identify discrepancies in source data and coordinate with relevant teams for resolution.
• Maintain proper documentation of reporting formats, data sources, and MIS processes.
• Ensure adherence to reporting timelines and defined SOPs.
• Continuously identify opportunities to improve and simplify MIS processes.

Business Coordination

• Coordinate with Sales, Operations, Finance, and other relevant teams to collect and validate data.
• Follow up with stakeholders for missing or inaccurate information.
• Support business teams with relevant data and reports for reviews and decision-making.
• Prepare periodic management reports and presentations highlighting key performance trends and observations.

Metabase / BI Reporting Added Advantage

• Experience with Metabase or similar BI/reporting tools will be an added advantage.
• Ability to create basic dashboards, reports, filters, and data visualizations.
• Understanding of SQL and working with databases will be a plus.
• Support the team in migrating manual Excel-based reports to automated dashboards where required.

Ideal Candidate Profile

• Education: Graduate in any discipline; MBA/PGDM or equivalent will be an added advantage.

Experience: 1–3 years of experience in MIS, reporting, business analysis, sales operations, or a similar role.