Olympus Corporation of the Americas

Inventory Planning, Business Analytics Analyst

Olympus Corporation of the Americas

full-time

Posted on:

Location Type: Office

Location: Bartlett • Tennessee • 🇺🇸 United States

Visit company website
✨ AI Apply
Apply

Salary

💰 $52,943 - $71,474 per year

Job Level

Mid-LevelSenior

Tech Stack

OracleSQL

About the role

  • 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.

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.
  • APICS/ CPIM certification preferred.
Benefits
  • Competitive salaries, annual bonus and 401(k)* with company match
  • Comprehensive medical, dental, vision coverage effective on start date
  • 24/7 Employee Assistance Program
  • Free live and on-demand Wellbeing Programs
  • Generous Paid Vacation and Sick Time
  • Paid Parental Leave and Adoption Assistance*
  • 12 Paid Holidays
  • On-Site Child Daycare, Café, Fitness Center**

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
data analyticsinventory managementsupply chain managementdata modelingdata extractiondata transformationMicrosoft ExcelOracle Inventory ManagementPower BISQL
Soft skills
analytical skillsorganizational skillsdetail-orientedverbal communicationwritten communicationteam playerprofessionalismintegrity
Certifications
Bachelor’s degreeAPICS certificationCPIM certification