Role Objective

We are looking for an experienced MIS Executive who can manage, analyse, and transform operational data into accurate and actionable business reports. The role will be responsible for developing and maintaining MIS reports, dashboards, automated reporting systems, Google Sheets-based workflows, and data management processes across departments.

The ideal candidate should have strong hands-on expertise in Google Sheets, Excel, data analysis, reporting automation, dashboards, and process improvement, along with the ability to understand business requirements and convert them into efficient reporting solutions.

- MIS Reporting & Data Management

- Prepare and maintain daily, weekly, monthly, and management MIS reports.
- Consolidate data from multiple departments, systems, and spreadsheets into structured reporting formats.
- Ensure data accuracy, consistency, completeness, and timely availability.
- Identify data discrepancies, missing information, duplicates, and reporting errors.
- Maintain standardized reporting formats and documentation.

2. Google Sheets & Excel Expertise
- Develop advanced reporting solutions using Google Sheets and Excel.
- Work with VLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, IF/IFS, ARRAYFORMULA, and other advanced functions.
- Use QUERY, FILTER, UNIQUE, IMPORTRANGE, and related Google Sheets functions for dynamic reporting.
- Create dynamic dropdowns, validation systems, automated calculations, and structured data-entry templates.
- Optimize large datasets and improve spreadsheet performance.

3. Dashboard Development & Analytics
- Design and maintain management dashboards for tracking business and operational KPIs.
- Convert raw data into meaningful KPIs, trends, comparisons, and actionable insights.
- Develop dashboards using pivot tables, charts, energetic ranges, filters, and summary metrics.
- Track metrics such as performance, productivity, sales, operations, attendance, turnaround time, and other business-specific KPIs.
- Present complex data in a simple and user-friendly format.

4. Reporting Automation
- Identify repetitive manual reporting activities and develop automated reporting solutions.




- Use Google Apps Script or other suitable tools to automate data consolidation, report generation, notifications, and email reporting.
- Set up scheduled reports and automated workflows for management.
- Integrate data from multiple Google Sheets/files where required.
- Implement appropriate error handling and validation mechanisms.

5. Process Improvement & Systems Implementation
- Analyse existing MIS and reporting processes to identify inefficiencies.
- Replace fragmented Excel-based processes with centralized and structured Google Sheets systems where appropriate.
- Design scalable reporting structures that can support multiple departments and users.
- Implement data validation, access controls, standardized templates, and backup/transition processes.
- Work with stakeholders to understand reporting requirements and translate them into practical systems.

6. Data Quality & Troubleshooting
- Investigate and resolve reporting discrepancies and formula errors.
- Troubleshoot common spreadsheet errors such as #REF!, #VALUE!, #N/A, and incorrect calculations.
- Validate data before releasing reports to management.
- Maintain documentation for formulas, processes, and reporting logic.
- Ensure reports remain reliable after changes to source data or reporting structures.

7. Stakeholder Coordination & Support
- Coordinate with Operations, Finance, HR, Sales, and other departments to collect and validate data.
- Understand department-specific reporting requirements.
- Provide support and training to team members using MIS systems and Google Sheets.
- Help employees transition from traditional Excel-based processes to collaborative Google Sheets workflows.
- Explain technical concepts in a simple and practical manner.

8. Continuous Improvement
- Stay updated with new Google Sheets, Google Workspace, Excel, automation,



and reporting technologies.
- Research and implement new functions, tools, and techniques that improve reporting efficiency.
- Proactively identify opportunities to reduce manual work and improve data visibility.
- Build reusable templates and standardized reporting frameworks.

Required Skills & Qualifications
- Must Have: 3–4 years of relevant experience in MIS, Reporting, Data Analysis, Business Intelligence, or a similar role.
- Advanced knowledge of Google Sheets and Microsoft Excel.
- Strong understanding of VLOOKUP / XLOOKUP, INDEX-MATCH, SUMIFS / COUNTIFS, IF / IFS, ARRAYFORMULA, QUERY, FILTER, UNIQUE, IMPORTRANGE, Pivot Tables, Data Validation, and Conditional Formatting.
- Experience creating management dashboards and automated reports.
- Strong data interpretation and analytical skills.
- Experience handling large datasets and multiple data sources.
- Strong attention to detail and data accuracy.
- Ability to troubleshoot formulas and reporting issues.

Preferred / Enterprise-Level Skills
- Basic to intermediate Google Apps Script knowledge.
- Experience automating emails, reports, and recurring workflows.
- Experience designing centralized MIS systems.
- Understanding of data access controls and reporting governance.
- Experience working with multiple departments and stakeholders.
- Strong documentation and process-management skills.
- Ability to train and support non-technical users.

Key Competencies
- Analytical Thinking
- Data Accuracy & Attention to Detail
- Problem Solving
- Systems Thinking
- Process Improvement
- Reporting & Visualization
- Automation Mindset
- Communication Skills
- Stakeholder Management
- Learning Agility
- Ownership & Accountability

What We Expect From the Candidate The ideal candidate should not be someone who only prepares reports from existing data. At the 3–4 year level, the person should understand why the report is required, how the data should flow, how to automate repetitive work, how to improve the existing process, and how management can use the information for decision-making.

Pay: ₹20,000.00 - ₹40,000.00 per month

Work Location: In person

📌 MIS Executive (Magdalla)
🏢 Saileela Infotech Consultancy (OPC
📍 Magdalla