Job description:

Role Overview

The MIS Executive will be responsible for managing and optimizing company data systems, developing analytical dashboards, and supporting automation initiatives. The role requires strong expertise in Excel, BI tools, coding, automations, and reporting accuracy.

Key Responsibilities1. Data & Reporting

- Generate daily/weekly/monthly MIS reports for management and CRM teams.
- Create and maintain dashboards using Power BI and Looker Studio.
- Identify and correct discrepancies in source data.

2. Excel & Google Sheets Management

- Maintain detailed spreadsheets and dashboards.
- Use Advanced Excel functions, Pivot Tables, Power Query, and Macros.
- Fix formula errors, linkage problems, and inconsistencies in Google Sheets.

3. Reconciliations

- Perform periodic reconciliations across CRM, Sales, Accounting, and internal systems.
- Resolve mismatches in coordination with concerned teams.

4. Coding & Automation

- Develop automation scripts using Java, SQL, VBA, and Google Apps Script.
- Integrate Google Suite tools for workflow and data automation.
- Implement Mail Merge & Email Automation for daily reports.
- Assist in WhatsApp automation and bot workflows (optional).

5. AI Integration

- Use AI tools to automate repetitive tasks and improve data accuracy.
- Implement AI for data extraction, reporting, and documentation automation.

6. Data Management

- Maintain centralized databases with version control.
- Ensure data accuracy, integrity, and confidentiality.

7. Process Improvement

- Suggest improvements in reporting formats and dashboard structures.




- Identify automation opportunities to streamline processes.

8. Coordination

- Work closely with CRM, Finance, Sales, and Operations teams to understand reporting needs.
- Provide MIS support and solutions across departments.

Skills & QualificationsEducation

- Bachelor’s degree in Computer Science, IT, Business Administration, or related field.
- Master’s degree preferred.

Experience

- Minimum 3+ years in MIS, data automation, or business intelligence.
- Proven experience in Power BI, Looker Studio, and advanced Excel.
- Experience in automation of reports, emails, and workflows.

Technical Skills

- Power BI & Looker Studio (dashboard creation)
- Advanced Excel (Macros, Pivot Tables, Lookups)
- Google Suite (Sheets, Forms, Apps Script)
- SQL (data management & querying)
- Coding: Java, VBA, Google Apps Script
- Mail Merge & Email Automation
- WhatsApp automation (added advantage)
- Familiarity with CRM systems, Tally software, and data visualization tools

Soft Skills

- Excellent analytical & problem-solving abilities
- Robust attention to detail
- Valuable communicator and cross-functional coordinator
- Ability to handle large data sets
- Strong time management and task prioritization
- Proactive mindset for automation & efficiency

Key Attributes

- Detail-oriented and accuracy-focused
- Ability to work under strict deadlines
- Independent, responsible, and process-driven

Job Type: Full-time

Work Location: In person

Job Types: Full-time, Permanent

Pay: ₹18,000.00 - ₹50,000.00 per month

Work Location: In person

📌 MIS Executive(real estate,crm) (India)
🏢 Kohinoor group
📍 India