JOB SUMMARY

We are seeking a detail-oriented, highly analytical MIS Executive to manage, process, and optimize business data operations at our Sitra, Coimbatore location. The ideal candidate will leverage Google Apps Script and

Advanced Excel to build automated reporting systems, maintain flawless data accuracy, and deliver actionable operational insights to leadership.

KEY RESPONSIBILITIES

Report Generation & Management: Design, maintain, and publish daily, weekly, and monthly operational performance dashboards for senior management.

Workflow Automation: Develop automated scripts using Google Apps Script and Excel Macros (VBA) to minimize manual data entry and streamline repetitive tasks.

Data Extraction & Processing: Consolidate and clean multi-channel raw datasets utilizing advanced lookup functions (VLOOKUP, HLOOKUP, XLOOKUP, Pivot Tables, INDEX-MATCH).

Data Integrity & Auditing:



Perform regular data validation checks to identify discrepancies and ensure high data precision across departmental reports.

Cross-Departmental Support: Collaborate with internal teams to gather functional requirements, standardize reporting templates, and support data-driven decision-making.

REQUIRED SKILLS & TECHNICAL EXPERTISE

Google Apps Script VLOOKUP / HLOOKUP Excel Macros & VBA Pivot Tables ARRAYFORMULA / QUERY

Data Automation Data Cleaning

Technical Mastery: Expert-level command over Google Apps Script (Google Sheets automation) and

Advanced Excel functions (VLOOKUP, HLOOKUP, Macros/VBA).

Domain Experience: 1 to 3 years of hands-on experience as an MIS

Executive, Data Analyst, or Reporting

Specialist.

Educational Qualification: Bachelors degree in Computer Applications (BCA/B.Sc IT), Commerce, Business

Administration, or related disciplineRole & responsibilities

📌 Mis Executive (Coimbatore)
🏢 Manpowergroup Services India
📍 Coimbatore