Job Summary

We are looking for a detail-oriented and analytical MIS Executive / Data Analyst to manage daily business data from Production, Accounts, and Operations departments. The candidate will be responsible for maintaining Excel reports, updating ERP records, analyzing operational performance, reconciling data, and preparing accurate MIS reports and dashboards for management.

The ideal candidate should have strong MS Excel skills, good analytical abilities, accuracy in data management, and the ability to coordinate with multiple departments in a manufacturing environment.

Key Responsibilities

1. Daily Data Collection & Management

- Collect daily data from Production, Accounts, and Operations teams.
- Consolidate data from different departments into a centralized reporting system.
- Verify data accuracy, completeness, and consistency before reporting.
- Follow up with departments for missing, incorrect, or delayed information.

2. MIS Reporting & Excel Management

- Prepare and maintain daily, weekly, and monthly MIS reports.
- Maintain Excel sheets, trackers, dashboards, and performance reports.
- Use Pivot Tables, VLOOKUP/XLOOKUP, SUMIFS, IF formulas, filters, and conditional formatting.
- Standardize reporting formats and improve reporting efficiency through automation.

3. Production Data Analysis

- Monitor daily production, batch processing, target achievement, and machine output.
- Track rejection, rewash, shade variation, and other production losses.
- Analyze production targets versus actual performance.
- Identify deviations, recurring issues, and opportunities for improvement.





4. Accounts & Cost Data Coordination

- Collect and consolidate relevant expense and consumption data from the Accounts team.
- Coordinate on production costs, electricity consumption, fuel consumption, and other operational expenses.
- Reconcile departmental reports with available ERP records and supporting documents.
- Highlight unusual variations and data discrepancies to management.

5. ERP Data Management

- Enter, update, verify, and maintain data in the company's ERP software.
- Cross-check ERP reports against Excel sheets and departmental records.
- Identify missing entries, duplicate records, and inconsistencies.
- Coordinate with relevant teams to resolve ERP data-related issues.

6. Operations Monitoring & Analysis

- Track machine utilization, downtime, pending batches, and operational performance.
- Prepare daily performance summaries and highlight important deviations.
- Identify trends and provide data-based observations to management.
- Support process improvement through accurate and timely reporting.

7. Management Reporting

- Submit daily MIS reports within the defined timeline.
- Prepare weekly and monthly dashboards summarizing key performance indicators (KPIs).




- Highlight production shortfalls, cost variations, operational issues, and pending actions.
- Maintain proper records, documentation, and confidentiality of company data.

Required Skills
- Strong working knowledge of MS Excel and MIS reporting.
- Experience in Pivot Tables, VLOOKUP/XLOOKUP, SUMIFS, IF formulas, and dashboard preparation.
- Positive analytical, numerical, and data reconciliation skills.
- Experience with ERP software and business reporting systems.
- Strong coordination and communication skills.
- High attention to detail and accuracy.
- Ability to manage multiple reports and meet daily deadlines.

Preferred Experience
- Experience in manufacturing, textile, garment washing, dyeing, or other production-based industries.
- Experience handling data from multiple departments.
- Knowledge of Power BI and Excel-based reporting automation.
- Experience preparing production MIS and cost analysis reports.

Performance Expectations
- Accurate and timely daily MIS reporting.
- Proper reconciliation of Excel records with ERP and departmental data.
- Timely identification and reporting of data discrepancies.
- Reliable production and operational performance dashboards.
- Improved reporting efficiency and reduced manual errors.

How to Apply: Interested candidates may share their updated resume, current salary, expected salary, notice period, and details of their Excel and ERP experience.

Pay: ₹306,000.00 - ₹1,320,000.00 per year

Work Location: In person

📌 Data Analyst – Production & Operations (Gurugram)
🏢 R C J C
📍 Gurugram