Mis Executive

Ajanta Soya

Delhi

On-site

INR 600,000 - 900,000

Full time

8 days ago

Application generator

An application made for this job — a tailored resume and cover letter that speak straight to the posting.

Get past ATS filters

Job summary

Ajanta Soya is seeking an MIS Executive/Analyst with hands-on experience in Google Sheets, Excel, MIS reporting, and data automation. The role focuses on handling large datasets, creating automated MIS reports, dashboards, and trackers, and developing Google Apps Script-based automation.

Basic ERP knowledge and business process understanding are required. The candidate will work on automating reports, transferring data between sheets via Apps Script, and ensuring timely delivery of MIS insights

Qualifications

Graduate in any discipline; preference for B.Com/BBA/BCA/IT/CS.
Strong knowledge of Google Sheets and advanced formulas.
Hands-on experience with Google Apps Script and API integration.
Experience in MIS reporting, data analysis and dashboard development.
Basic ERP knowledge and understanding of business processes.

Responsibilities

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.
Automate repetitive MIS activities using Apps Script.
Coordinate with ERP/IT for automation requirements and data accuracy.
Deliver timely MIS reports and monitor KPIs.

Skills

Google Sheets

Advanced Excel

SUMIFS

COUNTIFS

QUERY

IMPORTRANGE

ARRAYFORMULA

VLOOKUP / XLOOKUP

IF / IFS

APIs integration

MIS reporting

Data analysis

Education

Graduate in any discipline

B.Com / BBA / BCA / IT / CS related fields preferred

Tools

Google Apps Script

Power BI

REST APIs

SQL

Job description

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