Mighty Auto Parts · 1 month ago
Product Information Analyst
Peachtree Corners, GA, 30092, US
Full-time
Onsite
New Grad, Entry LevelMighty Auto Parts is a leading automotive parts distributing firm based in Peachtree Corners, Georgia. The Product Information Analyst will collect, analyze, and monitor purchase data from suppliers to provide visibility into product programs and create reports that help predict costs and identify purchasing trends.
Responsibilities
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
Qualification
Required
Proficient in Outlook, Word, Excel, and PowerPoint
Strong analytical skills
Advanced Excel skills
Ability to collect, analyze and monitor purchase data from suppliers
Ability to create various reports to predict and control costs and identify product purchase trends
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
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)
Product images management
Tradeshow organization and execution
Admin and billing for website subscriptions
Product admin backup
Preferred
College degree preferred or equivalent work experience
Benefits
Medical plan
Dental/Vision plan
Life Insurance
Disability plan
PTO
401K plan
Company
Mighty Auto Parts
Since 1963, Mighty has been the gold standard of parts distribution, exclusively to the automotive service professional.
Founded in 1963
51-200 employees
Funding
Current Stage
Growth StageLeadership Team
Josh D'Agostino
President & CEO
Ken Voelker
President & CEO
Company data provided by crunchbase