Data Analyst

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.

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.

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

life insurance, parental leave, paid time off, paid holidays, 401(k), retirement plan United States, Pennsylvania, Colmar Sep 09, 2026, 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 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.