Mis Executive - SAP & Excel

Job Description MIS Executive

Job Title: MIS Executive
Department: MIS / Operations
Location: Preet Group
Experience: 2–5 Years
Employment Type: Full-Time

About the Role

We are looking for a detail-oriented and analytical MIS Executive with hands-on experience in SAP and Advanced MS Excel. The candidate will be responsible for preparing regular MIS reports, managing data, analyzing business information, and providing accurate reports to management for effective decision-making.

Key Responsibilities

• Prepare daily, weekly, and monthly MIS reports as per business requirements.
• Extract, manage, and analyze data from SAP/ERP systems.
• Maintain accurate and updated databases and MIS trackers.
• Prepare Excel dashboards, management reports, and analytical reports.
• Use advanced Excel functions such as VLOOKUP, XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, IF, and Pivot Tables.
• Create and maintain Pivot Tables, Pivot Charts, dashboards, and automated reports.
• Consolidate data from multiple departments and ensure data accuracy.
• Track and report key operational/business performance metrics.
• Identify data discrepancies and coordinate with concerned departments for corrections.
• Generate variance, productivity, sales, inventory, manpower, and other management reports as required.
• Maintain proper documentation and reporting formats.
• Support management with data analysis and ad-hoc reports.
• Coordinate with Finance, HR, Purchase, Production, Sales, and other departments for timely data collection.
• Ensure confidentiality and integrity of company data.
• Improve existing MIS processes and automate repetitive reporting wherever possible.

Required Skills

• Strong hands-on experience in MS Excel and SAP.
• Advanced knowledge of Excel formulas and functions.
• Good knowledge of Pivot Tables, Pivot Charts, Dashboards, and Data Analysis.
• Experience in preparing and maintaining MIS reports and trackers.
• Good analytical and problem-solving skills.
• Strong attention to detail and accuracy.
• Good communication and coordination skills.
• Ability to handle large volumes of data and meet reporting deadlines.

Preferred Qualifications

• Graduate in B.Com, BBA, BCA, or any relevant discipline.
• 2–5 years of relevant experience in MIS, Reporting, Operations, or Data Management.
• Experience in a manufacturing/engineering/industrial environment will be an added advantage.
• Knowledge of Power BI, Power Query, or Excel VBA/Macros will be an advantage.

Interested Candidate May Share Their Updated Resume To [email removed]