SIOP Analyst

Azelis Americas

Job Description

Summary:

The SIOP Analyst will have overall responsibility for forecast adherence, accuracy, and optimization activities.  Using an analytical approach, this position will develop, manage, and optimize processes around SIOP functions and will work primarily with the Supply Chain and Commercial teams to establish equilibrium between product supply and demand across multiple product lines and warehouses.

Essential Duties and Responsibilities include the following. Other duties may be assigned.

• Lead monthly forecasting efforts between Supply Chain, Sales, and Principal Development teams.
• Receive, analyze, and enter all customer submitted forecasts into demand planning software.
• Prepare monthly SIOP data files and support monthly meetings with cross functional teams.
• Compare statistical forecast data with projected sales trends to highlight and correct imbalances in inventory positions.
• Meet regularly with Inventory Managers to drive inventory optimization.
• Manage data integrity related to system generated forecasts and customer submitted forecasts.
• Participate in forecast improvement initiatives with Principal representatives.
• Assist in managing inventories in impaired or expired status with emphasis in creating channels for movement.
• Monitor department KPIs related to days inventory and impaired/expired goods to drive metric results and meet operating objectives.
• Lead recertification efforts for product that is expired or near expiration.
• Cross train to provide back-up support to Inventory Managers and Supply Chain Assistants.

Other Responsibilities include (but not limited to)

• Understand and adhere to/follow the department procedures and policies.
• Adhere to and support the principles of Responsible Distribution™.
• Assume other activities and responsibilities from time to time as directed.
• Additional responsibilities may be assigned as needed.

Competencies:                                             

To perform the job successfully, an individual should demonstrate the following competencies:

Attention to Detail - Thoroughness in accomplishing a task through concern for all the areas involved, no matter how small. Monitors and checks work or information and plans and organizes time and resources efficiently.

Problem Solving - Identifies and resolves problems in a timely manner; Gathers and analyzes information skillfully; Develops alternative solutions; Works well in group problem solving situations; Uses reason even when dealing with emotional topics.

Oral Communication - Speaks clearly and persuasively in positive or negative situations; Listens and gets clarification; Demonstrates group presentation skills and a good command presence; Participates in meetings.

Written Communication - Writes clearly and informatively; Presents numerical data effectively.

Initiative - Does more than is required or expected in the job; does things that no one has requested that will improve or enhance products and services, avoid problems, or develop entrepreneurial opportunities. Plans ahead for upcoming problems or opportunities and takes appropriate action.

Teamwork - Balances team and individual responsibilities; Exhibits objectivity and openness to others' views; Gives and welcomes feedback; Contributes to building a positive team spirit; Puts success of team above own interests; Able to build morale and group commitments to goals and objectives; Supports everyone.

Ethics - Treats people with respect; Keeps commitments; Inspires the trust of others; Works with integrity and ethically.

Adaptability - Changes behavioral style or method of approach when necessary to achieve a goal; adjusts style as appropriate to the needs of the situation. Responds to change with a positive attitude and a willingness to learn new ways to accomplish work activities and objectives.

Professionalism - Thinks carefully about the likely effects on others of one’s words, actions, appearance, and mode of behavior. Selects the words or actions most likely to have the desired effect on the individual or group in question.

Qualifications:

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.

Education and Experience:                                              

• Bachelor’s degree in business, Operations, Supply Chain Management or another related field preferred.
• APICS CPIM or CSCP certificate preferred.
• Previous chemical Industry Knowledge helpful.
• 5 years’ experience in inventory management or procurement.
• Skilled in Microsoft Office applications with emphasis in Excel using pivot tables, VLOOKUP functions and macros.
• Ability to build and maintain custom reports.  PowerBI, SQL, Python and other analytical/coding skills are recommended.
• Must be able to multitask.
• Must be organized.
• Must have excellent time management skills.
• Ability to prioritize work, determining what is critical and needs to be completed.
• Self-motivated, honest, dependable and a high-level of integrity.
• Good interpersonal skills.
• Detail-oriented, well organized and strong analytical and math skills.
• Ability to read, analyze, and interpret general business correspondence.
• Effectively present information as necessary in written and spoken form.
• Able to treat others with respect and dignity, maintain confidentiality on sensitive issues.
• Able to effectively work in a team-based and quality driven environment, where all team members hold themselves mutually accountable.

Reasoning Ability:                                        

Ability to define problems, collect data, establish facts, and draw valid conclusions. Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and concrete variables.

Computer Skills:                                          

To perform this job successfully, an individual should have knowledge of Internet software; Inventory software; Order processing systems; Project Management software; Microsoft Office and Power Tool software.

Physical Demands:

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Work Environment:

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job.