Reporting Leader (Big Data / MES)

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 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.

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 Schema

Proficient 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