Key Responsibilities :
Reporting & BI Development :
- Build and maintain real-time dashboards and visualizations in Power BI, Tableau, and Grafana.
- Define and implement data cubes and multi-dimensional models for fast, flexible analysis.
- Deliver multiple output format reports meeting OSAT customer needs
- Develop portals for internal and external users to access reports with right level of access control
MES, OEE & Traceability Systems :
Integrate MES data (e.g., Camstar, FactoryWorks, Critical Manufacturing, Si View) to capture complete product / process traceability .Automate OEE tracking including availability, performance, and quality metrics.Enable deep-dive root cause and trend analysis using historical equipment / process data.Data Engineering :
Design and manage staging tables , stored procedures , and ETL processes to clean, transform, and prepare data from MES, ERP, and external sources.Ensure efficient loading and transformation of large datasets into data warehouses or big data platforms .Optimize performance of dashboards and queries using indexes, partitions, and pre-aggregated views.B2B / EDI Integration :
Manage B2B / RosettaNet / EDI data exchange with external partners and customersMaintain EDI mappings, monitor data quality, and ensure error-free delivery of key documentsCollaborate with IT and business teams to troubleshoot and enhance partner integration pipelines.Big Data & Advanced Analytics :
Enable analytics on unstructured or sensor data from equipment, testers, and traceability logs.Support predictive maintenance, yield prediction, and anomaly detection initiatives.Cross-functional Enablement :
Work with Manufacturing, Engineering, Quality, and Supply Chain to understand reporting and data needs.Train users and promote self-service BI capabilities.Act as a thought leader in modern manufacturing analytics and traceability solutions.Qualifications :
Bachelor’s or Master’s degree in Engineering, Computer Science, Information Systems, or related.10+ years in a reporting or BI leadership role within a semiconductor , electronics , or OSAT environment.Good understanding of MES DB SchemaProficient in Power BI (required), with experience in Grafana and Tableau .Deep experience with MES systems , OEE metrics , and traceability frameworks .Strong understanding of stored procedures , staging areas , and data warehousing best practices .Familiarity with OLAP / data cubes and multidimensional data modeling.Strong SQL skills and ETL pipeline experienceKey Skills & Competencies :
Advanced Data Modeling & EngineeringMES / OEE / ERP IntegrationBI Tools (Power BI, Grafana, Tableau)Data Warehouse & Cube DesignTraceability & Compliance ReportingB2B / RosettaNet / EDI Data ExchangeBig Data Analytics & ScalabilityCross-functional CommunicationContinuous Improvement Mindset