Automotive Aftermarket Product Analyst

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