Vendor Data Spec

Job Summary

Ensure vendor data and Medline data are in sync by overseeing and analyzing dozens of different data points/reports. Routinely involves judgement calls, exercising discretion, and problem-solving skills that stem from vendor and customer-identified discrepancies. Requires a thorough understanding of several areas of the business that consistently leads to making decisions that have material financial implications.

Job Description

Responsibilities:

• Execute item creation(s), subsequent maintenance, discontinuation(s), and reactivation(s). Coordinate vendor mergers, analysis of daily discrepancy report(s), and investigate vendor files/communications for needed changes. 
• Oversee acquisition and base cost pricing with a high attention to detail. Reconcile discrepancies that can hinder both vendor and customer relationships if not reconciled timely and/or communicated appropriately.
• Evaluate vendor adherence to distribution agreement(s), facilitate effective date negotiations when situations occur that may not be explicitly covered, and make formal recommendations to Vendor Relations on changes needed to avoid in the future.  

• Analyze divisional reports and system data to identify product surplus. Obtain authorization from vendor(s) to return and exercise judgment in handling restocking fee negotiations to minimize divisional losses. 
• Review portfolio analytics to submit process improvement recommendations to management for business impact. 
• Maintain shared mailboxes and respond to requests in a timely manner. 
• Submit assigned files and/or projects to management, vendor(s) and/or internal team(s) within provided timelines. 
• Establish and maintain a close working relationship with the following groups:  Vendor Relations, Vendor Representatives, Quality, Finance [A/P], Chargebacks, Contracts, Inventory Management and other appropriate personnel. 

Required Experience:

Education

• Bachelor’s degree or equivalent professional experience in a related field 

Work Experience

• Experience working in a fast-paced environment, analyzing large data sets, and adhering to competing deadlines without compromising accuracy/quality. Provide customer service to internal and external requestors and manage workloads that necessitate portfolio-specific analytics to occur for departmental success and process improvement(s). 
• Intermediate skill level in Microsoft Excel (ie: using SUM function, sort/filter, IF, VLOOKUP functions, Pivot tables).
• Basic skill level in Microsoft Word (ie:  formatting, inserting headers, outlines/bullets, page breaks, pictures and charts)
• Intermediate skill level in Microsoft Outlook (ie: creating folders, categories, utilizing calendar, coordinating meetings)

Preferred Qualifications:

• Bachelor’s degree. 

• Advanced time management skills to ensure daily work, discrepancies and/or projects are accomplished within given SLA’s.