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