MIS Executive

Job Description

Collect, clean, and manage large datasets from various departments such as Production, QC, QA, Inventory, and Sales. Design and maintain dashboards, reports, and trackers using Advanced Excel techniques . Extract relevant data and filter it according to business requirements using appropriate formulas and logic. Work closely with cross-functional teams to provide actionable insights through data analysis. Automate recurring reports to ensure timely and accurate delivery of MIS reports. Analyze trends, performance metrics, and business KPIs to support decision-making. Maintain master data and ensure data accuracy and integrity at all times. Assist in audits and documentation by providing timely and accurate data. Expertise in Lookup & Reference Functions: VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH Logical Functions: IF, IFERROR, AND, OR, IFS Text Functions: CONCATENATE, TEXTJOIN, LEFT, RIGHT, MID, LEN, TRIM, SUBSTITUTE Date & Time Functions: TODAY, NOW, DATEDIF, EOMONTH, NETWORKDAYS Statistical & Math Functions: SUMIFS, COUNTIFS, AVERAGEIFS, ROUND, RANK Data Tools: Data Validation, Conditional Formatting, Remove Duplicates, Text to Columns Pivot Tables & Charts: Creating dynamic reports, dashboards with slicers & filters Power Query / Get & Transform: For merging, cleaning, and transforming large datasets Job Types: Full-time, Permanent Pay: ₹20,000.00 - ₹30,000.00 per month Benefits: Cell phone reimbursement Provident Fund Schedule: Day shift Ability to commute/relocate: Vashi, Navi Mumbai, Maharashtra: Reliably commute or planning to relocate before starting work (Required) Education: Bachelor's (Preferred) Experience: Pharma: 3 years (Required) Language: Fluent English (Required) Location: Vashi, Navi Mumbai, Maharashtra (Preferred) Work Location: In person