Sr. MIS Executive

MIS Executive (Automation & Analytics)

Company: AMK Hospitality India Pvt Ltd — A Destination Wedding Planning Company (C Scheme, Jaipur)

Department: Operations / MIS
Reporting to: MD or MD EA
Employment: Full-time (On-site)
Working Hours: 9 hours/day
Weekly Off: Sundays (4 per month)
Salary Range: ₹25,000 – ₹35,000 per month (CTC)

Role Summary

Own AMK’s management information systems across Google Workspace and Excel. Build automated dashboards and workflow tools using Google Apps Script, JavaScript, and Macros, ensure clean, reliable data, and deliver actionable reports for leadership. This role supports wedding & events operations (RSVPs, guest logistics, venue/vendor coordination, budget tracking) with robust, well-documented MIS solutions in clear, professional English.

Key Responsibilities

Dashboards & Reporting

• Design and maintain daily/weekly/monthly MIS dashboards in Google Sheets/Looker Studio and Excel (pivots, charts, slicers) for: lead pipeline, guest logistics & rooming lists, vendor performance, budgets/expenses, chauffeur duty logs, and task SLAs.
• Automate data refreshes and scheduled summaries via Apps Script (e.g., daily email/WhatsApp-ready digests for leadership and team leads).

Automation & Scripting

• Build Apps Script solutions: triggers (time-based/onEdit/onFormSubmit), custom menus, HTML Service (simple web UIs), UrlFetchApp for REST API calls; write clean JavaScript (ES6).
• Create Macros (Apps Script and/or Excel VBA) to eliminate manual work (imports, formatting, deduping, reconciliations); maintain versioned change logs.

Data Management & Integrations

• Implement data validation, deduplication, reconciliation, and audit trails; maintain master data (venues, vendors, vehicle fleet, guest master, rate cards) with access controls.
• Integrate Forms/CRMs and third-party services (e.g., webhooks, Zapier/Make if used) into Sheets workflows; structure CSV/JSON imports and exports.

Operations Enablement

• Partner with Sales/Projects/RSVP/Logistics/Accounts to translate process needs into MIS tools (trackers, SOP checklists, alerting, escalations).
• Provide user training, quick reference guides, and first-line support; resolve issues within agreed SLAs.

Quality, Compliance & Documentation

• Ensure accuracy and completeness of reports; maintain SOPs and technical notes in clear English.
• Uphold data security and confidentiality; follow access protocols and approval workflows.

Must-Have Skills

• Google Apps Script (triggers, HTML Service, UrlFetchApp/REST, Properties Service, Drive/Sheets/Gmail APIs).
• JavaScript fundamentals (arrays/objects, async/await & Promises, JSON parsing, defensive error handling, logging).
• Advanced Google Sheets & Excel: QUERY, ARRAYFORMULA, REGEX*, INDEX–MATCH/XLOOKUP, FILTER, UNIQUE, TEXTSPLIT, Pivot Tables/Charts; comfortable with large, multi-sheet models.
• Macros: Apps Script and/or Excel VBA (record & write custom procedures; reliability and idempotency in routines).
• Strong data cleaning and basic data modeling; comfort with CSV/JSON schemas.
• Excellent written and spoken English (SOPs, how‑to guides, stakeholder emails) and professional presentation of reports.

Good-to-Have

• Basic SQL/BigQuery; Looker Studio/Power BI.
• Experience with WhatsApp/Email/SMS integrations (official APIs or middleware like Make/Zapier).
• Git/version control exposure; simple OAuth/API auth concepts.
• Working Hindi for on-ground coordination.

Qualifications & Experience

• Bachelor’s degree in Engineering/Computer Science/Statistics/Commerce (or equivalent experience).
• 2–5 years in an MIS/Automation/Reporting role building Apps Script/Excel solutions.

KPIs (Success Measures)

• Data accuracy: ≥ 99% on audited reports.
• Timeliness: Daily dashboards by 10:00 IST; weekly/monthly within agreed TAT.
• Automation uptime: ≥ 99% with alerting & rollback.
• Issue SLAs: Minor fixes ≤ 24–48 hrs; small new automations ≤ 3–5 days.
• Documentation: 100% of deployments with SOP + change log.

Compensation & Benefits

• Salary: ₹25,000 – ₹35,000 per month (CTC) based on experience and skill match.
• Benefits/Perks: phone bill support, , performance bonus - yearly].

How to Apply

Email your CV and portfolio (Sheets/Apps Script links or screenshots) to [mdo@anantkhandelwal.com ] with subject “MIS Executive – AMK Hospitality – YourName”. Optionally include GitHub/Gist links or code snippets demonstrating Apps Script/JS work.

Also please help us with filling the below google form - https://forms.gle/viVXXnb3yQhyNC71A

Job Type: Permanent

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

Benefits:

• Cell phone reimbursement

Work Location: In person