Specific Attributes

We are looking for a detail-oriented and computer-savvy MIS Executive to manage regular reports, data consolidation, Excel/Google Sheets-based reporting, and day-to-day data management.

The ideal candidate should have good practical knowledge of MS Excel and Google Sheets, strong attention to detail, and the ability to prepare accurate reports within deadlines.

Required Skills

• Good working knowledge of MS Excel and Google Sheets.
• Practical knowledge of formulas and functions.
• Good understanding of Pivot Tables, filtering, sorting, and data validation.
• Ability to work with large amounts of data accurately.
• Good analytical and problem-solving skills.
• Strong attention to detail.
• Good communication and coordination skills.
• Ability to meet reporting deadlines.

Preferred Skills

• Knowledge of IMPORTRANGE, QUERY, ARRAYFORMULA, or other advanced Google Sheets functions.
• Basic knowledge of dashboard creation.
• Basic understanding of reporting automation.

Knowledge of Google Forms or Google Apps Script will be an advantage, but is not mandatory

Responsibilities

• Prepare daily, weekly, and monthly MIS reports as required.
• Collect and consolidate data from different departments and sources.
• Maintain and update Excel and Google Sheets-based reports and trackers.
• Perform data entry, data cleaning, verification, and reconciliation.
• Use Excel/Google Sheets functions such as VLOOKUP/XLOOKUP, SUMIFS, COUNTIFS, IF, FILTER, and similar functions.
• Prepare Pivot Tables, charts, and basic dashboards for management reporting.
• Check reports for missing, duplicate, or incorrect information and correct discrepancies.
• Maintain proper records and ensure timely updating of MIS files.
• Generate ad-hoc reports and data summaries as requested by management.
• Coordinate with relevant departments to collect required information and resolve data discrepancies.
• Maintain confidentiality and accuracy of company data.
• Identify repetitive reporting tasks and suggest simple ways to improve or automate them.
• Provide basic support to team members regarding Excel/Google Sheets-related issues.
• Perform other MIS and reporting-related tasks assigned by management.

Experience

• 2–4 years of relevant experience in MIS, reporting, data management, operations, or a similar position.
• Candidates with strong practical Excel/Google Sheets skills and relevant experience may also be considered.

Education

Bachelor's degree in Management, IT, Computer Applications, Statistics, or a related field.