Data Analyst
Colmar, PA, US, 18915
- Pay
$76,200–111,900/year · BaseAnnual period assumed · Location-specific pay — pay source
#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.
Read the full posting- Work setup
- Unconfirmed
- Employment
- Unconfirmed
Before you apply
- Eligibility
Visa sponsorship is not available for this position. — eligibility source
Applicants must be authorized to work in the United States without current or future employer sponsorship. Visa sponsorship is not available for this position.
Read the full posting
What you’ll work on
Full postingBuild and maintain Qlik Sense dashboards, Excel-based reporting, and Business Objects outputs to deliver accurate, validated KPIs.
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.
From the employer’s posting
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, 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.
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.
What you’ll bring
All qualificationsCore experience
- Ability to analyze large datasets and translate findings into actionable insights.
- Bachelor’s degree in Engineering, Data Analytics, Statistics, Computer Science, or related field.
- Strong communication skills for both technical and non-technical stakeholders.
- 2-5 years of experience in analytics, data reporting, or engineering/quality support roles.
- Proficiency in data visualization and KPI storytelling for senior leadership.
- Hands-on experience with Power Query, Power Pivot, and Excel automation.
Preferred experience
- 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).
Qualification wording
Ability to analyze large datasets and translate findings into actionable insights.
Bachelor’s degree in Engineering, Data Analytics, Statistics, Computer Science, or related field.
Strong communication skills for both technical and non-technical stakeholders.
2-5 years of experience in analytics, data reporting, or engineering/quality support roles.
Proficiency in data visualization and KPI storytelling for senior leadership.
Hands-on experience with Power Query, Power Pivot, and Excel automation.
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).
Tools in this posting
- Python
- SQL
- SAP
- Power Query
Source — Tool mentions in context
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 work offsite on Fridays.
- 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.
- 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.
- 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.
- 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).
- 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.
Job description
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 work offsite 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).
#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
Your next step
- Have your CV and examples of relevant work ready.
- Check the listed location, eligibility and core experience before starting.
Complete your application on jobs.dormanproducts.com. The employer’s form will show what is required.
Already applied? Track this application
Source & posting history
Source notes
Source excerptsSelected passages from the saved posting. Check the full description for conditions and exceptions.
- Pay
#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.
- Location & working pattern
Colmar, PA, US, 18915
Working pattern and location restrictions need checking in the full posting.
- Work authorization
This role is onsite in our corporate headquarters in suburban Philadelphia (Colmar, PA) with the opportunity to work offsite 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
- Status in our records
- Active
- First seen by us
- Sep 9, 2026
- Recorded sightings
- 17
- Last seen by us
- Sep 29, 2026
These dates show when we found the listing. Check the employer’s website to confirm it is still accepting applications.
Report an errorSee how this role fits your experience
Add your resume to compare the role’s scope, tools and requirements with your experience.