Inventory Specialist, Excel Proficient

The Inventory Specialist, Item Maintenance, is primarily responsible for pricing validations on invoiced reports. This includes assessing product charges, freight, and taxes. Discrepancies are communicated back to suppliers with requests for credits. The credits received will be reconciled and tracked. The individual will communicate with manufacturers to request new items be added to our price list.  Special projects include data mining for usage, pricing, etc. Due to the nature of the work, only Intermediate to Advanced Excel users should apply. You will need to hit the ground running with pivot tables, lookups, and formulas.

Key Responsibilities:

1. Data Processing & Reporting:

• Gather data from various sources (databases, spreadsheets, vendors)
• Clean and process data for accuracy
• Audit invoice reporting for accuracy in product pricing, freight charges, and tax assessment.
• Send invoice variance summaries to vendors and request credits for pricing discrepancies
• Verify and document credit memos and forward to AdaptHealth staff
• Follow up via email/vendor meetings on pending credits until receipt.
• Maintain tracking for all credits requested and received. Provide reporting to upper management.
• Communicate with manufacturers to update new items for price list. 
• As requested by management, provide summary reports using invoicing data

2. Procurement support

• Provide backup support for locations looking to add new items to the ordering system. Requires research of product and coordination with manufactures/supplies, communication with field offices.
• Work with Tax team for tax exemptions

Competency, Skills, and Abilities:

• Excellent Excel skills for VLOOKUP, Pivot Tables, and other formulas are required
• Excellent verbal and written communication skills
• Ability to manage large amounts of data in Excel and maintain strong attention to detail
• Superb decision-making and problem-solving skills
• Ability to prioritize tasks and manage multiple projects
• Ability to adapt and be flexible in a rapidly changing environment, be patient, accountable, proactive, take initiative, and work effectively in a team
• Solid ability to learn new technologies and possess the technical aptitude required to understand flow of data through systems as well as system interaction
• Computer skills including knowledge of Microsoft Office applications

Qualifications:

• Education: High school diploma, Associate’s or Bachelor’s Degree preferred
• Technical Skills: Intermediate to Advanced Excel experience must be demonstrated prior to hire.
• Previous experience with medical supplies is a plus but not required.