Vendor Data Specialist at Medline Industries, LP — Northfield, IL

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.

Requirements

Education

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

Relevant 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).

Skills

• 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).

Preferred Requirements:

• 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

$23.25 - $33.75 Hourly