Data Analyst

Allparts, Inc.; Northern (KY); Hybrid; USD 76,000 - 112,000; Full time

Benefits offered by this job

Medical insurance

Paid time off

401k with company match

Job summary

Dorman Products is seeking a Data Analyst to join our analytics team at the Colmar, PA HQ with the option to work remotely on Fridays. You will build dashboards, forecasting models, and reporting materials for leadership, while partnering with Engineering, Quality, Procurement, and Manufacturing.

The role requires 2–5 years of analytics experience, strong data visualization skills, and comfort with Qlik Sense, Python, and SAP BO reporting. Applicants must be authorized to work in the US.

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 experience.
• Hands-on experience with Power Query, Power Pivot, and Excel automation.
• Experience building dashboards in Qlik Sense or similar BI tools.
• Familiarity with SAP BO/JOB reporting or willingness to learn.
• Experience with warranty, returns, QI metrics, or engineering process data (Preferred).
• Experience extracting and integrating data via APIs, including Zapier (Preferred).
• Experience supporting analytics developers and IT partners (Preferred).

Responsibilities

• Build and maintain Qlik Sense dashboards and Excel reporting to deliver KPIs.
• Develop forecasting and predictive analytics models using Python.
• Create executive-ready data visualizations for leadership.
• Analyze warranty, returns, and engineering data for trends.
• Automate data pipelines with Power Query, Power Pivot, SQL as needed.
• Redesign legacy reports to improve efficiency and consistency.
• Lead requirements gathering and translate business needs into specs.
• Apply statistical methods to assess quality and performance.
• Collaborate with Engineering, Quality, Procurement, and Manufacturing on data practices.

Skills

Data analysis

Data visualization

Stakeholder communication

Cross-functional collaboration

Attention to detail

Time management

Education

Bachelor's degree

Tools

Qlik Sense

Power Query

Power Pivot

Excel automation

SAP Business Objects

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.
• 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).

#LI-EK1

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, Engineer, Quality Engineer, Equity, Technology, Engineering, Finance, Automotive