Job Title: MIS Manager

Role Summary

The MIS Manager is responsible for managing reporting systems, ensuring data accuracy, generating business insights, and supporting management with timely, data-driven reports for decision-making. Someone with solid Excel and Advance Excel.

Key Responsibilities:

1. MIS & Reporting

- Prepare daily, weekly, and monthly MIS reports and dashboards.
- Generate sales, collections, inventory, and performance reports.
- Automating recurring reports for efficiency and consistency.
- Ensure timely circulation of reports to stakeholders.

2. Data Management & Validation

- Validate and reconcile data between CRM, ERP, finance, and sales systems.
- Identify discrepancies and ensure data integrity.
- Maintain master databases and enforce data hygiene standards.

3. Business Analysis & Insights

- Analyze trends, performance metrics, and KPIs.
- Provide actionable insights to improve operational performance.
- Support forecasting, budgeting, and performance tracking.

4. Process Improvement & Automation

- Develop and enhance MIS formats and reporting systems.
- Automating repetitive tasks using Excel automation tools.
- Recommend improvements to improve reporting efficiency.

5. Stakeholder Coordination

- Coordinate with Sales, Finance, Operations, and Management teams.
- Provide ad-hoc reports and analytical support.
- Assist in audit requirements and compliance reporting.

Advanced Excel & Technical Expertise (Mandatory)

Advanced Functions & Formulas

- Lookup & Reference:



XLOOKUP, VLOOKUP, HLOOKUP, INDEX-MATCH
- Conditional Logic: IF, IFS, SUMIF, COUNTIF, AVERAGEIF
- Advanced Aggregations: SUMIFS, COUNTIFS
- Dynamic Functions: FILTER, SORT, UNIQUE
- Text Functions: LEFT, RIGHT, MID, TRIM, LEN, CONCAT, TEXT
- Date Functions: EOMONTH, TODAY, NETWORKDAYS, DATEDIF
- Error Handling: IFERROR, ISERROR

Data Analysis & Reporting

- Pivot Tables & Pivot Charts
- Power Query for data transformation
- Data validation & conditional formatting
- Dashboard creation & visualization

Automation & Efficiency

- Macro recording & basic VBA knowledge (preferred)
- Data consolidation from multiple sources
- Report automation and template design

Key Skills & Competencies

- Strong analytical and problem-solving ability
- High attention to detail and data accuracy
- Strong business understanding and reporting logic
- Ability to handle large datasets efficiently
- Effective communication and coordination skills

Experience

- 4–7 years of MIS/data reporting experience in Real Estate Industry
- Experience in sales operations, real estate, or finance reporting preferred

Key Performance Indicators (KPIs)

- Accuracy and timeliness of MIS reports
- Reduction in manual reporting through automation
- Data discrepancy resolution turnaround time
- Quality and usefulness of insights delivered
- Stakeholder satisfaction and response time

Pay: ₹800,000.00 - ₹1,300,000.00 per year

Work Location: In person

📌 MIS Manager (India)
🏢 PMG JOBS
📍 India