MIS Executive

Objective of the Role

To manage, automate, and troubleshoot day-to-day business data processes using Google Sheets, Google Forms, Apps Script, and REST API integrations. This role ensures real-time visibility, systematic reporting, and smooth data flow across departments like CRM, Order Management, and Delivery.

Key Responsibilities

1. Google Workspace Automation

• Create Google Forms & connect to Google Sheets as per team requirements.
• Maintain dynamic Forms linked to task management systems.
• Automate workflows using Google Apps Script (form triggers, custom menus, email & WhatsApp alerts).

2. Daily Tech Troubleshooting

• Solve real-time formula errors, data inconsistencies, or broken sheet links.
• Ensure smooth functioning of CRM, Order-to-Delivery FMS, and Feedback trackers.

3. Data Collection & Presentation

• Gather data from various sources including cloud apps, ERP systems, and Google Sheets.
• Standardize and clean datasets—remove duplicates, fix date/timestamp issues.
• Present clean, visual reports using pivot tables, bar/line graphs, and dashboards.

4. Dashboard Development (Owner & Team-Wise)

• Build custom dashboards for owner and team members to monitor:

- Order status

- Task completion status

- CRM task ageing

- Performance KPIs (per person, per department)

• Dashboards must be auto-updated, visually clear, and action-oriented.

5. System Integration via REST API

• Connect and sync data from external platforms such as:

- POS systems

- Sales CRMs

- Call tracking apps

- Inventory or billing software

• Use REST APIs (JSON, Webhooks) and Google Apps Script to fetch, push, and organize data within Google Sheets.

6. Insight Generation

• Identify data trends (e.g. who is submitting late entries, which orders are delayed).
• Share weekly/monthly summaries with responsible team members.
• Help the team act on lagging performance through actionable charts.

Sample Real-World Tasks You Will Handle

Task Description

CRM Form Link Broken Investigate and restore Google Form to Sheet mapping logic.

Order-Delivery Delay Report Identify who submitted orders late using timestamp data across Forms.

Build Daily Order Dashboard Combine order entries from different sources into a single view.

Trigger Alerts Send WhatsApp/Mail notifications when specific forms are submitted.

Owner Dashboard Summary view of all pending/late tasks by person/category

Team Member Dashboards Each doer gets a focused view of their own tasks, delays, and performance trends

Skills Required

Skill Area Must Have Notes

Google Sheets & Forms ✅ Advanced formulas, data structuring

Google Apps Script ✅ Triggers, custom functions, automation

REST API ✅ Knowledge of POST, GET, tokens, webhooks

Excel (Advanced) ✅ Cleaning, dashboards, dynamic analysis

Visualization ✅ Pivot tables, bar/line/stacked charts

Dashboarding ✅ Per-person, per-process views

Debugging ✅ Comfort with error tracing

Basic Logic ✅ Can write and explain logical workflows

Communication ✅ Can explain solutions to non-technical team members

Job Types: Full-time, Permanent, Fresher

Pay: From ₹15,000.00 per month

Benefits:

• Leave encashment

Ability to commute/relocate:

• Dehradun, Uttarakhand: Reliably commute or planning to relocate before starting work (Preferred)

Work Location: In person