Description

Supply Planning Analyst

Build your Career with an Industry Leader

Multi-Color Corporation and Fort Dearborn have merged and are now the world’s largest prime label and packaging supplier. Join the new MCC and you will have the opportunity to become part of an organization that has been committed to excellence and industry leadership for over 110 years.

This position has ownership of all supply planning analytics activities and is responsible for ensuring the supply planning process delivers data integrity as a key input to the stakeholders such as supply planning, finance, and operations.  He/she will focus on:

• Assisting with content creation to support the monthly Supply Review as part of the S&OP/IBP process including the presentation of results based on data analytics and path for continuous improvement leveraging in data science expertise.
• User data expert for Excel / Blue Yonder / JDA / BI / Power Query / VBA systems to deliver optimal modeling of the business and improve planner productivity by maximizing systems functionality.
• Developing and fine tuning of supply plan using data driven insights
• Developing and monitoring process metrics and reporting package to drive process performance, problem solving and improvement.
• Identifying quantified risks within the demand plan and supply plan in order to develop appropriate counter measures for resolution.

Responsibilities:

• Generate supply plan across the planning horizon by utilizing customer prior shipments, POS data, knowledge of business unit trends, press speeds, capacity and upcoming promotions to guide decision making process by the Supply Planners.
• Responsible for master data flows between ERP systems, data integrity management and process improvements.
• Execute and maintain capacity data, press performance data, crewing models to optimize planning capabilities (Run Time/Make Ready Time/Down Time/Job Size, etc.)
• Create and/or maintain statistical models for each item at each stocking location and for every customer within designated product lines to optimize supply plan.
• Manage and review KPI performance and reporting through the Demand/Supply Planning Organization
• Develop strategies for analysis. Build, collect, and transform data into information to draw conclusions, and to present and execute proposals supported by the analysis.
• Problem solves the highest causes of error each month by researching errors, determining root cause, and driving for improvement.
• Partner with IT to recommend, develop and enhance systems solutions aligned with business goals and company objectives within the Blue Yonder system.
• Document business processes and standard work, assist to develop system solutions and validate system designs through rigorous testing of solutions.
• Participates in special projects and performs other duties as assigned.

Qualifications:

• Bachelor’s Degree in Supply Chain Management, Engineering, Business Analytics, or related technical field
• 1-3 years of related experience in supply chain planning, management, and operations.
• Proficiency in systems and analytics:

• Advanced Excel (VLOOKUP, IF, SUMIFS, Pivot Tables, Graphing, etc.)
• Power Query
• VBA Macros
• VBA User Forms
• Microsoft Access
• Blue Yonder/JDA
• SQL or PostgreSQL (preferred, not required)

• Strong Analytical/Problem Solving/Presentation Skills/ Statistical Modeling required
• Ability to work in a high volume/fast paced environment
• Must be able to process large amounts of data (90k+ SKU’s), influence others and drive cross-functional alignment and be able to communicate at various levels within the Organization.
• Good communication (written, verbal and presentation) and organizational skills.
• Build strong, collaborative relationships with internal and external business partners.
• Strong results orientation and work ethic; Able to work independently.
• Ability to think and act strategically in the business while able to focus on day-to-day operational execution.
• Proficiency with Excel, Access, PowerPoint, and other MS office tools is essential.
• 25% travel required to Plants, Customers and/or partner locations.
• English proficiency or working level required.

MCC welcomes and encourages applications from people with disabilities. Accommodations are available on request for candidates taking part in all aspects of the selection process. MCC is an equal opportunity employer.

#MTYIND