Data Analyst

Dorman Products•Hatfield Township, PA

3d•$76,200 - $111,900•Hybrid

About The Position

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.

Requirements

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

Nice To Haves

Experience with warranty, returns, QI metrics, or engineering process data
Experience extracting and integrating data via APIs, including use of workflow automation tools such as Zapier
Experience supporting analytics developers and IT partners

Responsibilities

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.