Product Information Specialist

Mighty Distributing System of America (MDSA) (Mighty Auto Parts), the quality/service leader in the automotive aftermarket, is a leading automotive parts distributing firm based in Peachtree Corners (Atlanta Metro), Georgia. Our company provides an inviting atmosphere in which to work and our culture and people bring a wealth of experience, talent and enthusiasm to their jobs. MDSA has earned the respect of our industry through our expertise and accolades, such as Atlanta Business Chronicle-Top 25 Franchises award, Entrepreneur Magazine-Top 500 Franchises & America’s Top Franchise Opportunities award and Franchise Business Review-Best Franchise Opportunities award. The most unique element of this winning combination is Mighty's organizational culture that prizes extraordinary personal service over all else; doing whatever it takes to enhance the success of its customer-partners.

Summary Of Functions

The ideal candidate will collect, analyze and monitor purchase data from suppliers to provide visibility to which franchises are utilizing product programs. This information will be used to create various reports to predict and control costs and identify product purchase trends. In addition to these responsibilities, an internal system with product pricing will also be maintained. The candidate should have strong analytical skills along with advanced Excel skills.

General Responsibilities/Job Summary

• Maintenance of internal pricing system (Buying Guide)
• Manage price files from suppliers and import pricing into system
• Add, discontinue and/or supersede part numbers
• Increase/decrease pricing on part numbers for each supplier and apply any tier pricing when appropriate
• Generate movement (POP) codes
• Track and interpret data from various suppliers/vendors
• Generate various reports from collected data using VLOOKUP, Pivot Table and Concatenate functions in Excel:
• Dollar sales by franchise and unit volume by product
• Order tracking and turnaround time reports through Mighty’s direct ship program
• Vendor purchase reports
• Formulate extrapolations and weighted average
• Cross reference of supplier material numbers
• Manage lubricants ordering system
• Onboarding of franchises into the program
• Submit list of customers and annual gallon demands
• Register franchises into the system
• Instruct franchises on how to utilize the website and submit orders
• Liaison between franchise and supplier
• Adding locations and obtaining necessary tax certificates
• Invoicing issue resolution
• Order tracking and obtaining PODs (Proof of Delivery)
• Other responsibilities
• Product images
• Tradeshow organization and execution
• Admin and billing for website subscriptions
• Product admin backup
  
  
  

Experience Requirements

Must be proficient in Outlook, Word, Excel, and PowerPoint.

Educational Requirements

College Degree Preferred Or Equivalent Work Experience.

Working Conditions

Daily office hours are normally between 8:00 AM to 5:00 PM, Monday through Friday, with occasional weekend responsibilities.

Benefits

MDSA offers a competitive compensation and benefits program including: Medical plan, Dental/Vision plan, Life Insurance, Disability plan, PTO and 401K plan.

"Job descriptions are not intended, and should not be construed, to be all-inclusive lists of all responsibilities, skills, efforts or working conditions associated with this job. While this job description is intended to be an accurate reflection of the job requirements, management reserves the right to modify, add or remove duties from particular jobs and assign other duties as necessary."

"We are an Equal Opportunity Employer. We do not discriminate on the basis of race, religion, color, sex, age, national origin, or disability."