MIS Executive

1. Timely generation and distribution of all daily weekly and monthly MIS reports
2. Maintain data accuracy and consistency across systems and reports
3. Develop and update dashboards for key business functions
4. Support system integration data automation and BI tool usage
5. Ensure data compliance and reporting hygiene as per defined SOPs

Daily MIS Reporting Operations:

• Extract data from various source systems (LIMS CRM HRMS Sales Tool) as per report schedule. Validate raw data to remove duplicates mismatches or errors in logic/formulas
• Update daily trackers and share daily dashboards with relevant stakeholders (Sales Operations and other Teams). Follow defined cut-off times to publish morning dashboards to all stakeholders

Weekly & Monthly Reporting:

• Consolidate week-on-week trends and performance summaries geography/ business unit-wise function wise or channel wise.
• Consolidate monthly MIS covering revenue operations profitability HR etc Prepare monthly zone-wise channel-wise and function wise performance dashboards
• Perform variance analysis: actual vs. plan MOM YOY comparisons. Prepare summary insights for Monthly Business Review decks
• Ensure alignment with Finance-reconciled data and approved management figures.
• Maintain archives of all weekly and monthly reports with version control

Dashboard Management:

• Maintain and update live dashboards (in Power BI/Google Sheets) for key KPIs. Ensure formula accuracy and correct data linkages across data sources
• Work closely with MIS Manager for new dashboard creation or enhancement requests
• Troubleshoot errors delays or gaps in visualization or data refresh

Data Integration and Automation Support:

• Upload or sync data across systems (e.g. LIMS to Google Sheets or Power BI) Use basic automation tools (macros Power Query scripts) to eliminate redundant manual work
• Schedule auto-reporting via email or tool-based alerts wherever applicable
• Help the MIS Manager to create process documents and SOPs for recurring reports

Data Quality and Governance:

• Follow strict version control and naming convention for all reporting files. Regularly back up files and critical data on secured folders/cloud systems
• Maintain audit trails of data revisions uploads or changes
• Flag any major data mismatches across systems (e.g. Sales vs. LIMS vs. Finance)
• Ensure user access to reports is controlled and shared only with authorized individuals

• 100% on-time report delivery with zero manual errors
• Zero data mismatches across published reports
• Stakeholder satisfaction on usefulness and clarity of MIS reports
• % reduction in manual reporting efforts through automation
• Accuracy of real-time dashboards aligned with source data
• Timely closure of data-related tickets/queries

• 02 years of experience in MIS data analysis or reporting roles
• Proficiency in MS Excel (advanced formulas pivot tables) and basic knowledge of Power BI / Google Sheets dashboards
• Strong skills in data collection cleaning validation and report generation with high accuracy
• Understanding of business KPIs (revenue operations sales TAT etc.) and ability to prepare structured MIS reports
• Ability to manage multiple reports with strict timelines ensuring 100% on-time delivery and adherence to SOPs
• Good coordination and communication skills to follow up with stakeholders and ensure data accuracy across systems