Data Analyst

Allparts, Inc.; Colmar (PA); Hybrid; USD 76,000 - 112,000; Full time

Benefits offered by this job

Medical Insurance

Dental Insurance

Vision Insurance

Life Insurance

Paid Time Off

Paid Parental Leave

401k with match

Stock Purchase Plan

Job summary

Dorman Products is seeking a Data Analyst for our suburban Philadelphia headquarters (Colmar, PA) with optional remote Fridays. You will build dashboards, forecast using Python, and translate data into actionable insights for leadership. The role requires hands-on BI tooling experience and strong collaboration across Engineering, Quality, Procurement, and Manufacturing.

Qualifications include a Bachelor's degree in a related field and 2–5 years in analytics or data reporting. U.S.

Qualifications

• Bachelor's degree in Engineering, Data Analytics, Statistics, Computer Science, or related field.
• 2–5 years of analytics, data reporting, or engineering/quality support roles.
• Experience with Power Query, Power Pivot, and Excel automation.
• Experience building dashboards in Qlik Sense or similar BI tools.
• Experience using Python for data analysis, forecasting, automation, and process improvement.

Responsibilities

• Build and maintain Qlik Sense dashboards, Excel-based reporting, and BO outputs to deliver KPIs.
• Develop forecasting and predictive analytics models using Python to identify risks and opportunities.
• Create executive-ready data visualizations and reporting materials for leadership.
• Analyze warranty, returns, VOC data, and engineering project data to identify trends and improvements.
• Build and automate recurring data pipelines using Power Query, Power Pivot, Excel automation, and SQL.
• Redesign legacy reports to improve efficiency and alignment.

Skills

Data analysis

Stakeholder communication

Data visualization

Project management

Problem solving

Cross-functional collaboration

Education

Bachelors in Engineering/CS/Data Analytics

Tools

Power Query

Power Pivot

Excel automation

Qlik Sense

SAP BO/Jazz WebI

APIs

Zapier

Job description

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

Data Analyst

Date: Sep 8, 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.

Job Summary

This role is onsite in our corporate headquarters in suburban Philadelphia (Colmar, PA) with the opportunity to remotely on Fridays. Applicants must be authorized to work in the United States without current or future employer sponsorship. Visa sponsorship is not available for this position.

Primary Duties

• Build and maintain Qlik Sense dashboards, Excel-based reporting, and Business Objects outputs to deliver accurate, validated KPIs.
• Develop, enhance, validate, and maintain forecasting and predictive analytics models using Python to identify risks, uncover opportunities, and support proactive business decision-making.
• Develop clear, executive-ready data visualizations and reporting materials tailored for leadership.
• Analyze warranty, returns, voice of customer data, and engineering project data to identify trends and improvement opportunities.
• Build and automate recurring data pipelines using Power Query, Power Pivot, Excel automation, and SQL as needed.
• Redesign legacy manual reports, improving efficiency, sustainability, and alignment with standard reporting logic.
• Lead requirements gathering, translate business needs into technical specifications, and maintain documentation for processes and data definitions.
• Apply foundational statistical methods to assess and validate quality and operational performance.
• Collaborate across Engineering, Quality, Procurement, and Manufacturing while advising on data structure, reporting best practices, and leadership insights.

Qualifications

• Ability to analyze large datasets and translate findings into actionable insights.
• Strong communication skills for both technical and non-technical stakeholders.
• Proficiency in data visualization and KPI storytelling for senior leadership.
• Ability to manage multiple priorities in a fast-paced environment.
• Strong problem-solving and critical-thinking capability. High attention to detail in reporting and documentation.
• Ability to collaborate effectively across cross-functional teams.
• Physical Requirement: Capability to lift 20 pounds.
• Working Conditions: While performing the duties of this job, the employee is regularly required to reach, swivel, carry items from one location to another, and speak and actively listen. Noise level is usually moderate.

Education / Experience

• Bachelor’s degree in Engineering, Data Analytics, Statistics, Computer Science, or related field.
• 2-5 years of experience in analytics, data reporting, or engineering/quality support roles.
• Hands-on experience with Power Query, Power Pivot, and Excel automation.
• Experience building dashboards in Qlik Sense or similar BI tools.
• Experience using Python for data analysis, forecasting, automation, and process improvement initiatives.
• Familiarity with SAP Business Objects (BOBJ/WebI) reporting or willingness to learn.
• Experience with warranty, returns, QI metrics, or engineering process data (Preferred).
• Experience extracting and integrating data via APIs, including use of workflow automation tools such as Zapier (Preferred).
• Experience supporting analytics developers and IT partners (Preferred).

The US base salary range for this full-time position is $76,200.00 to $111,900.00. 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

Nearest Major Market: Philadelphia Job Segment: Computer Science, Quality Engineer, Procurement, Engineer, Database, Technology, Engineering, Operations