24 Sep
|
le fabco
|
Delhi
– MIS Executive
Position: MIS Executive
Department: MIS / Operations
Location: Delhi
Experience: 2–4 Years
Salary: ₹25,000–₹35,000 per month, depending on experience and skills
Employment Type: Full-Time
Job Summary
We are looking for a detail-oriented and analytical MIS Executive who can manage daily MIS activities, prepare reports, analyze data, maintain dashboards, and automate reporting processes.
Key Responsibilities
- Prepare and maintain daily, weekly, and monthly MIS reports.
- Collect, verify, consolidate, and analyze data from different departments.
- Develop and maintain Excel-based reports, dashboards, trackers, and management reports.
- Monitor data accuracy and ensure timely submission of MIS reports.
- Use formulas, Pivot Tables, Power Query, and other advanced Excel functions for data analysis.
- Develop and maintain Google Sheets-based reports and dashboards.
- Read, understand, modify, and troubleshoot Google Apps Script used for report automation.
- Automate repetitive reporting and data-management activities using Google Apps Script.
- Coordinate with different departments for data collection and clarification.
- Identify data discrepancies and ensure timely correction.
- Prepare reports and presentations for management review.
- Maintain proper documentation and data records.
- Support management in data analysis and decision-making through accurate MIS reporting.
Mandatory Skills The following two skills are mandatory:
- Advanced Excel – Mandatory
- VLOOKUP / XLOOKUP
- INDEX & MATCH
- SUMIFS / COUNTIFS
- IF / Nested IF
- Pivot Tables & Pivot Charts
- Conditional Formatting
- Data Validation
- Power Query
- Excel Dashboards
- Data Cleaning & Analysis
- Google Sheets & Google Apps Script – Mandatory
- Positive working knowledge of Google Sheets.
- Ability to read and understand Google Apps Script code.
- Ability to modify existing scripts and troubleshoot basic script-related issues.
- Understanding of spreadsheet automation and data flow.
- Knowledge of automated reports, email triggers, formulas, and data consolidation will be preferred.
Eligibility
- Graduate in any discipline; B.Com/BBA/BCA/IT/Computer-related qualification preferred.
- 2–4 years of relevant MIS/reporting experience.
- Strong analytical and problem-solving skills.
- Good communication and coordination skills.
- High attention to detail and accuracy.
Important Requirement Advanced Excel and the ability to read/understand Google Apps Script are mandatory. Candidates who do not possess both skills should not be considered for this position.
Pay: ₹25,000.00 - ₹35,000.00 per month
Work Location: In person
📌 MIS Executive (Delhi)
🏢 le fabco
📍 Delhi