Sr. Analyst, Supply Chain Analytics

Allparts, Inc.; Colmar (PA); On-site; USD 93,000 - 138,000; Full time

Job summary

Dorman Products seeks a Sr. Analyst, Supply Chain Analytics to design and maintain reporting frameworks, dashboards, and analytics across Supply Chain.

You will build semantic models in Power BI, develop data transformations in Power Query (M) and DAX, and partner with SAP ECC/APO data sources to deliver analysis-ready datasets. You will lead automation with Power Automate, track functional KPIs across procurement, planning, distribution and logistics, and provide data-driven narratives for

Qualifications

• Bachelor's degree in a related field.
• 5+ years in supply chain analytics or reporting.
• Proficiency with SQL and Power BI.
• Experience with SAP ECC/APO and data modeling.
• Experience with automation and data-driven storytelling.

Responsibilities

• Design, build, and maintain reporting frameworks, dashboards, and analytics for Supply Chain.
• Build and govern Power BI semantic models and standardized metrics.
• Develop data transformations with Power Query (M) and DAX for reliable metrics.
• Model data from SAP ECC/APO and OneLake/Microsoft Fabric into analytics datasets.
• Lead automation to streamline reporting using Power Automate.
• Analyze data to identify trends and optimization opportunities for leadership.
• Develop and report KPIs across procurement, planning, distribution, and logistics.
• Collaborate with cross-functional teams to translate business needs into analytics.
• Contribute to migration toward Power BI enterprise reporting and standards.
• Stay current on best practices in supply chain analytics.

Skills

Analytical thinking

Cross-functional collaboration

Stakeholder management

Problem-solving

Communication

Education

Bachelor’s degree in related field

Tools

Power BI

DAX

Power Query (M)

SQL

Python

SAP ECC/APO

Microsoft Fabric

Power Automate

Job description

Select how often (in days) to receive an alert:

Sr. Analyst, Supply Chain Analytics

Date: Sep 23, 2026

Company: Dorman Products

Dorman was founded on the belief that people should have greater freedom to fix motor vehicles. For over 100 years, we have been driving new solutions, releasing tens of thousands of aftermarket replacement products engineered to save time and money, and increase convenience and reliability. Founded and headquartered in the United States, we are a pioneering global organization offering an always-evolving catalog of automotive, heavy-duty and specialty vehicle products. Today, we have more than 3,800 employees across 29 different locations, with a family of brands that also includes SuperATV and Dayton Parts. Reaching a revenue of $2.13 billion in 2025, Dorman is publicly traded under the stock ticker DORM.

Everyone who works at Dorman is called a Contributor. We need everyone, regardless of role and experience, to contribute to our success. That means everyone has a unique ability to make an impact on the business. We encourage all our Contributors to bring their authentic selves to work. The freedom to pursue new ideas, offer different perspectives, and grow in your career is fundamental to working at Dorman.

Primary Duties

• Design, build, and maintain reporting frameworks, dashboards, and analytics that support strategic and operational decision-making across Supply Chain functions
• Build and govern reusable Power BI semantic models so that key metrics are defined once and shared across reports
• Develop data transformations and business logic using Power Query (M) and DAX to shape source data and calculate metrics reliably at scale
• Curate and model data sourced from SAP ECC, SAP APO, and the OneLake / Microsoft Fabric environment into structured, analysis-ready datasets
• Lead automation efforts to streamline reporting and reduce manual data processing, including workflow automation using Power Automate
• Analyze Supply Chain data to identify trends, inefficiencies, and opportunities for optimization, providing clear data-driven narratives for leadership and frontline contributors
• Develop, track, analyze, and report on functional KPIs across Supply Chain operations - including procurement, supply and demand planning, distribution, and logistics - using root-cause analysis, trend analysis, and benchmarking
• Partner with cross-functional teams to translate business needs into analytical solutions, and communicate technical concepts to non-technical stakeholders
• Contribute to the broader migration toward Power BI as an enterprise reporting platform, including improving data modeling standards and reducing reliance on manual flat-file processes
• Stay current on emerging technologies and best practices in Supply Chain analytics and reporting

Qualifications

• Demonstrated ability to apply quantitative and analytical skills to assess business situations and propose practical solutions
• Advanced experience building reports and data models in Power BI, including DAX and Power Query (M)
• Advanced experience with Microsoft Office; working experience with the Microsoft Power Platform (Power BI required; Power Automate a plus)
• Strong ability to structure, model, and reconcile data from multiple source systems
• Ability to work effectively in a cross-functional environment and manage multiple competing priorities
• Excellent problem-solving, communication, and stakeholder-management skills

Education / Experience

• Bachelor’s degree in Business Administration, Supply Chain Management, Information Technology, Engineering, or a related field
• 5+ years of experience in Supply Chain analytics, reporting, or related roles
• Required: Proficiency with SQL for querying and shaping data, and advanced proficiency with a modern BI / data visualization platform (Power BI required)
• Required: Experience with Python for data analysis and automation
• Working knowledge of ERP systems and their data structures; hands‑on experience with SAP ECC and SAP APO strongly preferred (SAP WM / warehouse data experience a plus; exposure to S/4HANA a plus but not required)
• Experience with process automation and building efficient, maintainable reporting solutions
• Experience working within the Microsoft Fabric / OneLake ecosystem (e.g., dataflows, lakehouse-style data) a plus

The US base salary range for this full‑time position is $92,700 to $138,000. This role is also eligible for a bonus. The actual base pay offered to the successful candidate will depend on multiple factors, including but not limited to job-related knowledge and skills, experience, business needs, geographical location, and internal pay equity. Compensation decisions are made based on the specific facts and circumstances of each role and candidate.

As a Dorman US contributor, you (and eligible dependents, as applicable) will have access to medical, dental, vision, basic life insurance, paid time off (sick/vacation), and Paid Parental Leave. U.S. employees are entitled to paid holidays, floating holidays, and paid time off starting in their first year of employment depending on hire date. You are also able to participate in our 401k retirement plan (with company match and profit‑sharing) and Discounted Employee Stock Purchase Plan.

Dorman Products is an equal opportunity employer; we value a combination of ideas, perspectives, and cultures at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sex, gender identity, sexual orientation, age, marital status, veteran status, or disability status. EEO/AA Employer M/F/D/V. www.DormanProducts.com

#LI-MM1

Nearest Major Market: Philadelphia
Job Segment: Supply Chain, Logistics, Supply, ERP, SAP, Operations, Technology