Mis Specialist

Adissia Developers; Coimbatore District; On-site; INR 800,000 - 1,200,000; Full time

Job summary

Adissia Developers in Coimbatore is seeking an experienced MIS lead to manage sales, collections, and data integrity for real estate projects. You will design Excel dashboards, automate MIS templates, and build BI dashboards using Power BI or SQL to support management reviews.

The role requires 5+ years in MIS reporting in real estate or construction, advanced Excel skills, and familiarity with CRM/ERP systems.

Qualifications

• 5+ years MIS reporting experience in real estate, advisory, or construction.
• Advanced MS Excel with Pivot Tables, VLOOKUP, XLOOKUP, Index-Match, Macros/VBA, Power Query.
• BI/tools: Power BI, Tableau, or Google Data Studio knowledge.
• SQL or Google Sheets App-Script knowledge.
• CRM/ERP familiarity with real estate workflows.

Responsibilities

• Track daily/weekly/monthly sales performance, site visits, lead conversions, bookings, cancellations, and subventions.
• Maintain project-wise inventory charts (available, blocked, sold, and registered).
• Monitor milestone-wise customer collections, payment-plan compliance, and variances.
• Track project budgets, actual expenditures, and cost-to-completion with finance.
• Design, build, and maintain Excel dashboards and MIS templates for management reviews.
• Integrate and build BI dashboards using Power BI or SQL where applicable.
• Coordinate with Sales, CRM, Legal, Accounts, and Construction teams to reconcile data.
• Ensure compliance tracking related to RERA updates, project approvals, and post-documentation records.
• Maintain clean master databases in ERP/CRM systems (Salesforce, SAP).
• Support internal audits, data governance, and process improvements.

Skills

MIS reporting

Advanced MS Excel

Data Visualization

BI Dashboards

5+ years experience

Tools

Power BI

SQL

Tableau

Google Data Studio

Salesforce

SAP

Job description

Role & responsibilities

• Sales & Inventory Management:
• Track daily, weekly, and monthly sales performance, site visits, lead conversions, bookings, cancellations, and subventions.
• Maintain and update project-wise inventory charts (available, blocked, sold, and registered units).
• Collections & Financial Tracking:
• Monitor milestone-wise customer collections, overdue payments, payment-plan compliance, and financial variances against targets.
• Track project budgets, actual expenditures, and cost-to-completion metrics in coordination with the finance team.
• Dashboard & Report Automation:
• Design, build, and maintain dynamic Excel-based dashboards, automated MIS templates, and executive slide decks for management reviews.
• Integrate and build interactive Business Intelligence dashboards using tools like Power BI or SQL where applicable
• Cross-Functional Coordination:
• Partner with Sales, CRM, Legal, Accounts, and Project/Construction teams to clean, validate, and reconcile data.
• Ensure compliance tracking related to RERA updates, project approvals, and post-documentation records.
• Data Integrity & Audits:
• Maintain clean master databases in ERP/CRM systems (e.g., Salesforce, SAP, or industry-specific CRM tools).
• Support internal audits, data governance, and process streamlining.

Required Skills & Qualifications

• Experience: 5+ years of proven hands-on experience in MIS reporting within real estate, real estate advisory, or construction.
• Technical Skills:
• Advanced MS Excel: Pivot Tables, VLOOKUP, XLOOKUP, Index-Match, Macros/VBA, Power Query, and complex nested formulas.
• Data Visualization & BI: Proficiency in Power BI, Tableau, or Google Data Studio is a strong advantage.
• Database / Query Tools: Basic to intermediate knowledge of SQL or Google Sheets App-Script is preferred.
• CRM & ERP Systems: Familiarity with real estate CRM workflows, lead tracking, and post-sales documentation.
• Soft Skills:
• High attention to detail and strong numerical/analytical aptitude.
• Strong communication skills to present complex data clearly to directors and department heads.

Preferred candidate profile

Immediate Joiner , Location : Coimbatore , Real estate preferred industry preferred .