Mis Analyst

• Experience: 2 to 5 years of proven experience in MIS reporting, data analysis, or business intelligence roles.
• Technical Proficiency:
• Advanced Excel: Pivot Tables, XLOOKUP/VLOOKUP, Power Query, and Macros/VBA.
• Data Visualization: Proficiency in Power BI or Tableau.
• Database & Querying: Solid working knowledge of SQL for data extraction and manipulation.

Key Responsibilities

• Report Generation & Dashboards: Design, develop, and maintain automated daily, weekly, and monthly MIS reports and interactive dashboards using Excel and BI tools.
• Data Integration & Cleaning: Extract, consolidate, and validate data from multiple internal systems, ERPs, and departmental inputs.
• Trend & Variance Analysis: Analyze operational metrics, sales performance, or financial flows to highlight exceptions, risks, and growth opportunities.
• Ad-Hoc Reporting: Respond quickly to urgent data requests from senior management with accurate, well-formatted summaries.
• System & Data Quality Control: Ensure compliance with data security, access controls, and internal audit standards.
• Stakeholder Coordination: Collaborate with cross-functional teams (Operations, Finance, Sales, IT) to resolve data discrepancies and refine reporting requirements.