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 Strong attention to detail Good 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

Pay: ?20,000.00 - ?40,000.00 per month

Work Location: In person