Reporting Leader (Big Data/MES)

As an experienced Reporting & BI Developer, you will be responsible for the following key activities: - Build and maintain real-time dashboards and visualizations using Power BI, Tableau, and Grafana. - Define and implement data cubes and multi-dimensional models for quick and flexible analysis. - Deliver reports in multiple output formats to meet OSAT customer requirements. - Develop portals for internal and external users with the right level of access control. - Integrate MES data from systems like Camstar, FactoryWorks, Critical Manufacturing, and Si View to achieve complete product/process traceability. - Automate OEE tracking, including availability, performance, and quality metrics. - Conduct deep-dive root cause and trend analysis using historical equipment/process data. - 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 dashboard and query performance using indexes, partitions, and pre-aggregated views. - Manage B2B/RosettaNet/EDI data exchange with external partners and customers. - Maintain EDI mappings, monitor data quality, and ensure error-free delivery of key documents. - Collaborate with IT and business teams to troubleshoot and enhance partner integration pipelines. - Enable analytics on unstructured or sensor data from equipment, testers, and traceability logs. - Support initiatives such as predictive maintenance, yield prediction, and anomaly detection. - Work closely with Manufacturing, Engineering, Quality, and Supply Chain teams to understand reporting and data needs. - Provide training to 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 field. - 10+ years of experience in a reporting or BI leadership role within a semiconductor, electronics, or OSAT environment. - Good understanding of MES DB Schema. - Proficiency 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 experience. Key Skills & Competencies: - Advanced Data Modeling & Engineering. - MES/OEE/ERP Integration. - BI Tools (Power BI, Grafana, Tableau). - Data Warehouse & Cube Design. - Traceability & Compliance Reporting. - B2B/RosettaNet/EDI Data Exchange. - Big Data Analytics & Scalability. - Cross-functional Communication. - Continuous Improvement Mindset.,