ERP System Analyst

Job Description

Job Description

Description :

The ERP System Data Analyst will be responsible for developing and maintaining trend data from Global Shop Solutions ERP system to monitor shop floor labor efficiency, work order performance, and production trends. This role will transform raw time and job data into actionable insights that help improve scheduling accuracy, labor utilization, and throughput across all production departments.

The ideal candidate combines strong data analysis skills with hands-on understanding of manufacturing operations and familiarity with Global Shop's reporting tools, job costing modules, and shop floor time tracking.

Key Responsibilities

• Extract, analyze, and validate labor and work order data from Global Shop ERP system to monitor job performance and production trends.
• Develop and maintain standardized dashboards and reports in tools such as Power BI or Excel, integrating Global Shop data through SQL queries or report exports.
• Track and trend actual vs. estimated hours, identifying variances by job type, department, or operator.
• Build models to analyze labor efficiency, utilization, setup vs. run time, and idle hours.
• Support production leadership in identifying bottlenecks, capacity issues, and process inefficiencies based on time-tracking data.
• Create weekly and monthly performance summaries that highlight key metrics such as :

Work order completion rate and timeliness

Requirements :

Preferred Skills

Performance Metrics

Work Environment