Details

Employee Type
Full-Time Regular
Location
Rochester Hills MI

Job Description

JOB TITLE: Inventory Analyst

PURPOSE AND DESCRIPTION

To provide technical, business and planning in the areas of pricing, inventory management and efficiency improvements.

ESSENTIAL FUNCTIONS

Product Data Management Support

  1. Upload new company and commercial items into the Oracle Master Items.
  2. Maintain transplant robot data into Oracle (RDIs).
  3. Apply import/export codes (HTSUS/ECCN) to new and existing part numbers.
  4. Setup and adjust customer pricing for standard and custom items and adjust customer pricelists.
  5. Review service reports with appropriate executing groups to manage obsolete components and replacement inventory.
  6. Work with company Import and Export group to provide import/export codes for material on international web shippers and for Importer Security Filings (ISF).
  7. Perform ad-hoc reporting and analysis for Customer Service management as required.
  8. Maintain and update various item fields in the Oracle Master Items as required.
  9. Backup other PDM functions as required including: processing ECO and BOM uploads, processing and logging transplant robot data and Customer Service part forecasting and reporting.
  10. Provide technical assistance to other company groups in regards to item identification, item revision, part availability, alternative items and item and robot BOMs.
  11. Track part and robot updates using the Item Master (Parts) and Item Instance (Robots)

OTHER FUNCTIONS

  1. Other duties as assigned to support our business

MINIMUM REQUIREMENTS

SKILLS/KNOWLEDGE

  1. Strong problem solving skills
  2. Familiar with concepts of part numbering, revision control and BOM structures
  3. Either through education and/or work experience have developed and demonstrated an ability to identify and define problems or needs, define plans to address those problems or needs, and successfully manage the execution of the developed plan.
  4. Proficient with MS Excel (knowledge of pivot tables, basic formulas, macros)
  5. Knowledge of Microsoft 365 and Teams
  6. Knowledge and application of ISO standards.
  7. Demonstrated ability to plan, organize and execute multiple tasks concurrently.
  8. Strong written and oral communication skills
  9. Successfully working in teams
  10. Personal initiative to effectively manage himself/herself

EXPERIENCE/EDUCATION

  1. Associate degree or equivalent work experience, BA/BA preferred.
  2. Minimum two years of experience in clerical or office coordination positions.
  3. Minimum 3 years of experience in administrative support for robotic automation or similar applications.
  4. Courses in HTSUS and ECCN classification or 1-2 years corporate experience a plus.
  5. Experience with SQL report writing a plus.
  6. Familiarity in statistics, forecasting and forecasting methods a plus.
  7. Knowledge of working within the Orale ERP system a plus

PHYSICAL EFFORT AND DEXTERITY

  1. Position involves desk work most of the time.

VISUAL ACUITY, HEARING, SPEAKING

  1. Good visual acuity, hearing and speaking is required.
  2. Must be able to give oral presentations to both small informal groups as well as large formal groups of people.

ENVIRONMENT AND SCHEDULING

  1. General office environment
  2. Willing to work occasional overtime when required to meet special deadlines in response to customer requirements.
  1. The job is high paced and does involve a certain amount of stress due to the workload, changing priorities and quick turnaround to meet other’s due dates.
  2. Reliable, consistent attendance required.

CORE TRAINING REQUIREMENTS:

The following training is required to enable job holders to perform the essential functions of the job.

  1. Employee Orientation
  2. Electronic Mail and PC Skills
  3. Safety Training
  4. Hazard Communication Training
  5. New Hire Quality/ESP Training
  6. Cyber Security Training

RECOMMENDED TRAINING:

  1. Personal Improvements (Target of 3/year)
    1. Company Product Training Classes
    2. Microsoft Classes– What classes? Office products?
    3. Vitalist Learning (Learn Now App)
    4. LinkedIn Learning Classes