Data Analyst

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

The Quality & Engineering Data Analyst delivers scalable reporting and analytics for Quality, Engineering, and cross functional teams by building and maintaining Python applications, Qlik Sense applications, Business Objects reports, and automated Excel-based reporting. The role transforms Quality and Engineering data into accurate KPIs and actionable insights while applying foundational statistical methods to assess performance trends. The Data Analyst also develops and automates data pipelines, improves legacy manual reports, and creates structured datasets that support Quality and Engineering analytics. A key responsibility is gathering and translating business requirements into clear technical specifications, partnering closely with data developers and system teams. The role collaborates across Quality, Engineering, and Procurement, and regularly prepares concise, executive-ready insights for leadership.

This role is onsite in our corporate headquarters in suburban Philadelphia (Colmar, PA) with the opportunity to remotely on Fridays.

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