Product Data Analyst
Celestica
full-time
Posted on:
Location Type: Office
Location: Richardson • Texas • 🇺🇸 United States
Visit company websiteJob Level
JuniorMid-Level
Tech Stack
ERPSQLTableau
About the role
- Develop and maintain analytical models to track First Pass Yield (FPY), defect rates, and process capability metrics.
- Conduct Root Cause Analysis (RCA) using diagnostic analytics to pinpoint process or component failures in complex assemblies.
- Design and build real-time dashboards (e.g., OEE, Downtime) to monitor the performance of key production equipment and manufacturing execution systems (MES).
- Analyze manufacturing cycle times and resource utilization data to identify and eliminate bottlenecks and waste.
- Analyze post-launch data, including field failures, warranty claims, and repair/return data, to provide critical feedback to the New Product Introduction (NPI) and Design teams.
- Collaborate with engineering to track the performance of critical components and predict potential failure points.
- Write efficient SQL queries to extract and integrate data from various manufacturing systems (MES, ERP, QMS).
- Produce standardized and ad-hoc reports to inform executive decision-making on cost reduction, quality improvement, and capacity planning.
Requirements
- 2 to 4 years of direct experience as a Data Analyst or Business Intelligence Analyst within a high-volume manufacturing, electronics, or industrial environment.
- Expert-level proficiency in SQL for extracting and joining data from complex operational databases.
- Proven experience with data visualization tools (e.g., Tableau, Power BI, Looker) to present manufacturing KPIs.
- Experience working with MES (Manufacturing Execution System), ERP, or QMS data structures is highly desirable.
- Strong foundational knowledge of statistics and statistical process control (SPC).
- Demonstrated ability to conduct diagnostic and predictive analytics related to production processes and equipment performance.
- Bachelor's degree in a quantitative field such as Industrial Engineering, Data Science, Electrical Engineering, or a related discipline.
- Detail-oriented problem-solver with a passion for continuous process improvement and the ability to clearly communicate technical findings to production managers and engineers.
Benefits
- Health insurance
- 401(k) matching
- Paid time off
- Flexible work hours
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQLdata visualizationdiagnostic analyticspredictive analyticsstatistical process controldata analysisanalytical modelingreportingprocess capability metricsRoot Cause Analysis
Soft skills
detail-orientedproblem-solvingcommunicationcollaborationcontinuous process improvement