Holstein Parts→
Automotive Aftermarket Product Analyst
Entry LevelOn-site
Location
Pensacola, FL
Salary
$40k–$50k/yr
Experience
Not specified
Posted
2 weeks ago
Skills
data analysismicrosoft excelpivot tablesvlookupdata filtersgoogle sheetsgoogle workspaceinternet researchoem automotive catalogsaftermarket automotive catalogsanalytical skills
Job Description
Summary: Holstein Parts is a leading aftermarket automotive parts supplier based in Pensacola, FL, specializing in engine management, braking, and HVAC management components. They are seeking a detail-oriented and data-driven Product Management Support Analyst to focus on data analysis and product research to support product management initiatives and customer service operations.
Responsibilities:
- Collect, analyze, and manipulate large data sets using Excel (including Pivot Tables, VLOOKUP, filters, and other functions)
- Mine and interpret data to identify part number sequences and patterns to determine part origin (OEM vs. aftermarket)
- Maintain accurate product data for catalogs, internal systems, and customer deliverables
- Perform internet-based research to compare and validate part data across OEM and aftermarket catalogs
- Review OEM and competitor interchanges and catalog information to troubleshoot potential product issues
- Identify discrepancies in product data and provide recommendations for corrections or improvements
- Collaborate with Product Management, Sales, Customer Service, and Supply Chain teams to address product inquiries and meet customer and internal deadlines
- Assist in supporting supply chain and cataloging tasks as needed
- Respond to occasional customer service inquiries, including part identification and basic troubleshooting
- Communicate effectively with customers and partners, including non-native English speakers, in a professional and clear manner
Required Qualifications:
- Education: Associate or bachelor's degree preferred, or equivalent experience in a data or technical support role
- Experience: Experience working with large data sets
- Moderate to advanced proficiency in Microsoft Excel (Pivot Tables, VLOOKUP, data filters)
- Experience with Google Sheets and other Google Workspace tools
- Skills: Strong attention to detail and pattern recognition
- Excellent analytical and organizational skills
- Strong written and verbal communication skills
- Ability to multitask and manage time effectively in a fast-paced environment
- Self-starter with the ability to work independently and within a collaborative team setting
Preferred Qualifications:
- Basic Internet research skills and familiarity with OEM/aftermarket automotive catalogs are a plus
Required Skills: Data Analysis, Microsoft Excel, Pivot Tables, VLOOKUP, Data Filters, Google Sheets, Google Workspace, Internet Research, OEM Automotive Catalogs, Aftermarket Automotive Catalogs, Analytical Skills
Benefits: Health, dental, and vision insurance, Paid time off and holidays, 401(k) plan with company match, Opportunities for professional development
Benefits
Health, dental, and vision insurance
Paid time off and holidays
401(k) plan with company match
Opportunities for professional development