Job Description

We are seeking a detail-oriented and tech-savvy

MIS Executive

with strong expertise in

Google Sheets, Dashboard Creation, and Google App Scripts

. The ideal candidate will be responsible for managing data, preparing automated reports, building dashboards, and improving operational efficiency through automation.

Key Responsibilities

Data Management & Reporting

Collect, clean, and structure data from various departments (Operations, Housekeeping, F&B, Finance, Marketing, etc.). Maintain and update daily/weekly/monthly MIS reports. Ensure data accuracy, completeness, and timely reporting.

Google Sheets Expertise

Build advanced Google Sheets models using formulas, pivot tables, lookups, filters, and conditional formatting. Create interconnected sheets for tracking KPIs, performance metrics, and departmental workflows. Maintain version control and secure access permissions.

Dashboard Creation

Develop interactive dashboards for management using Google Sheets, Looker Studio, or similar tools. Present key insights like revenue trends, occupancy, sales performance, staff productivity, and cost analysis. Automate data refresh and ensure dashboards are user-friendly for leadership.
*

Automation with Google App Scripts

Create scripts to automate repetitive tasks (emails, alerts, data pulls, data cleaning, reminders, etc.). Connect Sheets with external tools (Forms, Gmail, Calendar, CRM, POS, etc.) using App Scripts. Troubleshoot script errors and optimize existing automation.

Operational Support

Assist departments in adopting digital workflows. Build custom tools--attendance trackers, leave systems, inventory sheets, costing calculators, etc. Create SOPs for sheet usage and ensure staff follows MIS protocols.
Job Type: Full-time

Pay: ₹12,205.99 - ₹20,000.00 per month

Work Location: In person