Job Title: Data Management Engineer – PPC

Experience: 4–5 Years Relevant Experience Automobile Industries

CTC: ₹38,000 – ₹40,000 per month

Employment Type: Full-time

Job Summary

We are looking for a Data Management Engineer – PPC with 4–5 years of relevant experience in data management, PPC planning, MIS reporting, SQL, Power BI, and Advanced Excel. The candidate will be responsible for production planning data, inventory analysis, MIS, reporting automation, and coordination with production and other cross-functional teams.

Key Responsibilities

PPC Planning & Coordination

- Prepare and maintain production plans based on customer orders, demand, inventory, and production capacity.
- Monitor daily/weekly production schedules and ensure timely execution.
- Track production targets vs. actual production and highlight variances.
- Coordinate with Production, Stores, Purchase, Quality, and Dispatch teams.
- Monitor material availability and identify potential shortages affecting production.
- Maintain PPC-related data, trackers, and reports.
- Analyze production capacity, pending orders, lead times, and bottlenecks.
- Support capacity planning and production scheduling.

Data Management & MIS

- Manage, maintain, and validate data from multiple sources.
- Develop and maintain Power BI dashboards and MIS reports.
- Prepare daily, weekly, and monthly reports for management.
- Track KPIs related to production, inventory, procurement, dispatch, and operational performance.
- Perform data cleaning, validation, reconciliation, and quality checks.
- Identify data discrepancies and coordinate with relevant teams for resolution.




- Automate regular reports using Power BI, Excel, SQL, and Power Query.

Technical Responsibilities

- Write and optimize SQL queries for data extraction, validation, and analysis.
- Develop Power BI dashboards using DAX, Power Query, and data modelling.
- Use Advanced Excel for data analysis, reporting, and automation.
- Analyze production and inventory data to identify trends, gaps, and bottlenecks.
- Convert business/PPC requirements into meaningful dashboards and reports.

Required Skills
- 4–5 years of relevant experience in Data Management, MIS, PPC, Production Planning, or a similar role.
- Strong knowledge of PPC / Production Planning & Control.
- Hands-on experience with SQL, Power BI, and Advanced Excel.
- Knowledge of production planning, inventory, material planning, and capacity utilization.
- Strong analytical and problem-solving skills.
- Good understanding of MIS and management reporting.
- Experience working with large datasets.
- Solid coordination and communication skills.
- Knowledge of ERP systems will be an added advantage.
- Knowledge of Python/automation will be an advantage.

Education Bachelor's degree in Engineering, Computer Science, IT, Data Science, Operations, Statistics, or a related field.

Ideal Candidate The ideal candidate should be a data-driven PPC professional who can combine production planning + data analytics + MIS + Power BI/SQL to improve production visibility, planning accuracy, and operational efficiency.

Salary: ₹38,000–₹40,000 per month CTC

Experience: 4–5 Years

Pay: ₹38,000.00 - ₹40,000.00 per month

Benefits

- Provident Fund

Work Location: In person

📌 Data Analyst (Gurugram)
🏢 The Wyth
📍 Gurugram