Product Information Specialist at Mighty Auto Parts

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 & Americas Top Franchise Opportunities award and Franchise Business Review-Best Franchise Opportunities award. The most unique element of this winning combination is Mightys organizational culture that prizes extraordinary personal service over all else; doing whatever it takes to enhance the success of its customer-partners.Summary of FunctionsThe 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 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 SummaryMaintenance of internal pricing system (Buying Guide)Manage price files from suppliers and import pricing into systemAdd discontinue and/or supersede part numbersIncrease/decrease pricing on part numbers for each supplier and apply any tier pricing when appropriateGenerate movement (POP) codesTrack and interpret data from various suppliers/vendorsGenerate various reports from collected data using VLOOKUP Pivot Table and Concatenate functions in Excel:Dollar sales by franchise and unit volume by productOrder tracking and turnaround time reports through Mightys direct ship programVendor purchase reportsFormulate extrapolations and weighted averageCross reference of supplier material numbersManage lubricants ordering systemOnboarding of franchises into the programSubmit list of customers and annual gallon demandsRegister franchises into the systemInstruct franchises on how to utilize the website and submit ordersLiaison between franchise and supplierAdding locations and obtaining necessary tax certificatesInvoicing issue resolutionOrder tracking and obtaining PODs (Proof of Delivery)Other responsibilitiesProduct imagesTradeshow organization and executionAdmin and billing for website subscriptionsProduct admin backupExperience RequirementsMust be proficient in Outlook Word Excel and PowerPoint.Educational RequirementsCollege 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.Required Experience:IC Key Skills Sales Experience,Marketing,Customer Service,Communication skills,Military Experience,Retail Sales,Product Demos,Customer Support,Product Management,Product Development,Unity,Microscopy Employment Type : Full-Time Experience: years Vacancy: 1