SIOP Data Analyst

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 SIOP Data Analyst at our Byron Center, Michigan location. The role focuses on analyzing sales and forecast data to guide capacity and material planning, and developing metrics for SIOP and variance reporting.

The ideal candidate will have strong data analysis skills, experience with statistical forecasting, and proficiency in MS Office (Power Query, Pivot Tables, Macros, Visual Basic). Some travel may be required.

Qualifications

• Strong data analysis skills and ability to drive solutions from data.

Responsibilities

• Compile actual sales and forecast data to support business decisions around sales, capacity, and material planning.
• Prepare capacity analyses to support decisions around capital expenditure and production readiness planning across sites
• Prepare material forecast and inventory plan
• Develop and Pilot new metrics for SIOP and Variance reporting for SIOP
• Involve collaboration and communication with peers in multiple departments.
• Develop programs using, advance experience with MS Office Suite: Power Query, Pivot Tables, Macros, Visual Basic etc.
• Ability to capture, develop and analyze large amounts of data and error proofing work.
• Ability to travel

Skills

Data analysis

Statistical forecasting

MS Office

ERP systems

Communication

Tools

Power Query

Pivot Tables

Macros

Visual Basic

Job description

Overview

Our growing company is seeking to hire a SIOP Data Analyst located at our Byron Center, Michigan location.

Founded in 1945, MEC is a manufacturer that provides a broad range of Metal Fabrication, Tube Bending, Machining, Welding, Coating, Prototyping, and Value-Added Assembly services to a variety of markets including Commercial Vehicle, Power Sports & Recreational Vehicles, Agriculture, Construction & Forestry, Military, Mining, Automotive, and Power Generation. We continue to have an aggressive growth plan, operating 24 manufacturing facilities which are strategically located near our customers.

Responsibilities

• Compile actual sales and forecast data to support business decisions around sales, capacity, and material planning.
• Prepare capacity analyses to support decisions around capital expenditure and production readiness planning across sites
• Prepare material forecast and inventory plan
• Develop and Pilot new metrics for SIOP and Variance reporting for SIOP
• Involve collaboration and communication with peers in multiple departments.
• Develop programs using, advance experience with MS Office Suite: Power Query, Pivot Tables, Macros, Visual Basics etc.
• Ability to capture, develop and analyze large amounts of data and error proofing work.
• Ability to travel

Qualifications

EDUCATION and/or EXPERIENCE

Excellent data analysis skills, ideally including background knowledge of statistical forecasting software with a desire to understand the data to drive solutions.

COMMUNICATION/LANGUAGE SKILLS

Strong written and oral communication skills; required to communicate effectively with various levels of staff and departments.

MATHEMATICAL/ANALYTICAL SKILLS

Advanced math skills to perform calculations; Analytics to process data and factor all relevant demand details; Statistical data experience preferred. Highly detail oriented.

COMPUTER SKILLS

Strong computer acumen requires ability to work in multiple ERP systems.

WORK ENVIRONMENT

High energy and able to prioritize and multitask in fast paced and rapidly changing environment; resourcefulness and advanced problem-solving abilities required.