Excel Data Entry Specialist

DF Supply; Twinsburg (OH); On-site; USD 36,000 - 52,000; Full time

Job summary

DF Supply in Twinsburg, OH seeks an Excel Data Entry Specialist to maintain product costs and retail pricing. You will manage large data sets, record vendor changes, and prepare CSV files for price updates. The role requires advanced Excel, data management, and strong vendor communication.

This in-office position focuses on accuracy and timely updates. You will archive price books, align products with vendor catalogs, and ensure pricing reflects discounts and surcharges as directed by purchasing

Qualifications

• Advanced Excel skills required.
• Ability to implement conditional formatting and identify duplicates.
• Proficient with table filtering and sorting.
• Knowledge of formulas like XLOOKUP, VLOOKUP, ROUNDUP, IF, SUBSTITUTE, CONCAT, TEXTSPLIT.
• Strong math skills to calculate discounts and markups in Excel.
• Excellent problem-solving and numerical abilities.
• Detail-oriented with strong data accuracy.
• Professional communication with vendors via email and phone.
• Strong follow-through to resolve discrepancies.

Responsibilities

• Record vendor cost and status changes and archive price books.
• Organize active products by vendor in Excel and match to vendor catalog.
• Record cost, discounts, surcharges, and apply to determine cost and retail price.
• Compute markup percentages and apply to costs to derive retail prices.
• Create a secondary CSV with part numbers, costs, and retail prices and upload to websites.
• Identify new/discontinued products and confirm status with vendors and inform Content Dept.
• Resolve discrepancies between Purchase Orders and vendor Order Acknowledgments; update records.

Skills

Advanced Excel

Conditional formatting

Table filtering/sorting

XLOOKUP/VLOOKUP

ROUNDUP/IF/CONCAT/TEXTSPLIT

Discounts/markup calculations

Problem solving

Attention to detail

Vendor communication

Issue tracking

Data management

Tools

Excel

Job description

Excel Data Entry Specialist

We are looking for an Excel-proficient, detail-oriented data entry specialist to keep our product, vendor cost, and retail pricing information accurate and up to date. The ideal candidate has experience working with large data sets and is highly organized. As a member of our Purchasing team, you will record, prepare, and update vendor product cost and status changes.

This is an in-office position, we do not offer remote.

Day-to-Day/Key Responsibilities:

You will record vendor notifications of cost and status changes and archive price books.

You will use Excel to do the following:

• Organize all active products in our system by vendor.
• Match the products to the products listed within the vendor product catalog.
• Record each product's cost as established by the vendor.
• Record the discount rates and any applicable surcharges established by the vendor.
• Apply the discount rate and surcharges to determine our cost.
• Record markup percentages established by the Sales and Purchasing Manager.
• Apply the markup percentage to the cost to determine our retail price.

You will create a secondary CSV file with the part number, calculated cost, and calculated retail price, then upload it to the appropriate website(s) to update product cost and price.

You will identify new and discontinued products, then confirm the status with the vendor and submit an Excel file to the Content Department.

You will identify and resolve discrepancies between Purchase Orders and vendor Order Acknowledgments by referencing our records and/or contacting the vendor to determine if they or we need to update our records.

You will follow up on outstanding communications regarding product cost or status.

Required Skills & Qualifications:

• Advanced Microsoft Excel skills required
• Conditional formatting, including duplicate identification
• Table filtering/sorting
• XLOOKUP/VLOOKUP, ROUNDUP, IF, SUBSTITUTE, CONCAT, TEXTSPLIT
• Mathematical skills – ability to calculate various discounts and markups within Excel
• Strong logic and problem-solving skills
• Strong numerical ability and exceptional attention to detail
• Ability to identify and resolve cost discrepancies
• Professional written and verbal communication skills, including the ability to work directly with vendors by email and phone
• Strong follow-through: able to track open issues, prioritize urgent items, and see discrepancies through to resolution
• Experience in product data management/data entry, purchasing, or e-commerce product management