MIS Executive

Nitika Pharmaceutical Specialities Pvt. Ltd; Nagpur District; On-site; INR 250,000 - 420,000; Full time

Job summary

Nitika Pharmaceutical Specialities Pvt. Ltd invites applications for a detail-oriented MIS Executive to join our Manufacturing sector.

The role focuses on transforming raw data into actionable business intelligence, ensuring accurate reporting and timely decision-making for management. The successful candidate will liaison between data systems and strategic planning, leveraging Excel, Power Query, and SQL to monitor production metrics, track inventory, and optimize workflow efficiency.

Qualifications

• 0–1 year of experience in data analysis or BI.
• Advanced Excel skills including Pivot Tables, macros and complex formulas.
• Experience with Power Query and SQL preferred.
• Familiarity with manufacturing KPIs is a plus.

Responsibilities

• Design, maintain, and automate MIS and daily reports using Excel.
• Perform data cleaning and transformation to ensure data integrity.
• Execute data extraction and analysis workflows with Power Query and SQL.
• Generate dashboards and variance analyses for department heads.
• Collaborate with teams to define reporting requirements and streamline data collection.
• Validate data accuracy and resolve discrepancies in records.
• Assist in ad-hoc analysis and executive presentations.

Skills

Excel

Pivot Tables

Macros

Complex formulas

Data analysis

Tools

Power Query

SQL

Job description

Nitika Pharmaceutical Specialities Pvt. Ltd | Full time

We are seeking a detail-oriented MIS Executive to join our Manufacturing sector team. This pivotal role involves transforming raw operational data into actionable business intelligence, ensuring accurate reporting and timely decision-making for management. The successful candidate will serve as a key liaison between data systems and strategic planning, leveraging advanced analytical tools to monitor production metrics, track inventory levels, and optimize workflow efficiency. This position is ideal for a motivated individual with foundational experience who is eager to apply technical skills in a dynamic industrial environment.

Responsibilities

• Design, maintain, and automate comprehensive management information systems and daily reports using advanced spreadsheet functionalities.
• Perform complex data manipulation, cleaning, and transformation tasks to ensure high data integrity across various operational databases.
• Execute data extraction and analysis workflows using Power Query and SQL to support real-time business insights.
• Generate regular performance dashboards and variance analysis reports to assist department heads in identifying trends and operational bottlenecks.
• Collaborate with cross-functional teams to define reporting requirements and streamline data collection processes.
• Validate data accuracy and resolve discrepancies to maintain the reliability of organizational records.
• Assist in the preparation of ad-hoc analysis and presentations for senior leadership reviews.

Requirements

• Experience: 0-1 year of professional experience in data analysis, business intelligence, or a related administrative role.
• Technical Proficiency: Advanced command of Microsoft Excel, including proficiency in Pivot Tables, macros, and complex formulas.
• Data Tools: Hands-on experience with Power Query for data modeling and ETL processes.
• Database Skills: Fundamental knowledge of SQL for querying and retrieving data from relational databases.
• Industry Knowledge: Understanding of manufacturing processes and key performance indicators is highly beneficial.
• Analytical Mindset: Strong ability to interpret numerical data and translate findings into clear, concise business recommendations.
• Attention to Detail: Meticulous approach to data entry, verification, and report generation.