MIS Analyst

Department:

Reports to:

Position Overview:

Vipul Organics is seeking a detail-oriented and proactive MIS Analyst to join our dynamic team. The ideal candidate will be a data evangelist, responsible for transforming raw data into actionable business intelligence. You will play a crucial role in developing automated systems, generating critical reports, and providing data-driven insights that support strategic decision-making across production, sales, logistics, and R&D. This role requires a strong blend of technical skills in data analysis, automation (especially with Google App Script and Power BI), and a deep understanding of business processes in a manufacturing environment.

Key Result Areas (KRAs) & Responsibilities:

1. System Development & Automation:

• Design, develop, and implement new process workflows and automated systems using Google App Script to enhance operational efficiency.
• Create and manage automated email alert systems within Google Sheets to provide real-time updates on critical business events as per management requirements.
• Proactively identify opportunities for automation in data extraction, reporting, and daily tasks, utilizing tools like Google App Script, Power BI, and Excel VBA.
• Collaborate with management to conceptualize and build new systems and applications to meet evolving business needs.

2. Business Intelligence & Data Visualization:

• Develop, maintain, and enhance interactive dashboards and live business analysis reports using Power BI, focusing on key metrics like export/import data, production, and sales.
• Utilize data visualization tools to create predictive models, forecasting results, and trend analyses to support strategic planning.
• Translate complex datasets into clear, concise, and compelling visual stories for stakeholders at all levels.

3. Reporting & Data Management:

• Generate and circulate accurate daily, weekly, monthly, and yearly reports on key metrics, including:
• Daily Production summaries for Ambernath and other factory locations.
• Sales performance reports by individual, region, and period.
• R&D Experiment reports.
• Dispatch details and logistics shipment tracking.
• Ensure the integrity, accuracy, and maintenance of all factory-related master data.
• Track and report on logistics shipments, ensuring compliance with documentation like Advance Licences.

4. Process Improvement & Operational Analytics:

• Analyze operational data to identify bottlenecks, inefficiencies, and areas for improvement within production, logistics, and other departments.
• Perform Production ABC analysis to optimize inventory, resource allocation, and cost control.
• Collaborate with Operations, Quality, and Maintenance teams to support data-driven continuous improvement initiatives.
• Assist in demand forecasting, capacity planning, and inventory optimization models to enhance overall operational effectiveness.

5. Performance Management & KPI Tracking:

• Develop and maintain employee-specific checklists and performance trackers to monitor daily and weekly activities.
• Generate and distribute weekly and monthly Key Performance Indicator (KPI) report cards for employees, providing actionable insights to management and team leads.

Required Skills and Qualifications:

• Education:

  Bachelors degree in Information Technology, Computer Science, Statistics, Business Administration, or a related field.

• Experience:

  2-4 years of proven experience in an MIS, Data Analyst, or Business Analyst role, preferably within a manufacturing industry.

• Technical Skills:

• Expert Proficiency:

  Google App Script, Google Sheets, and MS Excel (Advanced formulas, Pivot Tables, VBA).

• Strong Proficiency:

  Power BI for creating dashboards and reports.

• Working Knowledge:

  SQL for data querying and manipulation.

• Analytical Skills:

  Strong analytical and problem-solving skills with an exceptional ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.

• Soft Skills:

  Excellent communication skills, ability to work collaboratively with cross-functional teams, and a proactive mindset.

Preferred Qualifications:

• Experience with other data visualization tools (e.g., Tableau).
• Knowledge of programming languages like Python for data analysis.
• Familiarity with ERP systems (e.g., SAP, Oracle).
• Direct experience in the chemical or specialty organics industry.