Senior MIS Executive

0 years

2 - 3 Lacs

Posted:14 hours ago| Platform: GlassDoor logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

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.

Job Type: Full-time

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

Work Location: In person

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

RecommendedJobs for You

kolkata, west bengal, india