Manufacturing Digitization Engineer
Presupuesto: $10000.0
FIXED /
⭐ 0.00 (0)
India
sql, python, microsoft-power-bi, dashboard, cloud-architecture, sap
ABOUT THE ROLE
We are a global contract manufacturing company in the FMCG and pharma space. We are building a Digital Command Centre across our plants to give leadership a complete daily view of operations, finance, quality, supply chain, and workforce.
In this role, you will pull data from ERP exports, plant Excel files, machine APIs, and HR systems, build reliable pipelines, and surface it all as an automated daily report. You will also integrate with specialist IoT vendors to bring in machine-level operational data.
WHAT YOU WILL DO
MIS and Reporting
•Design and build an automated daily plant MIS report covering machine operations, financial performance, working capital, supply chain, quality, and workforce.
•Integrate data from ERP exports, plant Excel files, machine APIs, HR systems, and quality databases into a single clean data layer.
•Build and maintain Power BI (or equivalent) dashboards tracking OEE, energy intensity, plant P&L, cost per unit, budget vs actuals, inventory, supplier performance, batch rejection rates, attendance, and headcount.
•Own data quality: detect missing submissions, flag anomalies, and ensure corrections reach you before the morning report.
•Standardise metric definitions across plants: downtime, cost of production, rejection rate, and others.
•Automate data collection tasks: scheduled ERP exports, Excel intake pipelines, and email-based ingestion.
Machine and Operational Data
•Work with IoT vendors to integrate machine data (energy, runtime, downtime, production counts) into the central platform.
•Configure and maintain API connections or MQTT/OPC-UA feeds from IoT devices and energy meters.
•Ensure operational data flows into the MIS reliably without manual intervention from plant teams.
Infrastructure and Maintenance
•Build and maintain a central data store (cloud or on-premise) that consolidates all plant data.
•Write Python scripts for ETL pipelines, data validation, and report automation.
•Document all data sources, transformation logic, and report definitions clearly.
•Monitor pipeline health and resolve failures before they affect the morning report.
Abrir en Upwork