Key Responsibilities
- Develop real-time and management-level KPI dashboards.
- Collect and integrate data from ERP, MES, machines, Excel, databases, and production systems.
- Build dashboards for plant, department, production line, machine, shift, and operator-level performance.
- Automate daily, weekly, and monthly production reports.
- Identify production losses, bottlenecks, downtime, and efficiency gaps.
- Create drill-down reports for root-cause analysis.
- Work with Production, Quality, Maintenance, PPC, and Management teams.
- Validate KPI calculations and ensure data accuracy.
- Provide alerts for production delays, downtime, target gaps, and abnormal performance.
- Support dashboard deployment, user training, and documentation.

Manufacturing KPIs
- Overall Equipment Effectiveness — OEE
- Production Target vs Actual
- Machine Utilization
- Capacity Utilization
- Production Efficiency
- Cycle Time
- Takt Time
- Throughput
- First Pass Yield
- Rejection and Rework Percentage
- Scrap Rate
- Downtime Analysis
- Breakdown Frequency
- Mean Time Between Failures — MTBF




- Mean Time to Repair — MTTR
- Changeover Time
- Plan vs Actual Production
- Schedule Adherence
- Labour Productivity
- Operator Efficiency
- Line Efficiency
- Work-in-Progress
- On-Time Delivery
- Cost per Unit

Technical Skills
- Power BI, Tableau, Qlik Sense, or similar BI tools
- Advanced Excel and Power Query
- SQL Server, MySQL, PostgreSQL, or Oracle
- DAX and data modelling
- Data visualization and dashboard UX
- REST API and ERP/MES integration
- Knowledge of Python will be an advantage
- Experience with cloud platforms such as Azure or AWS will be preferred

Manufacturing Knowledge
- Production planning and control
- Shop-floor operations
- Lean manufacturing
- Six Sigma
- TPM
- Kaizen
- 5S
- Industry 4.0
- Machine downtime and loss analysis
- Quality and rejection monitoring
- Preventive and breakdown maintenance

Preferred Experience
- 3-7 years of experience in dashboard development, MI

📌 Manufacturing Kpi Dashboard Developer (Noida)
🏢 Mega Growth Interactives
📍 Noida