Responsible for designing, implementing, and maintaining Management Information Systems primarily using Google Sheets and Google Workspace tools. The role involves data consolidation, automation, dashboard creation, process improvement, and supporting teams in adopting efficient digital systems.

Key Responsibilities:

- Design, build, and maintain Google Sheets-based MIS systems for sales, inventory, operations, and other business functions.

- Consolidate data from multiple Excel/Google Sheets files into centralized, reliable systems using related functions.

- Create agile dashboards with key metrics (total sales, growth, top products, regional performance, etc.) using pivot tables, charts, and formulas.

- Implement data validation, dynamic dropdown lists, named ranges, and access controls to ensure data accuracy and security.

- Automate recurring reports and workflows using Google Apps Script.

- Support change management during transitions from Excel to Google Sheets-based systems.

Required Skills & Competencies:

- Strong hands-on proficiency in Google Sheets (formulas, ARRAYFORMULA, QUERY, IMPORTRANGE, data validation, pivot tables, conditional formatting).

- Solid understanding of systems thinking: ability to assess current processes, design solutions, implement them, and plan for training/backup/transition.





- Experience in data consolidation, cleaning, and creating user-friendly dashboards.

- Ability to automate reports and workflows (basic Google Apps Script knowledge preferred).

- Strong problem-solving and systematic troubleshooting approach.

- Good communication skills – ability to explain technical concepts clearly to non-technical users.

- Self-learning ability and proactive approach to acquiring new technical skills.

- Patience and teaching orientation for training colleagues.

Preferred Qualifications:

- Bachelor’s degree in any discipline (Commerce, Computer Applications, Business Administration, or related field preferred).

- Prior experience in MIS, data analysis, operations support, or similar roles (1–3 years ideal).

- Familiarity with Google Workspace ecosystem (Forms, Drive, Apps Script).

- Exposure to process improvement or basic automation projects.

Soft Skills & Attributes:

- Initiative and ownership mindset.

- Collaborative and patient attitude.

- Ability to handle resistance to change constructively.

- Clear documentation and structured working style.

- Positive attitude toward continuous learning.

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

Benefits

- Flexible schedule

- Paid time off

Work Location: In person

📌 MIS Executive (Vile Parle)
🏢 NAC Electro Work
📍 Vile Parle