We are looking for a skilled and detail-oriented MIS Executive who is highly proficient in Advanced Excel and Google Sheets and can take ownership of MIS reporting, data management, dashboards, and process improvement.
The ideal candidate should not only be able to prepare reports but also understand how to build, improve and automate systems using Excel and Google Sheets.
This role is suitable for someone who enjoys working with data, solving problems, creating efficient reporting systems and continuously learning new spreadsheet techniques.
Key Responsibilities
- Prepare and maintain regular MIS reports and management reports.
- Work extensively with Excel and Google Sheets for data analysis and reporting.
- Create and maintain Pivot Tables, dashboards and data summaries.
- Use advanced formulas and functions for data analysis and automation.
- Consolidate data from multiple sheets/files into structured reporting systems.
- Identify duplicate, incorrect or inconsistent data and maintain data accuracy.
- Develop dynamic reports and dashboards for management decision-making.
- Improve existing Excel/Google Sheets-based processes and reporting systems.
- Troubleshoot formula and data-related issues.
- Explore opportunities to automate repetitive reporting tasks.
- Assist in developing structured Google Sheets systems for different business requirements.
- Support users/team members in understanding and using reporting systems.
- Identify inefficient processes and suggest practical improvements.
Required Skills
- 1–3 years of relevant MIS experience.
- Strong knowledge of Advanced Excel.
- Strong working knowledge of Google Sheets.
- Excellent knowledge of Pivot Tables.
- Good understanding of formulas such as:
- VLOOKUP / INDEX-MATCH
- SUMIFS / COUNTIFS
- IF / IFS
- COUNTIF
- ARRAYFORMULA
- Experience with data validation, dynamic lists and dashboards.
- Good analytical and mathematical ability.
- Ability to troubleshoot spreadsheet errors systematically.
- Strong attention to detail.
- Good problem-solving ability.
- Willingness to learn new Google Sheets features and automation techniques.
Good to Have
- Experience with IMPORTRANGE, QUERY and other Google Sheets-specific functions.
- Basic knowledge of Google Apps Script.
- Experience automating recurring reports.
- Experience consolidating multiple Excel/Google Sheets files into a centralized system.
- Experience creating management dashboards.
- Experience training or supporting other team members on Excel/Google Sheets.
What We Are Looking For
We are looking for someone who:
- Can work independently with large datasets.
- Thinks beyond simply preparing reports.
- Can identify ways to make reporting faster and more reliable.
- Has a systematic approach to troubleshooting.
- Is comfortable learning new spreadsheet functions and tools.
- Can explain technical concepts clearly to non-technical team members.
- Takes initiative to improve existing processes.
Educational background in Mathematics or a related quantitative field will be an advantage. Candidates with strong practical knowledge of Advanced Excel and Google Sheets will be preferred.
Pay: ₹15,000.00 - ₹20,000.00 per month
Application Question(s):
- How many years of professional MIS experience do you have?
- How would you rate your proficiency in Advanced Excel and Google Sheets?
Basic
Intermediate
Advanced
Expert
- Which of these Excel/Google Sheets functions or features have you used professionally?
Select all that apply.
Pivot Tables
VLOOKUP / INDEX-MATCH
SUMIFS / COUNTIFS
ARRAYFORMULA / QUERY / IMPORTRANGE
Dashboards & Charts
None of these
- Have you independently created or improved MIS reports/dashboards or automated a reporting process?
Yes
No
Work Location: In person
