Inventory Planning & Business Analytics Analyst

Olympus Corporation of the Americas•Bartlett, TN

16d•Onsite

About The Position

This position is responsible for the planning, purchasing, and analysis of repair parts inventory. The primary objective is to maintain optimal inventory levels to support current demand while minimizing back orders. Additionally, this role includes the responsibility of setting up and managing data analytics processes to consolidate, visualize, and report key inventory metrics using tools such as Power BI.

Requirements

Bachelor’s degree in Industrial Engineering, Business Analytics, Data Analytics, SCM, or related field.
Minimum of 3 years of service supply/demand planning experience OR a minimum of 5 years in inventory/material planning in a manufacturing environment.
Strong proficiency in Power BI, including data modeling and Power Query.
Experience with SQL for data extraction and transformation.
Strong Microsoft Excel skills (data management and manipulation).
Experience with Oracle Inventory Management.
Proficiency in Microsoft Office (Word and Excel at a high skill level).
Excellent analytical and organizational skills; detail-oriented.
Strong verbal and written communication skills.
Ability to work independently and as a team player with professionalism and integrity.

Nice To Haves

APICS/ CPIM certification preferred.

Responsibilities

Analyze min/max reorder points regularly. Monitor trends to ensure correct quantities, maintain optimum stock levels, and optimize pricing based on purchase quantities for locally purchased materials.
Create purchase requisitions daily for appropriate vendors through Oracle-MRP and convert requisitions to purchase orders. For locally sourced materials, prepare requisitions for the Buyer to place orders with appropriate lead times. Communicate with suppliers regarding order status, receipt errors, delivery information, item notes, and pricing issues.
Monitor open purchase orders against requested delivery dates to identify critical low-stock situations. Communicate daily/weekly on backorders to improve delivery and reduce delays. Analyze vendor performance trends and drive improvements.
Ensure organization and accuracy of material master information between MDM and Oracle systems for all new parts introduced into the product group. Maintain Oracle material master with up-to-date details on description, location, order point, lead time, obsolescence, and supplier sourcing.
Act as a liaison between suppliers, production managers, customer solutions, and warehouse management to communicate delivery dates, product delays, and urgent support needs. Develop and maintain strong relations with key stakeholders to ensure timely delivery and resolution of supply chain issues.
Coordinate smooth transitions from older product lines to new ones by depleting old stock through Excess & Obsolete reports. Continuously evaluate order necessity to minimize E&O risk. Quarterly review inventory over 180 days and its percentage of total stock.
Create return purchase orders for claim returns by obtaining RMAs and preparing return shipment documents.
Ensure compliance with company policies and industry regulations in all purchasing activities.
Support emergency parts replenishment needs during critical production downtimes or unexpected demand spikes. Coordinate with warehouse teams to manage inbound and outbound shipments, ensuring timely and accurate delivery.
Participate in continuous improvement projects to streamline inventory management processes and enhance efficiency.
Utilize data analytics tools to create dashboards and identify trends, predict demand, and improve decision-making in inventory planning.
Prepare and present performance reports to management, highlighting key metrics and improvement opportunities.
Design and manage dashboards and performance metrics (e.g., parts hit rate, forecast KPIs, OTIF).
Provide regular reporting and insights to leadership, including global repair volume and parts consumption data consolidation, highlighting trends, risks, and opportunities.
Support during implementation of global projects, such as the rollout of a demand planning tool, ensuring smooth adoption and integration across regions.
Perform all other related duties as assigned.