Production Data Analyst - ECT

ation and continuous improvement initiatives. This role provides strong foundational experience for future careers in operations, industrial engineering, manufacturing analytics, or planning.

Job Description

Roles and Responsibilities

• Collect and consolidate production data from timesheets, router files, and shop-floor inputs.

• Validate accuracy (missing punches, incorrect operation IDs, duration errors) and follow up on corrections.

• Prepare daily/weekly/monthly KPI reports: utilization, operation attainment, planned vs actual hours, overtime, rework.

• Build and maintain dashboards using Excel (Pivot Tables, Power Query, slicers/charts).

• Support standardization of reporting templates and master data (Operation IDs, planned hours).

Required Qualifications

• Bachelor's degree in industrial, Mechanical, or Electrical Engineering, or a related technical field from an accredited university.

• 0 to 1 year of experience with exposure to operations, manufacturing systems, statistics, or data analysis.

• Strong proficiency in Microsoft Excel.

Desired Characteristics

• Strong proficiency in Microsoft Excel, including:

  • Pivot Tables and Pivot Charts
  • Logical and statistical formulas (e.g., VLOOKUP/XLOOKUP, SUMIFS, COUNTIFS)
  • Data cleaning, structuring, and validation techniques

• Basic understanding of manufacturing or operational data, such as labor hours, routings, production tracking, and planned vs actual performance

• Good verbal and written communication skills, with the ability to clearly present data, trends.

• Ability to work closely with production, planning, and engineering teams to understand data sources and validate information.

• Willingness to ask questions, follow up on data gaps, and ensure reporting accuracy.

• Interest in skid assembly and manufacturing.

• Basic understanding of mechanical, piping, electrical, or integrated systems.

• Awareness of manufacturing and assembly processes (workstations, routing, operation steps).

• Basic knowledge of production KPIs such as labor utilization and planned vs actual hours.

• Willingness to spend time on the shop floor to understand assembly flow and data sources.

• Ability to learn and apply Lean and daily management concepts.

• Strong attention to detail and focus on data accuracy.

• Interest in developing skills in dashboards and data analysis.

• Good communication skills and confidence to follow up with teams.

• Proactive and hands-on learning mindset.

Additional Information

Relocation Assistance Provided: No