MIS Analyst (App Script expert)

Location:

Salary:

Job Type:

Job Overview

MIS Analyst

MIS reporting, data analysis, Google App Script, Power BI, and Excel automation

production, sales, logistics, and R&D

• System Development & Automation
• Develop and implement automated workflows using Google App Script for improved efficiency.
• Set up automated alerts and reporting systems through Google Sheets.
• Identify and execute automation opportunities in data extraction, reporting, and operations.
• Collaborate with management to design new business applications and tools.
• Business Intelligence & Data Visualization
• Build and maintain interactive dashboards in Power BI for sales, production, and export/import data.
• Create predictive models, forecasts, and trend analyses to support business planning.
• Convert complex datasets into simple, actionable insights for stakeholders.
• Reporting & Data Management
• Generate and distribute accurate daily, weekly, monthly, and yearly reports.
• Key reports include:
• Daily Production summaries for Ambernath and other units.
• Sales reports by individual, region, and time period.
• R&D Experiment reports.
• Dispatch and logistics tracking reports.
• Ensure integrity, accuracy, and maintenance of factory master data.
• Monitor logistics shipments and compliance with documents like Advance Licences.
• Process Improvement & Operational Analytics
• Analyze data to identify bottlenecks, inefficiencies, and process improvements.
• Conduct ABC analysis for production and inventory optimization.
• Support continuous improvement with Operations, Quality, and Maintenance teams.
• Assist in forecasting, capacity planning, and inventory management models.
• Performance Management & KPI Tracking
• Maintain employee-specific checklists and trackers for daily/weekly activities.
• Generate and circulate KPI scorecards to management for performance monitoring.
  

Qualifications & Skills

• Education: Bachelor’s degree in IT, Computer Science, Statistics, Business Administration, or related field.
• Experience: 2–4 years in MIS, Data Analysis, or Business Analysis, preferably in a manufacturing industry.
• Technical Skills:
• Expert in Google App Script, Google Sheets, MS Excel (Pivot, VBA, Advanced Formulas).
• Proficient in Power BI dashboards and reporting.
• Working knowledge of SQL for data management.
• Analytical Skills: Strong problem-solving, data interpretation, and accuracy in reporting.
• Soft Skills: Strong communication, stakeholder collaboration, and proactive approach.
  

Preferred Qualifications

• Experience with additional visualization tools like Tableau.
• Programming knowledge in Python for data analysis.
• Familiarity with ERP systems (SAP, Oracle).
• Prior experience in the chemical or specialty organics industry.
  

• Opportunity to work on end-to-end MIS, analytics, and automation projects.
• Exposure to cross-functional operations – production, sales, logistics, and R&D.
• Competitive salary up to ₹50,000 per month.
• Work location: Andheri East, Mumbai.
  

Apply now and be part of a data-driven team driving operational excellence at Vipul Organics.