MIS Associate

×

MIS Associate

Attero – Pune, Maharashtra, India

Refined job description

ROLE
– Ensure data integrity, consistency, accuracy, and traceability across all records
– Maintain a single source of data for plant operations, inventory, processing, and dispatch data
– Ensure real-time or near-real-time data availability for management and compliance needs
– Design, maintain, and continuously improve daily, weekly, monthly, and annual MIS reports
– Independently develop and manage advanced Excel-based MIS systems
– Build, maintain, and enhance Power BI dashboards
– Present insights, trends, and exceptions clearly to plant and management teams
– Maintain end-to-end inventory MIS
– Perform daily reconciliation between physical stock and MIS records
– Track batch-wise and lot-wise material movement for full traceability
– Proactively highlight shortages, excess, slow-moving, or abnormal variances
– Maintain and Support MIS related to GRNs, delivery challans, internal transfers, and invoices
– Support the accounts team with accurate data, reconciliations, and supporting schedules
– Ensure MIS aligns with accounting records for audits and management reviews
– Maintain audit-ready data and reports
– Establish strong data controls, validation checks, and approval workflows
– Identify opportunities for MIS automation, standardization, and simplification
– Continuously improve reporting quality, accuracy, and turnaround time
– Ensure confidentiality and security of sensitive business and or compliance data

REQUIREMENTS
– Expert-level MS Excel
– Strong Power BI skills
– Very strong numeric, logical, and analytical ability
– Working knowledge of inventory management principles
– Basic accounting knowledge relevant to plant and inventory operations
– 3–6 years of hands-on MIS experience
– Extremely high attention to detail and discipline
– Ability to work independently with minimal supervision
– Strong ownership mindset
– Ability to handle pressure during audits and management reviews
– Clear communication and documentation skills

Full job description

Ensure data integrity, consistency, accuracy, and traceability across all records. Maintain a single source of data for plant operations, inventory, processing, and dispatch data. Ensure real‑time or near‑real‑time data availability for management and compliance needs. | Ensure data integrity, consistency, accuracy, and traceability across all records. | Maintain a single source of data for plant operations, inventory, processing, and dispatch data. | Ensure real‑time or near‑real‑time data availability for management and compliance needs. | Design, maintain, and continuously improve daily, weekly, monthly, and annual MIS reports. Independently develop and manage advanced Excel‑based MIS systems, including: Pivot tables & pivot charts Power Query & Power Pivot Advanced formulas (XLOOKUP, INDEX‑MATCH, SUMIFS, etc.) Structured templates and automation Build, maintain, and enhance Power BI dashboards covering: Material inflow vs outflow Inventory status & ageing Processing efficiency & yield Loss & variance analysis EPR‑wise and customer‑wise tracking Present insights, trends, and exceptions clearly to plant and management teams. | Design, maintain, and continuously improve daily, weekly, monthly, and annual MIS reports. | Independently develop and manage advanced Excel‑based MIS systems, including: | Pivot tables & pivot charts | Power Query & Power Pivot | Advanced formulas (XLOOKUP, INDEX‑MATCH, SUMIFS, etc.) | Structured templates and automation | Build, maintain, and enhance Power BI dashboards covering: | Material inflow vs outflow | Inventory status & ageing | Processing efficiency & yield | Loss & variance analysis | EPR‑wise and customer‑wise tracking | Present insights, trends, and exceptions clearly to plant and management teams. | Maintain end‑to‑end inventory MIS covering: Incoming e‑waste Work‑in‑process (WIP) Recovered materials Scrap and residue Perform daily reconciliation between physical stock and MIS records. Track batch‑wise and lot‑wise material movement for full traceability. Proactively highlight shortages, excess, slow‑moving, or abnormal variances. | Maintain end‑to‑end inventory MIS covering: | Incoming e‑waste | Work‑in‑process (WIP) | Recovered materials | Scrap and residue | Perform daily reconciliation between physical stock and MIS records. | Track batch‑wise and lot‑wise material movement for full traceability. | Proactively highlight shortages, excess, slow‑moving, or abnormal variances. | Maintain and Support MIS related to: GRNs, delivery challans, internal transfers Invoices (input/output mapping for reference) Processing charges, logistics costs, and recoveries Support the accounts team with accurate data, reconciliations, and supporting schedules. Ensure MIS aligns with accounting records for audits and management reviews. | Maintain and Support MIS related to: | GRNs, delivery challans, internal transfers | Invoices (input/output mapping for reference) | Processing charges, logistics costs, and recoveries | Support the accounts team with accurate data, reconciliations, and supporting schedules. | Ensure MIS aligns with accounting records for audits and management reviews. | Maintain audit‑ready data and reports for: Prepare and maintain: Recycling and destruction data Input–output statements Certificates and supporting annexures (data perspective) Ensure zero data gaps during audits and inspections. | Maintain audit‑ready data and reports for: | Prepare and maintain: | Recycling and destruction data | Input–output statements | Certificates and supporting annexures (data perspective) | Ensure zero data gaps during audits and inspections. | Establish strong data controls, validation checks, and approval workflows. Identify opportunities for MIS automation, standardization, and simplification. Continuously improve reporting quality, accuracy, and turnaround time. Ensure confidentiality and security of sensitive business and or compliance data. | Establish strong data controls, validation checks, and approval workflows. | Identify opportunities for MIS automation, standardization, and simplification. | Continuously improve reporting quality, accuracy, and turnaround time. | Ensure confidentiality and security of sensitive business and or compliance data. | Expert‑level MS Excel (advanced automation, MIS design, error‑proofing). Strong Power BI skills (data modelling, DAX basics, dashboards, visuals). Very strong numeric, logical, and analytical ability. Working knowledge of inventory management principles. Basic accounting knowledge relevant to plant and inventory operations. | Expert‑level MS Excel (advanced automation, MIS design, error‑proofing). | Strong Power BI skills (data modelling, DAX basics, dashboards, visuals). | Very strong numeric, logical, and analytical ability. | Working knowledge of inventory management principles. | Basic accounting knowledge relevant to plant and inventory operations. | Graduate / Diploma (Mechanical/Electrical/Electronic Engineering, Statistics, Data/Operations preferred). 3–6 years of hands‑on MIS experience, preferably in: Automobile OE dealer service workshop SPM Manufacturing plants, Engineering and MRO Plants Paint and Chemical Process industries Compliance‑driven operations Experience as a standalone MIS role is highly desirable. | Graduate / Diploma (Mechanical/Electrical/Electronic Engineering, Statistics, Data/Operations preferred). | 3–6 years of hands‑on MIS experience, preferably in: | Automobile OE dealer service workshop | SPM Manufacturing plants, Engineering and MRO Plants | Paint and Chemical Process industries | Compliance‑driven operations | Experience as a standalone MIS role is highly desirable. | Extremely high attention to detail and discipline. Ability to work independently with minimal supervision. Strong ownership mindset — understands impact of data errors. Ability to handle pressure during audits and management reviews. Clear communication and documentation skills. | Extremely high attention to detail and discipline. | Ability to work independently with minimal supervision. | Strong ownership mindset — understands impact of data errors. | Ability to handle pressure during audits and management reviews. | Clear communication and documentation skills. | 100% data accuracy and timely reporting. Zero major audit observations related to data or MIS. Actionable insights provided regularly to management. Continuous improvement in data quality and reporting efficiency. | 100% data accuracy and timely reporting. | Zero major audit observations related to data or MIS. | Actionable insights provided regularly to management. | Continuous improvement in data quality and reporting efficiency.