MIS Associate

<div><strong>Position:</strong> MIS Associate </div><div><strong>Experience</strong>: 2 to 4 years</div><div><strong>Location</strong>: Ranjangaon MIDC, Pune Plant</div><div><br></div><div><strong>Role Overview</strong></div><div>The MIS Executive – Recycling Plant will be the sole custodian and owner of all plant‑related data. This role is responsible for capturing, validating, maintaining, analysing, and reporting 100% of operational, inventory, and compliance data generated by the recycling facility. The position requires expert‑level proficiency in MS Excel and Power BI, strong control over inventory and basic accounting data, and the ability to convert complex plant operations into accurate, audit‑ready MIS and dashboards.</div><div>This role is mission‑critical for plant transparency, compliance, management decision‑making, and audits.</div><div style="text-align: center;"><br></div><div><strong>Key Responsibilities</strong></div><div><strong>1. Single Point Ownership of Plant Data (Core Accountability)</strong></div><ul style="list-style-type: disc; padding-left: 1.5em; margin-top: 0px; margin-bottom: 0px; list-style-type: disc; padding-left: 1.5em; margin-top: 0; margin-bottom: 0;"><li style="margin-left: 1.5em; margin-left: 1.5em;"><ul style="list-style-type: disc; padding-left: 1.5em; margin-top: 0px; margin-bottom: 0px; list-style-type: disc; padding-left: 1.5em; margin-top: 0; margin-bottom: 0;"><li style="margin-left: 1.5em; margin-left: 1.5em;">Ensure <strong>data integrity, consistency, accuracy, and traceability</strong> across all records.</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Maintain a <strong>single source of data</strong> for plant operations, inventory, processing, and dispatch data.</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Ensure real‑time or near‑real‑time data availability for management and compliance needs.</li></ul></li></ul><div style="text-align: center;"><br></div><div><strong>2. MIS, Reporting &amp; Data Analytics</strong></div><ul style="list-style-type: disc; padding-left: 1.5em; margin-top: 0px; margin-bottom: 0px; list-style-type: disc; padding-left: 1.5em; margin-top: 0; margin-bottom: 0;"><li style="margin-left: 1.5em; margin-left: 1.5em;"><ul style="list-style-type: disc; padding-left: 1.5em; margin-top: 0px; margin-bottom: 0px; list-style-type: disc; padding-left: 1.5em; margin-top: 0; margin-bottom: 0;"><li style="margin-left: 1.5em; margin-left: 1.5em;">Design, maintain, and continuously improve <strong>daily, weekly, monthly, and annual MIS reports</strong>.</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Independently develop and manage <strong>advanced Excel‑based MIS systems</strong>, including:</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Pivot tables &amp; pivot charts</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Power Query &amp; Power Pivot</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Advanced formulas (XLOOKUP, INDEX‑MATCH, SUMIFS, etc.)</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Structured templates and automation</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Build, maintain, and enhance <strong>Power BI dashboards</strong> covering:</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Material inflow vs outflow</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Inventory status &amp; ageing</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Processing efficiency &amp; yield</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Loss &amp; variance analysis</li><li style="margin-left: 1.5em; margin-left: 1.5em;">EPR‑wise and customer‑wise tracking</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Present insights, trends, and exceptions clearly to plant and management teams.</li></ul></li></ul><div style="text-align: center;"><br></div><div><strong>3. Inventory Data Management</strong></div><ul style="list-style-type: disc; padding-left: 1.5em; margin-top: 0px; margin-bottom: 0px; list-style-type: disc; padding-left: 1.5em; margin-top: 0; margin-bottom: 0;"><li style="margin-left: 1.5em; margin-left: 1.5em;"><ul style="list-style-type: disc; padding-left: 1.5em; margin-top: 0px; margin-bottom: 0px; list-style-type: disc; padding-left: 1.5em; margin-top: 0; margin-bottom: 0;"><li style="margin-left: 1.5em; margin-left: 1.5em;">Maintain <strong>end‑to‑end inventory MIS</strong> covering:</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Incoming e‑waste</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Work‑in‑process (WIP)</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Recovered materials</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Scrap and residue</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Perform <strong>daily reconciliation</strong> between physical stock and MIS records.</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Track batch‑wise and lot‑wise material movement for full traceability.</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Proactively highlight shortages, excess, slow‑moving, or abnormal variances.</li></ul></li></ul><div style="text-align: center;"><br></div><div><strong>4. Basic Accounting &amp; Commercial Data Support</strong></div><ul style="list-style-type: disc; padding-left: 1.5em; margin-top: 0px; margin-bottom: 0px; list-style-type: disc; padding-left: 1.5em; margin-top: 0; margin-bottom: 0;"><li style="margin-left: 1.5em; margin-left: 1.5em;"><ul style="list-style-type: disc; padding-left: 1.5em; margin-top: 0px; margin-bottom: 0px; list-style-type: disc; padding-left: 1.5em; margin-top: 0; margin-bottom: 0;"><li style="margin-left: 1.5em; margin-left: 1.5em;">Maintain and Support MIS related to:</li><li style="margin-left: 1.5em; margin-left: 1.5em;">GRNs, delivery challans, internal transfers</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Invoices (input/output mapping for reference)</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Processing charges, logistics costs, and recoveries</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Support the accounts team with <strong>accurate data, reconciliations, and supporting schedules</strong>.</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Ensure MIS aligns with accounting records for audits and management reviews.</li></ul></li></ul><div style="text-align: center;"><br></div><div><strong>5. Compliance, Documentation &amp; Audit Support</strong></div><ul style="list-style-type: disc; padding-left: 1.5em; margin-top: 0px; margin-bottom: 0px; list-style-type: disc; padding-left: 1.5em; margin-top: 0; margin-bottom: 0;"><li style="margin-left: 1.5em; margin-left: 1.5em;"><ul style="list-style-type: disc; padding-left: 1.5em; margin-top: 0px; margin-bottom: 0px; list-style-type: disc; padding-left: 1.5em; margin-top: 0; margin-bottom: 0;"><li style="margin-left: 1.5em; margin-left: 1.5em;">Maintain <strong>audit‑ready data and reports</strong> for:</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Prepare and maintain:</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Recycling and destruction data</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Input–output statements</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Certificates and supporting annexures (data perspective)</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Ensure <strong>zero data gaps during audits</strong> and inspections.</li></ul></li></ul><div style="text-align: center;"><br></div><div><strong>6. Data Controls, Governance &amp; Improvement</strong></div><ul style="list-style-type: disc; padding-left: 1.5em; margin-top: 0px; margin-bottom: 0px; list-style-type: disc; padding-left: 1.5em; margin-top: 0; margin-bottom: 0;"><li style="margin-left: 1.5em; margin-left: 1.5em;"><ul style="list-style-type: disc; padding-left: 1.5em; margin-top: 0px; margin-bottom: 0px; list-style-type: disc; padding-left: 1.5em; margin-top: 0; margin-bottom: 0;"><li style="margin-left: 1.5em; margin-left: 1.5em;">Establish <strong>strong data controls</strong>, validation checks, and approval workflows.</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Identify opportunities for <strong>MIS automation, standardization, and simplification</strong>.</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Continuously improve reporting quality, accuracy, and turnaround time.</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Ensure confidentiality and security of sensitive business and or compliance data.</li></ul></li></ul><div style="text-align: center;"><br></div><div><strong>Mandatory Skill Requirements</strong></div><div><strong>Technical Skills (Non‑Negotiable)</strong></div><ul style="list-style-type: disc; padding-left: 1.5em; margin-top: 0px; margin-bottom: 0px; list-style-type: disc; padding-left: 1.5em; margin-top: 0; margin-bottom: 0;"><li style="margin-left: 1.5em; margin-left: 1.5em;"><ul style="list-style-type: disc; padding-left: 1.5em; margin-top: 0px; margin-bottom: 0px; list-style-type: disc; padding-left: 1.5em; margin-top: 0; margin-bottom: 0;"><li style="margin-left: 1.5em; margin-left: 1.5em;"><strong>Expert‑level MS Excel</strong> (advanced automation, MIS design, error‑proofing).</li><li style="margin-left: 1.5em; margin-left: 1.5em;"><strong>Strong Power BI skills</strong> (data modelling, DAX basics, dashboards, visuals).</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Very strong numeric, logical, and analytical ability.</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Working knowledge of <strong>inventory management principles</strong>.</li><li style="margin-left: 1.5em; margin-left: 1.5em;"><strong>Basic accounting knowledge</strong> relevant to plant and inventory operations.</li></ul></li></ul><div style="text-align: center;"><br></div><div><strong>Experience &amp; Qualification</strong></div><ul style="list-style-type: disc; padding-left: 1.5em; margin-top: 0px; margin-bottom: 0px; list-style-type: disc; padding-left: 1.5em; margin-top: 0; margin-bottom: 0;"><li style="margin-left: 1.5em; margin-left: 1.5em;"><ul style="list-style-type: disc; padding-left: 1.5em; margin-top: 0px; margin-bottom: 0px; list-style-type: disc; padding-left: 1.5em; margin-top: 0; margin-bottom: 0;"><li style="margin-left: 1.5em; margin-left: 1.5em;">Graduate / Diploma (Mechanical/Electrical/Electronic Engineering, Statistics, Data/Operations preferred).</li><li style="margin-left: 1.5em; margin-left: 1.5em;"><strong>3–6 years of hands‑on MIS experience</strong>, preferably in:</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Automobile OE dealer service workshop</li><li style="margin-left: 1.5em; margin-left: 1.5em;">SPM Manufacturing plants, Engineering and MRO Plants</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Paint and Chemical Process industries</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Compliance‑driven operations</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Experience as a <strong>standalone MIS role</strong> is highly desirable.</li></ul></li></ul><div style="text-align: center;"><br></div><div><strong>Behavioural &amp; Professional Expectations</strong></div><ul style="list-style-type: disc; padding-left: 1.5em; margin-top: 0px; margin-bottom: 0px; list-style-type: disc; padding-left: 1.5em; margin-top: 0; margin-bottom: 0;"><li style="margin-left: 1.5em; margin-left: 1.5em;"><ul style="list-style-type: disc; padding-left: 1.5em; margin-top: 0px; margin-bottom: 0px; list-style-type: disc; padding-left: 1.5em; margin-top: 0; margin-bottom: 0;"><li style="margin-left: 1.5em; margin-left: 1.5em;">Extremely high attention to detail and discipline.</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Ability to work independently with minimal supervision.</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Strong ownership mindset — understands impact of data errors.</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Ability to handle pressure during audits and management reviews.</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Clear communication and documentation skills.</li></ul></li></ul><div style="text-align: center;"><br></div><div><strong>Performance Expectations</strong></div><ul style="list-style-type: disc; padding-left: 1.5em; margin-top: 0px; margin-bottom: 0px; list-style-type: disc; padding-left: 1.5em; margin-top: 0; margin-bottom: 0;"><li style="margin-left: 1.5em; margin-left: 1.5em;"><ul style="list-style-type: disc; padding-left: 1.5em; margin-top: 0px; margin-bottom: 0px; list-style-type: disc; padding-left: 1.5em; margin-top: 0; margin-bottom: 0;"><li style="margin-left: 1.5em; margin-left: 1.5em;">100% data accuracy and timely reporting.</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Zero major audit observations related to data or MIS.</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Actionable insights provided regularly to management.</li><li style="margin-left: 1.5em; margin-left: 1.5em;">Continuous improvement in data quality and reporting efficiency.</li></ul></li></ul>