Pep Boys ยท 1 day ago
Assortment Analyst
Bala-Cynwyd, PA
Full-time
Hybrid
Mid Level
4+ years expPep Boys is a company focused on optimizing product assortments through data-driven merchandising decisions. The Assortment Analyst will analyze sales and inventory data, develop dashboards, and collaborate with various teams to improve sales and customer experience.
AutomotiveRetailService Industry
Responsibilities
Analyze sales, inventory, margin, and offtake data to identify trends, opportunities, and risks across categories and store locations
Develop, maintain, and enhance dashboards, reports, and data visualizations to track merchandising KPIs (e.g., sell-through, stock turns, markdown performance)
Support product assortment planning by providing SKU-level and category-level insights that inform pricing, mix, lifecycle management, and promotional decisions
Monitor competitor pricing, assortment, and promotional activity to guide strategic recommendations
Partner with merchandising, operations, and marketing teams on promotional planning and execution
Conduct deep-dive analysis to evaluate the effectiveness of assortment changes, pricing strategies, and promotional actions
Present analytical insights and recommendations in a clear, actionable format for cross-functional stakeholders and senior leaders
Ensure data quality and integrity across reporting tools, methodologies, and analytical processes
Qualification
Required
4-6 years of experience required
Proficiency with Excel and data visualization platforms (e.g., Tableau, Power BI, DOMO, Looker)
Strong understanding of retail metrics, merchandising principles, and product lifecycle concepts
Familiarity with consumer offtake and syndicated data sources (e.g., internal POS, NielsenIQ, Circana)
Strong analytical skills and the ability to interpret large datasets into meaningful business insights
High attention to detail, accuracy, and data integrity
Critical thinking and structured problem-solving abilities
Ability to communicate complex data clearly to non-technical audiences
Strong business acumen and an understanding of financial and operational implications of assortment decisions
Skilled in data visualization and storytelling through dashboards and presentations
Ability to work in a fast-paced, dynamic environment with shifting priorities
Strong cross-functional collaboration and communication skills
Preferred
Experience in retail, consumer goods, automotive, or related industries is beneficial but not required
Knowledge of analytics tools or programming languages such as SQL, Python, or R
Familiarity with retail ERP or merchandising systems (e.g., Oracle, SAP, Netsuite)
Benefits
Medical, dental, and vision benefits
Life insurance
Short Term Disability
Supplemental benefits
401(k) with company match
PTO and holiday pay
On-demand pay partner (DailyPay)
Reduced benefits available for part-time team members
Company
Pep Boys
Pep Boys is an automotive aftermarket chain and retailer that offers quality auto repair and car parts.
5001-10000 employees
Funding
Current Stage
Late StageTotal Funding
unknown2015-12-31Acquired
Leadership Team
Joe Auriemma
Chief Executive Officer
Scott Collette
Chief Executive Officer
Recent News
2025-11-14
Arizona Daily Star
2025-11-13
2025-11-07
Company data provided by crunchbase