Vendor Data Spec

Medline Industries, LP•Northfield, IL

1d•$23 - $34

About The Position

Ensure vendor data and Medline data are in sync by overseeing and analyzing dozens of different data points/reports. This role routinely involves judgement calls, exercising discretion, and problem-solving skills that stem from vendor and customer-identified discrepancies. It requires a thorough understanding of several areas of the business, consistently leading to decisions with material financial implications. The position involves executing item creation, subsequent maintenance, discontinuation, and reactivation. It also includes coordinating vendor mergers, analyzing daily discrepancy reports, and investigating vendor files/communications for necessary changes. The role oversees acquisition and base cost pricing with high attention to detail, reconciling discrepancies that could harm vendor and customer relationships if not handled timely or communicated appropriately. It evaluates vendor adherence to distribution agreements, facilitates effective date negotiations for situations not explicitly covered, and makes formal recommendations to Vendor Relations for future improvements. The role also analyzes divisional reports and system data to identify product surplus, obtains authorization from vendors for returns, and exercises judgment in negotiating restocking fees to minimize divisional losses. Additionally, it reviews portfolio analytics to submit process improvement recommendations to management for business impact, maintains shared mailboxes, and responds to requests promptly. The individual will submit assigned files and projects to management, vendors, and internal teams within provided timelines and establish and maintain close working relationships with various internal groups including Vendor Relations, Vendor Representatives, Quality, Finance [A/P], Chargebacks, Contracts, and Inventory Management.

Requirements

Bachelor’s degree or equivalent professional experience in a related field
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 (i.e. VLOOKUP, Pivot Tables, IF Statements, SUM function and sort/filter).
Intermediate skill level in Microsoft Outlook (i.e. creating folders, utilizing calendar/reminders, and coordinating meetings).

Nice To Haves

Advanced time management skills to ensure daily work, discrepancies and/or projects are accomplished within given SLA’s.
Experience building and maintaining relationships within and between teams/vendors.
Advanced skill level in Microsoft Excel (i.e. macros and advanced formulas).
Exposure/experience with SAP and/or Zendesk

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.