Mis Executive

Manning Consulting; Gurugram District; On-site; INR 300,000 - 600,000; Full time

Job summary

Manning Consulting seeks an MIS Executive to drive business insights through data analytics and reporting. You will build dashboards, validate data, and automate reporting processes to improve decision-making across operations. Expertise in Advanced Excel, Power Query, VBA, and Power Automate is essential.

Collaborate with operational teams to streamline data workflows, enhance data integrity, and deliver scalable BI solutions using SharePoint, Forms, and Power BI.

Qualifications

• Advanced Excel with complex formulas, power query and modelling.
• Experience handling large datasets and validating data.
• Proficiency in automation tools like Power Automate and VBA.

Responsibilities

• Analyse operational, customer and business performance data to identify trends, risks, opportunities, and root causes.
• Translate data into insights and actionable recommendations for business decisions.
• Investigate issues with evidence-based solutions, not just reporting.
• Support operations by identifying process inefficiencies and improvement opportunities.
• Interpret data in business context and explain the implications.

Skills

Advanced Excel

Pivot Tables

Power Query

Data Modelling

Complex Formulas

Data validation

Power Automate

VBA

SharePoint

Microsoft Forms

Looker

Power BI

Tools

Power Automate

SharePoint

Microsoft Forms

Power BI

Tableau

Looker

Job description

JD for MIS Executive

Business Insight & Analysis

• Analyse operational, customer, and business performance data to identify trends, risks, opportunities, and root causes.


• Translate data into meaningful insights and recommendations that support business decisions.


• Proactively investigate issues and provide evidence-based solutions rather than simply reporting outcomes.


• Support operational teams by identifying process inefficiencies and improvement opportunities.


• Interpret data within the wider business context and explain the \"so what?\" behind the numbers.

Reporting & Data Management

• Develop, maintain, and enhance management information reports and dashboards.


• Ensure accuracy, consistency, and integrity of data used for reporting and analysis.


• Perform data validation, reconciliation, and quality assurance checks.


• Simplify and optimise existing reporting processes where possible.

Automation & Process Improvement

• Identify opportunities to reduce manual effort through automation.


• Develop and maintain solutions using:

• Advanced Excel


• Power Query


• VBA


• Power Automate


• Microsoft Forms


• SharePoint

• Support the implementation of automated reporting and workflow solutions.


• Continuously seek ways to improve efficiency, scalability, and user experience.

Ideal Candidate

Technical Skills

Essential

• Advanced Excel including:

• Pivot Tables


• Power Query


• Data Modelling


• Complex Formula Development

• Experience working with large datasets.


• Power Automate.


• VBA and Excel Automation.


• SharePoint and Microsoft Forms integration.


• Strong understanding of reporting and data validation processes.

Desirable

• Looker, Power BI, Tableau or similar visualisation tools.


• SQL


• Experience with AI-enabled tools such as Microsoft Copilot, Gemini or ChatGPT


• Knowledge of business process improvement methodologies.