Strategic Demand Analyst for Manufacturing Growth

Mayville Engineering Company, Inc.; Byron Township (MI); On-site; USD 65,000 - 90,000; Full time

Job summary

Mayville Engineering Company, Inc. is seeking a Demand Analyst at our Byron Center, Michigan location to analyze sales data, forecast demand, and support capacity and materials planning across sites.

The ideal candidate will have strong data analysis skills, experience with ERP systems, and advanced MS Excel tools such as Power Query, Pivot Tables, Macros and VBA; travel may be required to coordinate with multiple departments.

Qualifications

• Excellent data analysis skills and statistical forecasting background.
• Ability to drive solutions from data and communicate insights.
• Strong written and oral communication across departments.
• Advanced math and analytics experience.
• Experience with ERP systems.

Responsibilities

• Compile actual sales and forecast data to support decisions around sales, capacity, and material planning.
• Prepare capacity analyses for capital expenditure and production readiness.
• Prepare material forecast and inventory plan.
• Develop and pilot new metrics for SIOP and variance reporting.
• Collaborate with peers across multiple departments.
• Develop programs using MS Office Suite: Power Query, Pivot Tables, Macros, VBA.
• Capture, develop and analyze large data sets; ensure error-proofing.
• Travel as needed.

Skills

Data Analysis

Forecasting

MS Office

Power Query

Pivot Tables

Macros

VBA

ERP Systems

Communication Skills

Data Visualization

Job description

Mayville Engineering Company, Inc. is seeking a Demand Analyst at our Byron Center, Michigan location to analyze sales data, forecast demand, and support capacity and materials planning across sites.

The ideal candidate will have strong data analysis skills, experience with ERP systems, and advanced MS Excel tools such as Power Query, Pivot Tables, Macros and VBA; travel may be required to coordinate with multiple departments.