MEC is seeking to hire a SIOP Data Analyst to support business decisions around sales, capacity, and material planning by compiling actual sales and forecast data, preparing capacity analyses, and developing new metrics for SIOP and Variance reporting.
Requirements
- 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.
- Excellent data analysis skills
- background knowledge of statistical forecasting software
- Analytics to process data and factor all relevant demand details
- Statistical data experience preferred
- Strong computer acumen requires ability to work in multiple ERP systems.
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
- 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.
Other
- Involve collaboration and communication with peers in multiple departments.
- Ability to travel
- Strong written and oral communication skills; required to communicate effectively with various levels of staff and departments.
- Highly detail oriented.
- High energy and able to prioritize and multitask in fast paced and rapidly changing environment; resourcefulness and advanced problem-solving abilities required.
