Purchasing Assistant

Paylocity; Caldwell (ID); On-site; USD 35,000 - 52,000; Full time

Job summary

D&B Supply in Caldwell, Idaho is hiring two Hardside Purchasing Assistants to support the buying team by entering and processing data for merchandise selection and procurement.

The ideal candidate will work with vendors and buyers to ensure timely delivery, maintain pricing, and support inventory management while using Excel and ERP systems daily.

Qualifications

• Excellent written and oral communication skills.
• Proficient with Excel and data analysis tools.
• Experience with data entry and heavy data handling.
• Working knowledge of VLOOKUP/XLOOKUP.

Responsibilities

• Learn and use available technology to maximize efficiency, including vendor B2B sites to access UPC codes, place orders, etc.
• Maintain system data related to new vendors, SKU’s, min/max, special orders and pricing.
• Work directly with buyers in providing clerical support regarding system and product information.
• Ensure timely delivery of merchandise through consistent communication and follow-up with the vendor, distribution center and store locations.
• Research and maintain information regarding price and specifications, from vendors, catalogs and the Internet for new and existing product.
• Maintain show specials in the computer system adjusting discounts, pricing and terms.
• Maintain replenishment system for standard merchandise on a weekly basis.
• Communicate daily (via phone, email and Teams chat) with stores and other internal personnel in resolving issues regarding new product lines, special order capabilities, pricing, advertising and delivery of merchandise.
• Other duties pertaining to the procurement of products, goods or services as assigned by area manager/director.

Skills

Excel proficiency

Communication skills

Analytical skills

Data entry

Education

High School Diploma or equivalent

Associates or Bachelor's degree in Business or related field

Tools

Excel (VLOOKUP / XLOOKUP)

10-key

Job description

Description

Who We Are

We are a leading farm and ranch lifestyle retailer headquartered in the Caldwell, Idaho area with stores in Idaho and Oregon. We are passionate about our customers in providing products to enhance their lifestyle and experience. Whether they have a 100-acre ranch or a small garden in their backyard, we take pride in providing them with solutions for their needs. We carry a large depth of product categories allowing us to best serve our customers. In our stores you will find products from pet food and supplies, power tools and accessories, to lawn and garden and almost everything in between. D&B Supply is a company built to serve those that live and love the northwest, including ranchers, farmers, and suburbanites who feel a real connection to the land, their animals, and the outdoors.

At D&B, our store consists of what we call Hardside goods and Clothing goods. Hardside mainly consisting of Ag, Electrical, Plumbing, Housewares, Lawn/Garden, Power Equipment, Tools, Fencing, etc... We are currently hiring two Hardside Purchasing Assistants. These positions share similar responsibilities but will primarily report to their assigned Buyer. The ideal candidate will support buying team members by entering and processing data for the selection and procurement of merchandise, which supports overall company sales volume, gross margin and turnover objectives.

Essential Functions/Duties:

• Learn and fully utilize available technology to maximize job efficiency including vendor B2B information sites to access UPC codes, place orders, etc.
• Maintain system data related to new vendors, SKU’s, min/max, special orders and pricing.
• Work directly with buyers in providing clerical support regarding system and product information.
• Ensure timely delivery of merchandise through consistent communication and follow-up with the vendor, distribution center and store locations.
• Research and maintain information regarding price and specifications, from vendors, catalogs and the Internet for new and existing product.
• Maintain show specials in the computer system adjusting discounts, pricing and terms.
• Maintain replenishment system for standard merchandise on a weekly basis.
• Communicate daily (via phone, email and Teams chat) with stores and other internal personnel in resolving issues regarding new product lines, special order capabilities, pricing, advertising and delivery of merchandise.
• Other duties pertaining to the procurement of products, goods or services as assigned by area manager/director.

Requirements

Required Knowledge and Skills: Requires excellent written and oral communication skills along with strong analytical, organizational and computer skills. Must be very proficient with Excel i.e. using established formulas as well as creating new formulas. Working knowledge of 10 key, word processing, and ability to manage heavy data entry duties.

Required Experience: At least 2 years' experience in an office, accounting, purchasing or data entry environment preferred. Working knowledge of Microsoft Excel (VLOOKUP/XLOOKUP) and/or other analytical spreadsheet tools, inventory management, pricing and review, and freight.

Required Education/Certification: High School Diploma or equivalent; Associates or Bachelor’s degree in Business or related field; or equivalent experience preferred, not required.

Other Requirements: Must be able to spend many hours a day working at a computer, walk, bend, stoop, kneel, reach, and lift up to 45 lbs (most items will be less 1-5 lb range).

This description is intended to indicate the kinds of tasks and levels of work difficulty that will be required of positions that will be given this title and shall not be construed as declaring what the specific duties and responsibilities of any particular position shall be. It is not intended to limit or in any way modify the right of any supervisor to assign, direct, and control the work of employees under his or her supervision. The use of a particular expression or illustration describing duties shall not be held to exclude other duties not mentioned that are of similar kind or level of difficulty.