SIOP Data Analyst

Position 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 strategically located near our customers.

Pay range for this position is $65 - $75k

Key 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.
• Collaborate and communicate with peers in multiple departments.
• Develop programs using advanced experience with MS Office Suite: Power Query, Pivot Tables, Macros, Visual Basics, etc.
• Capture, develop and analyze large amounts of data and implement error proofing measures.
• Ability to travel.

Required 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 with the ability to work in multiple ERP systems.
• WORK ENVIRONMENT: High energy and ability to prioritize and multitask in a fast paced and rapidly changing environment; resourcefulness and advanced problem-solving abilities required.
• Employment Type: FULL_TIME