Job Summary The MIS Executive will be responsible for managing, organizing, maintaining, and analyzing organizational data to support various programs and departments. The role requires excellent proficiency in Microsoft Excel, Word, and PowerPoint, along with strong analytical and reporting skills. The candidate will ensure data accuracy, prepare management reports, maintain databases, and support data-driven decision-making across the organization.

Key Responsibilities

- Collect, compile, verify, and maintain data received from various project locations.

- Ensure data accuracy, completeness, and consistency before preparing reports.

- Prepare daily, weekly, monthly, and quarterly MIS reports.

- Maintain centralized databases for projects, HR, finance, and operational activities.

- Develop and maintain Excel-based dashboards, trackers, and reporting formats.

- Analyze data and present meaningful insights for management review.

- Prepare presentations, reports, and documentation using Microsoft PowerPoint and Microsoft Word.

- Coordinate with project teams to obtain timely and accurate data.

- Identify discrepancies in reports and follow up for corrections.

- Maintain confidentiality and security of organizational data.

- Generate customized reports as required by management.

- Assist in preparing donor reports, program reports, and internal management reports.

- Archive and maintain digital records in an organized manner.

- Support monitoring and evaluation activities through accurate data management.

- Perform any other MIS-related tasks assigned by the management.

Required Qualifications

- Bachelor's degree in Computer Applications, Computer Science, Information Technology,



Statistics, Commerce, Mathematics, or a related discipline.

- 1–3 years of experience in MIS, Data Management, Data Analysis, or a similar role.

Experience in an NGO or development sector will be preferred.

Technical SkillsAdvanced Microsoft Excel (Mandatory)

- Advanced Excel formulas (VLOOKUP, HLOOKUP, XLOOKUP, INDEX-MATCH)

- IF, Nested IF, SUMIF, SUMIFS, COUNTIF, COUNTIFS

- Pivot Tables and Pivot Charts

- Conditional Formatting

- Data Validation

- Lookup and Reference Functions

- Text and Date Functions

- Dashboard creation

- Data Cleaning and Data Analysis

- Charts and Graphs

- Sorting, Filtering, and Advanced Filters

- Importing and exporting data

- Basic Macros (preferred)

Microsoft Word

- Professional report preparation

- Formatting and templates

- Tables and document management

- Mail Merge (preferred)

Microsoft PowerPoint

- Professional presentation preparation

- Data visualization

- Charts, SmartArt, and infographics

- Presentation formatting and design

Additional Skills

- Strong analytical and problem-solving skills.

- Excellent attention to detail and accuracy.

- Ability to manage large volumes of data.

- Valuable communication and coordination skills.

- Ability to meet deadlines and work independently.

- Strong organizational and documentation skills.

Preferred Skills

- Experience with MIS reporting in NGOs or healthcare projects.

- Knowledge of Google Sheets.

- Familiarity with Power Query, Power Pivot, or Microsoft Power BI will be an added advantage.

- Understanding of monitoring and evaluation (M&E;) data systems is desirable.

Pay: ₹10,000.00 - ₹15,000.00 per month

Work Location: In person

📌 MIS Executive (Gwalior)
🏢 Society of Community Health Oriented Operational Links (SCHOOL)
📍 Gwalior