MIS Executive

Key Responsibilities

1. MIS & Management Reporting

• Prepare daily, weekly, monthly and quarterly MIS reports.
  
• Develop operational, sales, financial, HR and performance reports.
  
• Consolidate data from Sales, Marketing and other departments.
  
• Prepare dashboards, KPI reports and variance analysis.
  
• Ensure accurate and timely reporting.
  

2. Data Management & Analysis

• Collect, consolidate, validate and reconcile data from multiple sources.
  
• Identify data discrepancies and coordinate corrections.
  
• Analyse data to identify trends, gaps and business insights.
  
• Maintain structured databases and reporting templates.
  
• Ensure data accuracy, integrity and confidentiality.
  

3. Excel & Dashboard Management

• Create advanced Excel reports using Pivot Tables/Charts, XLOOKUP/VLOOKUP, INDEX-MATCH, SUMIFS/COUNTIFS and IF/IFS.
  
• Develop charts, dashboards, conditional formatting and data validation.
  
• Use Power Query for data extraction and consolidation.
  
• Develop automated reporting templates to reduce manual effort.
  
• Knowledge of Power BI is an advantage.
  

4. KPI & Performance Tracking

• Maintain KPI and target trackers.
  
• Prepare Actual vs. Target, MoM and YoY analysis.
  
• Identify performance gaps and highlight key deviations.
  
• Provide data-backed insights for corrective action.
  

5. Process Improvement & Automation

• Identify manual/repetitive reporting tasks for automation.
  
• Standardize reporting formats and improve reporting processes.
  
• Reduce turnaround time and reporting errors.
  
• Maintain reporting documentation and version control.
  

6. Coordination & Stakeholder Management

• Coordinate with Sales, Operations, Finance, HR and Business Development teams.
  
• Follow up for pending or incorrect data.
  
• Understand business requirements and create meaningful reports.
  
• Handle ad-hoc reporting and management requirements.
  

Requirements

Required Skills

• Advanced MS Excel – Mandatory. Strong knowledge of Pivot Tables, XLOOKUP/VLOOKUP, INDEX-MATCH, SUMIFS/COUNTIFS, IF/IFS, Charts & Dashboards.
  
• Power Query – Preferred, Power BI – Advantage
  
• Basic SQL/database knowledge is an advantage.
  
• Strong data cleaning, analysis and reporting skills.
  

Analytical Skills

• Strong analytical and problem-solving ability.
  
• Ability to work with large datasets.
  
• Good attention to detail.
  
• Ability to identify discrepancies and investigate data issues.
  
• Ability to convert raw data into meaningful management insights.
  

Soft Skills

• Good communication and interpersonal skills.
  
• Strong follow-up and coordination skills.
  
• Ability to manage multiple reports and deadlines simultaneously.
  
• High level of accuracy and ownership.
  
• Ability to work independently with minimal supervision.
  
• Strong organizational and time-management skills.
  

Experience & Qualification

Experience:

• 3–4 years of relevant experience in MIS, Business Reporting, Data Analysis, Operations Analytics or a similar role.
  
• Experience in preparing management dashboards and recurring MIS reports.
  
• Experience working with large datasets and multiple data sources.
  
• Experience in reporting automation will be an advantage.
  

Education:

• Bachelor’s degree: Commerce, Business Administration, Statistics, Mathematics, Computer Applications, Economics, Engineering or a related field.
  
• MBA/PGDM or relevant analytical certification is an advantage.