Mis Executive - SAP & Excel

Preet EPC P Limited; Hapur; On-site; INR 300,000 - 420,000; Full time

Job summary

Preet EPC P Limited in Uttar Pradesh, India, is seeking a detail-oriented MIS Executive to join the MIS / Operations team. You will prepare regular MIS reports, manage data from SAP/ERP, and provide accurate reports to management for decision-making.

The ideal candidate has 2–5 years of experience, strong Excel skills (VLOOKUP, XLOOKUP, Pivot Tables) and a background in manufacturing or related environments. This is a full-time, on-site role based in Uttar Pradesh.

Qualifications

• Graduates in B.Com, BBA, BCA or similar.
• 2–5 years of MIS, Reporting, Operations or Data Management.
• Experience in manufacturing/engineering/industrial environments helpful.
• Power BI, Power Query or Excel VBA/Macros knowledge is advantageous.

Responsibilities

• Prepare daily, weekly, and monthly MIS reports as required.
• Extract, manage, and analyze data from SAP/ERP systems.
• Maintain accurate MIS trackers and databases.
• Create Excel dashboards and management reports.
• Use advanced Excel functions (VLOOKUP, XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, IF) and Pivot Tables.
• Develop Pivot Tables, Pivot Charts, dashboards, and automated reports.
• Consolidate data from multiple departments and ensure accuracy.
• Track operational and performance metrics and report variances.
• Coordinate with Finance, HR, Purchase, Production, and Sales for data collection.
• Identify data discrepancies and push corrections.
• Assist management with ad-hoc data analysis.

Skills

MS Excel

SAP

Pivot Tables

Pivot Charts

Dashboards

Data analysis

Excel formulas

VLOOKUP

XLOOKUP

Education

B.Com / BBA / BCA

Tools

Power BI

Power Query

Excel VBA/Macros

Job description

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.