Data Analyst - Forecasting & BI Dashboards (Hybrid)

Allparts, Inc.; Colmar (PA); Hybrid; USD 76,000 - 112,000; Full time

Benefits offered by this job

Medical Insurance

Dental Insurance

Vision Insurance

Life Insurance

Paid Time Off

Paid Parental Leave

401k with match

Stock Purchase Plan

Job summary

Dorman Products is seeking a Data Analyst for our suburban Philadelphia headquarters (Colmar, PA) with optional remote Fridays. You will build dashboards, forecast using Python, and translate data into actionable insights for leadership. The role requires hands-on BI tooling experience and strong collaboration across Engineering, Quality, Procurement, and Manufacturing.

Qualifications include a Bachelor's degree in a related field and 2–5 years in analytics or data reporting. U.S.

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

Responsibilities

• Build and maintain Qlik Sense dashboards, Excel-based reporting, and BO outputs to deliver KPIs.
• Develop forecasting and predictive analytics models using Python to identify risks and opportunities.
• Create executive-ready data visualizations and reporting materials for leadership.
• Analyze warranty, returns, VOC data, and engineering project data to identify trends and improvements.
• Build and automate recurring data pipelines using Power Query, Power Pivot, Excel automation, and SQL.
• Redesign legacy reports to improve efficiency and alignment.

Skills

Data analysis

Stakeholder communication

Data visualization

Project management

Problem solving

Cross-functional collaboration

Education

Bachelors in Engineering/CS/Data Analytics

Tools

Power Query

Power Pivot

Excel automation

Qlik Sense

SAP BO/Jazz WebI

APIs

Zapier

Job description

Dorman Products is seeking a Data Analyst for our suburban Philadelphia headquarters (Colmar, PA) with optional remote Fridays. You will build dashboards, forecast using Python, and translate data into actionable insights for leadership. The role requires hands-on BI tooling experience and strong collaboration across Engineering, Quality, Procurement, and Manufacturing.

Qualifications include a Bachelor's degree in a related field and 2–5 years in analytics or data reporting. U.S.