Inventory Control Analyst I

AI overview

Utilize SQL and advanced Excel techniques to analyze inventory data and maintain accuracy through daily cycle counts and audits across multiple warehouses.

Position Summary:

Responsible for daily cycle counting and audit activities in multiple warehouses.  Activities include inventory counting, count auditing, variance identification, reconciliation, root cause analysis, and adjustment data entry into ERP system. 

Position will assist inventory control management to develop, implement, and maintain a robust cycle count program to ensure accuracy and integrity of inventory record during internal and external observation. 

Position will work closely with other departments to coordinate daily cycle count activities.

Position will provide quick response to supply chain, quality, and production teams’ to resolve variances.  Takes daily proactive measures to ensure a high degree of inventory accuracy.  When necessary, will monitor internal MES and ERP queues, will identify and document queue errors, will analyze errors for root cause, and will resolve errors with appropriate action.

Position provides management an analysis of inventory data for use in decision making and efficiency improvement initiatives. Uses SSMS (SQL) daily to query and update local databases. Employs Excel tools using formulas, VLOOKUPs, Data Analysis, Pivot tables, and PowerPivot to collect, analyze, and organize data.  Will collect, organize, and document process improvement data using cloud reporting and MS office software to include Word, Visio, PowerPoint, and Project.

Primary Duties: 

  • Perform all work in compliance with company policy and within the guidelines of BioFire Diagnostics Quality System.
  • Understand enterprise systems used by BioFire Diagnostics.
  • Assist manager to validate and maintain cycle count schedule.
  • Perform cycle count activities to established work instruction.
  • Verify count accuracy and variance reconciliation to WID standards prior to posting adjustment to inventory.
  • Adhere to published authorization requirements for adjustments made to inventory.
  • Record and maintain accurate log of count events.
  • Provide timely feedback to department management regarding observed practices in other departments that are deemed to cause inaccuracies in the integrity of the inventory record (standard and non-standard transactions, shelf life expiration, material mishandling, improper consumption against a BOM, etc.).
  • Participate in quarterly physical count observation and material preparation activities associated with the observation.
  • Writes queries or reports, aggregates inventory data, and performs statistical analysis based on requests from manufacturing, materials management, quality, project teams, or senior leadership
  • Integrates data from multiple data sources or functional areas, ensures data accuracy and integrity, and updates data as needed

Supplemental Data: 

  • Occasional work on weekend days or after regular work hours may be required.
  • “In Town” travel between local warehouses required.
  • Shift begins in the early morning (5:00am - 3:00pm) M-T.  Off every other Friday.

Qualifications, Preferred Education, Training & Experience: 

  • High school diploma, GED or equivalent required
    • College courses in Business, Operations, Supply Chain, Inventory Control, Accounting, Business Information Systems, and Analytics preferred.
  • 1+ year of applicable experience required in warehouse, inventory control, analytics or lean implementation
  • Excellent problem solving, analytical thinking, and communication skills required. Presentation skills preferred. 
  • Must be able to read and comprehend documented inventory control procedures. 
  • Must have SQL skills or an aptitude to learning SQL. Must be skilled in MS Excel. Must be familiar with excel tasks such as the use of formulas, VLOOKUPs, Data Analysis, Pivot tables and Power Pivot.  

Knowledge, Skills, and Abilities:

  • Consistently uphold and reflect the core ethical principles and values that bioMerieux promotes. 
  • Effective verbal communication skills.
  • Build and maintain positive, productive interactions with colleagues.
  • Thrive in a fast-paced environment by managing tasks, multitasking, and adapting quickly to maintain productivity.
  • Experience using MS office software to include Word, Visio, PowerPoint, and Project is preferred. 
  • Experience using SAP, Sales Force, DOMO, and JIRA preferred. 
  • Knowledge of lean implementation, process improvement, and Six Sigma preferred, not required. 
  • Knowledge of statistical programming languages in Python or R a plus.

Working Conditions and Physical Requirements: 

  • Ability to remain in stationary position, either sitting or standing, for prolonged periods.
  • Ability to ascend/descend stairs, ladders, ramps, and the like. 
  • Ability to wear PPE correctly most of the day.
  • Ability to adjust or move objects up to 50 lbs in all directions.
  • Ability to travel between buildings at least 10%
  • Must have a valid driver's license as travel between stock locations is required. 

 

The pay for this role is between $19.00 to $26.40 an hour. This role is eligible to receive a variable annual bonus based on company, team, and individual performance per bioMerieux’s bonus program. This range may differ from ranges offered for similar positions elsewhere in the country given differences in cost of living. Actual compensation within this range is determined based on the successful candidate’s experience and will be presented in writing at the time of the offer. 
In addition, bioMérieux offers a competitive Total Rewards package that may include: 
·        A choice of medical (including prescription), dental, and vision plans providing nationwide coverage and telemedicine options 
·        Company-Provided Life and Accidental Death Insurance 
·        Short and Long-Term Disability Insurance 
·        Retirement Plan including a generous non-discretionary employer contribution and employer match. 
·        Adoption Assistance 
·        Wellness Programs 
·        Employee Assistance Program 
·        Commuter Benefits 
·        Various voluntary benefit offerings 
·        Discount programs 
·        Parental leaves 

Perks & Benefits Extracted with AI

  • Health Insurance: A choice of medical (including prescription), dental, and vision plans providing nationwide coverage and telemedicine options
  • Other Benefit: Parental leaves

bioMérieux is a world leader in the field of in vitro diagnostics, providing diagnostic solutions to determine the source of disease and contamination. With a presence in over 150 countries, the company's products are used to improve patient health and...

View all jobs
Salary
$19 – $26 per hour
Ace your job interview

Understand the required skills and qualifications, anticipate the questions you may be asked, and study well-prepared answers using our sample responses.

Analyst Q&A's
Report this job
Apply for this job