JOB DESCRIPTION – MIS EXECUTIVE

LOCATION: Sector: 18, Gurgaon || SALARY: Upto 26,000 CTC ( depends on Interview ) || WORK SCHEDULE: 6 Days a Week | 10 AM to 7 PM | WFO || EXPERIENCE: 3–6 Years || INDUSTRY: Any Industry || QUALIFICATION: Bachelor's Degree in a relevant field

POSITION OVERVIEW

We are looking for a Senior MIS Executive with robust knowledge of Advanced Excel, Google Sheets, MIS reporting, data analysis, dashboards, and process automation. The candidate will be responsible for managing business data, preparing management reports, developing automated MIS systems, and providing useful insights to support business decisions.

KEY RESPONSIBILITIES1. MIS & Reporting

- Prepare and manage daily, weekly, and monthly MIS reports.
- Collect, consolidate, validate, and analyse data from different departments and branches.
- Develop and maintain MIS reports, trackers, dashboards, and performance reports.
- Monitor KPIs, productivity, operational performance, and other business metrics.
- Ensure reports are accurate and submitted on time.
- Provide data analysis, trends, and insights to management.

2. Excel & Google Sheets

- Manage and analyse large datasets using Advanced Excel and Google Sheets.
- Use Pivot Tables, VLOOKUP/XLOOKUP, HLOOKUP, INDEX-MATCH, IF/IFS, IFERROR, SUMIF/SUMIFS, COUNTIF/COUNTIFS, and other advanced formulas.
- Use Data Validation, Conditional Formatting, Advanced Filters, Charts, and Dashboards.
- Use Google Sheets functions such as QUERY, IMPORTRANGE, FILTER, and ARRAYFORMULA.
- Integrate data from multiple Google Sheets and Google Forms.

3. Dashboard & Data Management

- Create and maintain dashboards using Excel, Google Sheets, and Looker Studio.
- Develop and maintain FMS,



PMS, checklists, and workflow trackers.
- Ensure data accuracy, consistency, and proper validation.
- Identify data gaps, errors, and reporting issues and take corrective action.

4. Automation

- Automate repetitive reporting and data-related processes.
- Use Google Apps Script for reporting and workflow automation.
- Develop centralized reporting systems using data from multiple sources.
- Support automation of email and WhatsApp notifications.
- Identify manual processes and suggest practical automation solutions.

5. AI & Process Improvement

- Use AI tools such as ChatGPT for reporting, data analysis, and process improvement.
- Support AI-based automation for reporting, communication, and workflow management.
- Identify opportunities to improve existing MIS and reporting systems.
- Suggest ways to reduce manual work and improve reporting efficiency.

6. Coordination & Documentation

- Coordinate with different departments and branches for data collection and validation.
- Maintain proper documentation of MIS processes, formulas, dashboards, and automation systems.
- Understand reporting requirements and provide timely support to different teams.
- Perform other MIS/analytics-related responsibilities assigned by the reporting manager.

JOB REQUIREMENTS

- Experience: 3–6 years in MIS,



Data Analysis, Reporting, or Business Analytics.
- Bachelor's degree in any relevant field.
- Strong hands-on experience with Advanced Excel and Google Sheets.
- Practical experience in MIS automation and dashboard creation.
- Good knowledge of Google Apps Script.
- Good knowledge of Looker Studio / Google Data Studio.
- Knowledge of Power Query / VBA will be an advantage.
- Basic knowledge of API integration, HTML, and JavaScript will be an advantage.
- Knowledge of AI tools and automation.
- Ability to independently manage large datasets and reporting requirements.
- Strong analytical and problem-solving skills.
- Good communication and coordination skills.
- Strong attention to detail and data accuracy.
- Candidates with experience handling multiple branches/locations will be preferred.

IDEAL CANDIDATE

A detail-oriented, analytical, and experienced MIS professional who can independently manage large datasets, prepare management reports, create dashboards, automate reporting processes, identify data issues, and provide meaningful insights to management.

Must Have Skills:

Advanced Excel | Google Sheets | MIS Reporting | SQL | Python | Java | Data Analysis | Google Apps Script | Looker Studio | Dashboard | FMS/PMS | Process Automation | AI Tools | KPI Reporting | Business Analytics

Pay: ₹11,000.00 - ₹26,000.00 per month

Benefits:

- Leave encashment
- Provident Fund

Application Question(s):

- Can you relocate to Gurugram ?
- How many years of experience you have in MIS Executive Profile ?
- What is your Current salary Per month ?
- What is your Age ?

Work Location: In person

📌 MIS Executive (Gurugram)
🏢 Ganpattraj Gold
📍 Gurugram