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:

• Developing and maintaining automated MIS reports and dashboards using Google Sheets and Looker Studio.
• Building automation workflows using Google Apps Script to reduce manual reporting and data-entry work.
• Creating automated data collection, consolidation, validation, and reporting systems.
• Developing interactive Looker Studio dashboards for management and various departments.
• Connecting Looker Studio with Google Sheets and other available data sources.
• Creating automated daily, weekly, and monthly business reports.
• Designing KPI dashboards covering sales, operations, HR, finance, inventory, and other business functions.
• Using Google Sheets formulas, Pivot Tables, QUERY, FILTER, ARRAYFORMULA, IMPORTRANGE, VLOOKUP/XLOOKUP, INDEX-MATCH, and other advanced functions.
• Writing and maintaining Apps Script code for automated emails, notifications, data processing, report generation, and workflow automation.
• Scheduling automated reports and alerts for management and relevant teams.
• Integrating data from multiple Google Sheets and other business data sources.
• Cleaning, validating, organizing, and maintaining large datasets.
• Identifying data inconsistencies and ensuring accuracy of MIS reports.
• Developing customized reporting formats based on management requirements.
• Maintaining data structures, formulas, scripts, dashboards, and reporting documentation.
• Working with different departments to understand reporting requirements and converting them into automated solutions.
• Improving existing MIS processes and reducing manual intervention through automation.
• Troubleshooting errors in Google Sheets, Apps Script, and Looker Studio dashboards.
• Providing 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.