Job Summary

We are looking for a MIS Executive / MIS Analyst who has strong hands-on experience in Google Sheets, Excel, MIS Reporting, Data Analysis and Automation. The candidate should be comfortable working with large datasets, creating automated MIS reports, dashboards and trackers, and developing Google Apps Script-based automation. Basic knowledge of ERP systems and business processes is also required.

Key Responsibilities

1. Google Sheets & MIS Reporting

- Create and maintain daily, weekly and monthly MIS reports.
- Prepare automated dashboards, trackers and management reports.
- Manage and analyze large datasets in Google Sheets.
- Develop dynamic reports using advanced Google Sheets formulas.
- Ensure accuracy and timely availability of MIS reports.
- Identify data discrepancies and coordinate with relevant departments for correction.

2. Google Sheets Required Skills Candidate must have strong practical knowledge of:

- SUMIFS
- COUNTIFS
- COUNTIF / SUMIF
- VLOOKUP / XLOOKUP
- INDEX + MATCH
- FILTER
- QUERY
- IMPORTRANGE
- ARRAYFORMULA
- IF / IFS
- IFERROR
- UNIQUE
- SORT / SORTN
- TEXT / DATE / TIME formulas
- Conditional Formatting
- Data Validation
- Pivot Tables
- Charts & Dashboards
- Named Ranges
- Google Sheets automation and data management

3. Google Apps Script & Automation Candidate should have hands-on knowledge of Google Apps Script and should be able to:

- Automate repetitive MIS activities.
- Transfer/copy data between Google Sheets automatically.
- Create automated reports and trackers.
- Send automated WhatsApp messages from Google Sheets through API integration.
- Send automated emails based on specific conditions.
- Create time-based and event-based triggers.
- Develop automated alerts and notifications.




- Integrate Google Sheets with third-party APIs.
- Read/write/update Google Sheet data using Apps Script.
- Troubleshoot and maintain existing Apps Script automations.

Example: If a particular condition is fulfilled in Google Sheets, the system should automatically send a WhatsApp notification to the concerned person through an API. 4. ERP Knowledge

Candidate should have basic to intermediate knowledge of ERP systems and understand common business processes such as:

- Sales
- Purchase
- Inventory / Stock
- Production
- Dispatch
- Logistics
- Accounts
- Customer / Vendor Management
- Reports and MIS
- Basic understanding of ERP data flow

Candidate should be able to understand ERP reports, identify data-related issues and coordinate with the ERP/IT team for resolution. 5. Data Analysis & MIS

- Analyze operational and business data.
- Prepare management summaries and performance reports.
- Track pending, completed and delayed activities.
- Create department-wise and employee-wise performance reports.
- Monitor KPIs and prepare exception reports.
- Identify trends, gaps and data inconsistencies.
- Convert raw data into meaningful management information.

6. Automation & Process Improvement

- Identify manual processes that can be automated.
- Suggest improvements in existing MIS systems.
- Reduce manual data entry and repetitive reporting work.
- Develop automated alerts, reminders and notifications.




- Maintain documentation of formulas, scripts and reporting processes.
- Work closely with business, ERP, IT and other departments for automation requirements.

Required Skills

Must Have

- Strong knowledge of Google Sheets
- Advanced Excel knowledge
- Strong knowledge of SUMIFS, COUNTIFS, QUERY, IMPORTRANGE and other advanced formulas
- Hands-on Google Apps Script
- API integration knowledge
- Experience in Google Sheets automation
- MIS reporting and data analysis
- Good problem-solving skills
- Good understanding of business processes
- Basic ERP knowledge

Good to Have

- Knowledge of WhatsApp API integration
- Knowledge of REST APIs
- Basic SQL knowledge
- Dashboard development
- Power BI knowledge
- Experience with ERP implementation/projects

Qualification

- Graduate in any discipline.
- Candidates with qualifications in B.Com, BBA, BCA, IT, Computer Science, Statistics, Mathematics or related fields will be preferred.

Candidate Profile

- Analytical and detail-oriented.
- Robust in logical thinking and problem solving.
- Comfortable working with large datasets.
- Able to independently create MIS reports and automation.
- Good at understanding business requirements.
- Willing to learn new ERP systems and automation tools.
- Able to coordinate with multiple departments.

Key Performance Indicators (KPI)

- Accuracy of MIS reports
- Timely submission of daily/weekly/monthly reports
- Reduction in manual reporting work
- Number of successful automation initiatives
- Accuracy of automated data transfer
- Timely resolution of MIS/data issues
- Efficiency of Google Sheets and Apps Script automation
- Quality and reliability of management dashboards

📌 Walk-in || Mis Executive (Delhi)
🏢 AJANTA SOYA
📍 Delhi