Vendor Data Specialist

Medline; Northfield Township (IL); Hybrid; USD 32,000 - 46,000; Full time

Job summary

Medline Northfield, IL is seeking a Vendor Data Specialist to ensure vendor data and Medline data stay in sync by analyzing dozens of data points and reports. The role requires judgement, discretion, and problem-solving with material financial implications.

The position is hybrid in Northfield, Illinois and involves item creation, pricing analysis, discrepancy resolution, and close collaboration with Vendor Relations, Quality, Finance, Contracts, and Inventory teams to drive improvements and

Qualifications

• Bachelor’s degree or equivalent professional experience.
• Experience analyzing large data sets under tight deadlines.
• Proficient with Excel (VLOOKUP, PivotTables) and Outlook.
• Strong communication and problem-solving skills.

Responsibilities

• Execute item creation, maintenance, discontinuation, and reactivation.
• Coordinate vendor mergers and analyze daily discrepancy reports.
• Reconcile pricing and vendor/SLA adherence; negotiate restocking fees when needed.
• Review portfolio analytics and propose improvements to management.
• Maintain shared mailboxes and respond to requests in a timely manner.
• Collaborate with Vendor Relations, Quality, Finance (A/P), Contracts, Inventory Management.

Skills

Advanced Excel

Excel macros

Data analysis

Vendor relations

Time management

Education

Bachelor’s degree

Tools

SAP

Zendesk

Microsoft Outlook

Job description

## Vendor Data SpecialistApply: Hybrid: Northfield, Illinois: Full time: Posted Today: R2618142**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****MAJOR 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. **MINIMUM JOB REQUIREMENTS:****Education:*** Bachelor’s degree or equivalent professional experience in a related field**Certification / Licensure:*** None**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).**Knowledge / Skills / Abilities:*** Intermediate skill level in Microsoft Excel (i.e. VLOOKUP, Pivot Tables, IF Statements, SUM function and sort/filter).* Basic skill level in Microsoft Word (i.e. formatting, inserting headers, outlines/bullets, page breaks, pictures and charts).* Intermediate skill level in Microsoft Outlook (i.e. creating folders, categories, utilizing calendar, and coordinating meetings). **PREFERRED JOB REQUIREMENTS:****Education:*** Bachelor’s degree.**Certification / Licensure:*** None**Work Experience:*** None**Knowledge / Skills / Abilities:*** 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 ZendeskMedline Industries, LP, and its subsidiaries, offer a competitive total rewards package, continuing education & training, and tremendous potential with a growing worldwide organization.The anticipated salary range for this position:$23.25 - $33.75 HourlyThe actual salary will vary based on applicant’s location, education, experience, skills, and abilities. Medline will not pay less than the applicable minimum wage or salary threshold.