Overview

PENNEP is seeking a detail-oriented and analytical MIS Executive to join our Clients manufacturing team. The ideal candidate will be responsible for managing business data, preparing management reports, analyzing operational performance, and supporting decision-making through accurate and timely MIS reporting. The candidate should possess strong Microsoft Excel skills and the ability to work with large datasets in a fast-paced manufacturing environment.

Key Responsibilities

- Prepare Daily, Weekly, and Monthly MIS reports for management.
- Collect, compile, and validate data from Production, Stores, Purchase, Sales, Quality, and Finance departments.
- Generate reports related to production, inventory, dispatch, procurement, sales, and machine utilization.
- Monitor daily production targets versus actual output and highlight variances.
- Prepare inventory reports, including Raw Materials, Work-in-Progress (WIP), Finished Goods, and stock movement.
- Analyse production and inventory data to identify trends, inefficiencies, and improvement opportunities.
- Develop and maintain MIS dashboards, charts, and performance reports using Microsoft Excel and reporting tools.
- Ensure the accuracy, consistency, and confidentiality of all business data and reports.
- Maintain and update ERP/MIS databases with accurate operational information.
- Coordinate with cross-functional teams to collect timely and accurate business data.
- Prepare ad hoc reports and business analyses as requested by management.
- Support monthly closing activities, stock audits, and management review meetings with required MIS reports.
- Identify opportunities to automate reporting processes and improve reporting efficiency.
- Maintain proper documentation, records, and backups of MIS reports and databases.
- Assist management in data-driven decision-making by providing accurate business insights.
- Ensure timely submission of reports while adhering to reporting standards and deadlines.
- Resolve data discrepancies by coordinating with relevant departments.




- Continuously improve reporting formats and MIS processes.
- Perform other MIS and reporting-related responsibilities assigned by management.

Required Qualifications

- Bachelor's degree in B.Com, BBA, BCA, B.Sc., Computer Applications, Statistics, Mathematics, or a related field.
- 1–2 years of experience in an MIS Executive or Data Reporting role.
- Experience in a manufacturing workplace will be preferred.

Required Skills

- Advanced proficiency in Microsoft Excel (Pivot Tables, VLOOKUP/XLOOKUP, INDEX-MATCH, IF Functions, Conditional Formatting, Data Validation).
- Strong analytical and problem-solving skills.
- Experience with ERP software ) is an advantage.
- Knowledge of Power BI and SQL is preferred.
- Excellent attention to detail and numerical aptitude.
- Strong communication and coordination skills.
- Ability to manage multiple tasks and meet reporting deadlines.

About PENNEP

PENNEP works with national and multinational clients and strives to become one of the world's leading professional services companies with a vision to transform clients' business, operating, and technology models for the digital era. Our leaders have 50 PLUS Years of combined and unique industry knowledge with a consultative approach that helps clients envision, build and run more innovative and efficient businesses.

Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government-issued ID during each interview.

PENNEP is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, colour, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law. We provide engineering excellence practices training for all our employees.

Pay: From ₹20,000.00 per month

Benefits:

- Health insurance
- Provident Fund

Education:

- Bachelor's (Preferred)

Experience:

- MIS Executive: 2 years (Required)
- Microsoft Excel: 2 years (Required)

Location:

- Jalandhar, Punjab (Required)

Work Location: In person

📌 MIS Executive (Jalandhar)
🏢 Pennsylvania Enterprise Private
📍 Jalandhar