Mis Executive

Manpowergroup Services India; Coimbatore District; On-site; INR 350,000 - 520,000; Full time

Job summary

ManpowerGroup Services India in Coimbatore seeks a detail-oriented MIS Executive to manage and optimize business data operations. You will build automated reporting using Google Apps Script and Advanced Excel, ensure data accuracy, and deliver actionable insights to leadership.

Responsibilities include designing dashboards for daily, weekly, and monthly performance; automating workflows with VBA/Macros; data extraction and cleaning; audits, and cross-functional collaboration to standardize

Qualifications

• 1–3 years of hands-on MIS/ Data Analyst experience.
• Bachelor's degree in Computer Applications (BCA/B.Sc IT), Commerce, or Business Administration.

Responsibilities

• Design, maintain and publish dashboards for daily, weekly, and monthly performance for senior management.
• Develop automated scripts with Google Apps Script and VBA to minimize manual data entry.
• Consolidate and clean multi-channel datasets using VLOOKUP, HLOOKUP, INDEX-MATCH, and Pivot Tables.
• Perform regular data validation to ensure accuracy across reports.
• Collaborate with internal teams to standardize templates and support data-driven decisions.

Skills

Google Apps Script

Advanced Excel

Pivot Tables

VBA Macros

LOOKUP functions

Education

BCA or BSc IT

Commerce

Business Administration

Tools

Google Apps Script

Excel Macros

Pivot Tables

QUERY/ARRAYFORMULA

Job description

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