MIS Executive

• Key ResponsibilitiesExpert-level knowledge of Google Sheets & Advanced Excel
• Must know Google Apps Script and be able to write scripts independently
• Automate repetitive tasks, reports and workflows using scripts
• Create automated daily, weekly & monthly MIS reports
• Build interactive dashboards, KPI trackers and management reports
• Create automated sheets for Sales, Attendance, HR, Performance, Incentives, Leads, etc.
• Connect and consolidate data between multiple Google Sheets
• Create automated buttons, menus, triggers, notifications and report generation
• Strong knowledge of QUERY, FILTER, ARRAYFORMULA, IMPORTRANGE, XLOOKUP/VLOOKUP, Pivot Tables, etc.
• Create and maintain structured databases and master sheets
• Clean, validate and analyze large amounts of data
• Use AI tools such as ChatGPT/Gemini for scripting, formulas, automation and data analysis
• Troubleshoot errors in existing formulas, scripts and automated sheets
• Ensure reports are accurate and delivered on time
• 
  

Mandatory Skills Google Apps Script coding is mandatory. The candidate must be capable of writing, modifying and debugging scripts—not just using formulas.

Strong hands-on knowledge of Google Sheets automation, advanced formulas, dashboards, data management and MIS reporting is required.

Knowledge of Looker Studio, Power BI, SQL or API integrations will be an added advantage.

Who We NeedWe need someone who can understand a reporting requirement and independently convert it into an automated Google Sheet/MIS system with minimal manual work.