Inventory Analyst

Orion Group and our largest US client have an exciting contract opportunity for an Inventory Analyst in Waukegan, IL!! Our client is seeking experienced individuals to help support their US Distribution Manager. Don't pass on this amazing opportunity to join a market leading pharmaceutical company!

Inventory Analyst

$28 per hour with medical benefits

6 month initial contract with possibility for extensions

Daily Work Schedule Expectations
Monday - Friday 8am - 5pm (OT available)
Domestic Travel - quarterly
Onsite for Training
After training - Hybrid (3 days onsite)

Purpose:

The inventory analyst will work with the Distribution Manager, US to support day to day inventory and warehousing operations. The analyst will own the inventory reconciliation process between AbbVie and the 3pls in the US, drive continuous improvement initiatives to ensure efficiency and predictability, and further enhance the capability to project and optimize inventories across our key supply chains. Finally, the analyst will enable accurate inventory data availability for all key stakeholders and enable benchmarking between brands to drive best-in-class at all levels of the organization.

Daily responsibilities include:

• Support the US Distribution Manager with key performance indicators (KPI), invoicing, SAP reporting, 3PL system reporting, SOP review, Investigation Review and any other distribution related task as detailed below and as required.
• Maintain a cycle count matrix schedule, based on product ABC categorization.
• Ensure routine cycle counting process and schedule is followed by the 3PLs- i.e., counts are completed, documentation is received (perpetual inventory, screen shots, summaries, etc), reviewed and approved.
• All adjustments due to cycle count discrepancies are summarized for review and approval by Finance prior to making any adjustments.
• Track and trend all adjustments need to align the inventory.
• File all supportive matrix cycle count documentation for future review by auditors.
• Be present at 3PL for financial audit purposes and ensure all requested documentation is provided in a timely and thorough manner.
• Request and follow through on ad-hoc counts at 3PL.
• Review and file all other types of counting documentation from 3PLs (pick line audits, ad-hoc counts, etc.).
• Monitor and ensure accuracy of all customer inquiry investigations (OS/SS/Incorrect shipments).
• Run the daily inventory reconciliation report.
• Identify new discrepancies and follow up with internal stakeholders, 3PL or Global Information Technology teams to get timely and accurate resolution. Track and trend inventory reconciliation issues.
• Monitor electronic data interchange message (IDOC) failures between internal and 3PL inventory management systems and process these message failures as approved but Global Information Technology.
• Support financial audits by requesting shipping documentation and running reports in SAP.
• Complete month-end analysis of inventory KPIs, as well as order accuracy and returns.
• Support Order Management team for order cancellations, batch determination, completing transactions in SAP for medical devices with asset values, etc.
• Provide monthly 3PL invoicing reconciliation reports related to pallet storage, outbound deliveries, etc.
• Created manual proforma invoices for passive shipper return when required.
• Review destruction requests for accuracy and prepare destruction lists to send for financial approval.
• Track all destruction orders to ensure process is followed and all supportive documentation is received and filed according to the SOPs. Approve destruction invoices.
• Analyze, review, log, request credits, process and approve all 3PL invoices.
• Drive the short dated/excess inventory review process to mitigate any risk on obsolescence and/or collaborate with finance to create reserves.

Qualifications one needs to be successful in this role:

• Bachelor’s degree in quantitative/analytical related discipline (Engineering, Supply Chain, Logistics, Business, Economics or Information Systems)
• Knowledge of SAP (In the form of distribution, procurement, or inventory management SAP transactions).
• Strong cross functional collaboration with supply chain users is essential
• Excellent written and oral English communication skills are required
• Excellent helicopter view as well as deep dive analytical skills are required
• Minimum 3 years’ experience in Supply Chain with Inventory Management, Logistics and Warehousing
• Intermediate Excel knowledge (pivots/look ups)
• Ability to travel domestically

Job Types: Contract, Temporary

Pay: From $28.00 per hour

Benefits:

• 401(k)
• Dental insurance
• Health insurance
• Vision insurance

Schedule:

• 8 hour shift
• Day shift
• Monday to Friday

Education:

• Bachelor's (Required)

Experience:

• Supply Chain with Inventory Management, Logistics: 3 years (Required)
• SAP: 3 years (Required)

Work Location: In person