MIS Executive

Job Summary

We are looking for a technically skilled MIS Executive with strong expertise in Google Sheets, Google Apps Script, and Looker Studio to manage business reporting, automate repetitive processes, and develop real-time dashboards.

The candidate will be responsible for collecting and analyzing business data, developing automated MIS systems, creating interactive dashboards, maintaining data accuracy, and providing actionable reports to management.

Key Responsibilities

Develop and maintain automated MIS reports and dashboards using Google Sheets and Looker Studio.

Build automation workflows using Google Apps Script to reduce manual reporting and data-entry work.

Create automated data collection, consolidation, validation, and reporting systems.

Develop interactive Looker Studio dashboards for management and various departments.

Connect Looker Studio with Google Sheets and other available data sources.

Create automated daily, weekly, and monthly business reports.

Design KPI dashboards covering sales, operations, HR, finance, inventory, and other business functions.

Use Google Sheets formulas, Pivot Tables, QUERY, FILTER, ARRAYFORMULA, IMPORTRANGE, VLOOKUP/XLOOKUP, INDEX-MATCH, and other advanced functions.

Write and maintain Apps Script code for automated emails, notifications, data processing, report generation, and workflow automation.

Schedule automated reports and alerts for management and relevant teams.

Integrate data from multiple Google Sheets and other business data sources.

Clean, validate, organize, and maintain large datasets.

Identify data inconsistencies and ensure accuracy of MIS reports.

Develop customized reporting formats based on management requirements.

Maintain data structures, formulas, scripts, dashboards, and reporting documentation.

Work with different departments to understand reporting requirements and convert them into automated solutions.

Improve existing MIS processes and reduce manual intervention through automation.

Troubleshoot errors in Google Sheets, Apps Script, and Looker Studio dashboards.

Provide timely analytical reports and insights to support management decision-making.

Technical Skills – Mandatory

Google Sheets

Advanced formulas and functions

QUERY, FILTER, SORT, ARRAYFORMULA

VLOOKUP / XLOOKUP / INDEX-MATCH

Pivot Tables and Charts

Conditional Formatting

Data Validation

IMPORTRANGE

Data cleaning and consolidation

Google Apps Script

JavaScript fundamentals

Writing and maintaining automation scripts

Triggers and scheduled automation

Automated emails and notifications

Data manipulation using Apps Script

Spreadsheet automation

Report generation and distribution

API integration knowledge will be an advantage

Looker Studio

Dashboard development

Data blending and calculated fields

KPI visualization

Filters and interactive controls

Charts and reporting formats

Google Sheets/data-source connectivity

Dashboard optimization and maintenance

Candidate Requirements

Graduate in Computer Applications, IT, Statistics, Mathematics, Commerce, Business Analytics, or a related field .

2–5 years of relevant experience in MIS, Business Analytics, Reporting, Data Analysis, or Automation.

Strong hands-on experience with Google Sheets, Google Apps Script, and Looker Studio .

Good understanding of data analysis and business reporting.

Strong analytical and problem-solving skills.

Ability to independently develop automated reporting systems.

Good communication skills and ability to coordinate with different departments.

Strong attention to detail and data accuracy.

Key Performance Indicators (KPIs)

Accuracy and timeliness of MIS reports.

Reduction in manual reporting and data-entry work.

Number and effectiveness of automated processes developed.

Dashboard accuracy, usability, and availability.

Timely delivery of management reports.

Reduction in reporting errors and turnaround time.

Successful implementation of department-specific dashboards.

Data integrity and consistency across reporting systems.

Preferred Candidate Profile

The ideal candidate should be strong in Google Sheets, Apps Script, and Looker Studio , with a combination of MIS/reporting and technical automation skills. The person should be capable of understanding business requirements and independently converting manual reporting processes into automated dashboards and workflow