Specialist, Supply Chain Master Data Execution

Dorman Products; Colmar (PA); On-site; USD 63,000 - 90,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Paid time off

Paid parental leave

Holidays and floating holidays

401k with match & profit-sharing

Discounted Employee Stock Purchase

Job summary

Dorman Products seeks an Analyst to own SAP master data changes across Light Duty and Heavy Duty segments. You will process ~115 mass-maintenance requests daily via Winshuttle/Precisely Automate Studio and manage the Power Automate/SharePoint intake portal.

Responsibilities include validation, posting control, and maintaining audit-ready records. This role sits in a Supply Chain Systems team undergoing transformation toward automated, scalable processes with growth potential.

Qualifications

• Proficient in Excel with advanced formulas, data validation, Power Query, handling large data sets.
• Experience with Power BI, Power Automate, and SharePoint; able to troubleshoot and extend existing production solutions.
• Strong accuracy and self-direction on high-volume transactional work; ability to reject non-conforming work including from senior stakeholders.
• Fast learner of ERP processes; SAP material master maintenance capability within the first months.

Responsibilities

• Execute daily master data changes across LD and HD using Winshuttle templates.
• Own the full request lifecycle: intake, validation, execution, confirmation, closure.
• Serve as control checkpoint: verify completeness, accuracy, and applicability before posting.

Skills

Advanced Excel

Power BI

Power Automate

SharePoint

Winshuttle

SQL

Education

Bachelor's degree in Supply Chain/Business/Information Systems

Tools

Winshuttle/Precisely Automate Studio

Power Automate

SharePoint

SQL

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

Dorman Products is seeking an Analyst to own the execution of SAP master data changes across our Light Duty and Heavy Duty business segments. The role processes roughly 115 mass-maintenance requests per day from planning, procurement, and operations partners through Winshuttle / Precisely Automate Studio against SAP ECC, and owns the Power Automate and SharePoint portal those requests arrive through.

Master data drives planning outcomes: errors propagate directly into MRP, procurement signals, and inventory positions. This role combines disciplined, high-volume execution with the judgment to validate what gets posted and the communication skills to serve as the recognized point of contact across both segments.

The position sits within a Supply Chain Systems function undergoing a multi-year planning transformation, including replacement of the current advanced planning platform. As automation capability matures, the role shifts from manual processing toward oversight and exception management, offering a foundation for growth into broader supply chain systems and analytics roles.

Primary Duties

Execution And Control (primary)

• Execute daily master data change requests across LD and HD using established Winshuttle templates, keeping the queue current.
• Own the full request lifecycle: intake, validation, execution, confirmation, and closure.
• Serve as the control checkpoint. Validate every submission for completeness, field-level accuracy, and material and plant applicability before posting, and reject requests that do not conform.
• Judge whether a requested change will produce the intended planning outcome. Requests originate with the business; this role does not submit its own.
• Maintain execution, rejection, and error records sufficient to evidence the control for internal and external audit.
• Resolve failed or partially posted runs and escalation systemic issues to Supply Chain Systems leadership.
• Apply segment-specific handling for LD (daily replan, kitting, high change frequency) and HD (machining and assembly, capacity-constrained, longer lead times).

Intake Portal Ownership (primary)

• Own the existing Power Automate and SharePoint intake and notification portal: flow health, list structures, forms, and permissions.
• Extend front-end validation so non-conforming requests are caught at submission rather than at execution.
• Improve routing, notification, and status visibility so requesters can self-serve on request state.
• Keep flows, schemas, and dependencies documented for continuity.

Partner Communication (primary)

• Act as the primary point of contact for planning, procurement, and operations on master data change; communicate status and exceptions proactively.
• Translate between business intent and system execution, resolving mismatches before posting.
• Report on request volume, throughput, and error rates to inform capacity and prioritization decisions.
• Maintain submission documentation and training material; reduce rework through requester education.

Qualifications

Required

• Exceptional Excel proficiency: advanced formulas, data validation, Power Query, and preparation of large structured data sets for system load.
• Power BI, Power Automate, and SharePoint proficiency, including the ability to support, troubleshoot, and extend an existing production solution built by someone else.
• Proven accuracy and self-direction on high-volume transactional work under sustained demand.
• Independent judgment and the willingness to reject non-conforming work, including from senior stakeholders, and to defend that decision.
• Strong written and verbal communication, and effectiveness across team boundaries — including translating requirements to a technical owner and tracking work through another team's queue.
• Ability to learn ERP transactional processes quickly. Direct SAP experience is not required; proficiency in SAP material master maintenance within the first months of the role is.

Preferred

• SAP ECC material master maintenance (MM02) and MRP-relevant fields; MM and PP familiarity including MRP types, lot sizing, planning parameters, and MRP controller assignment.
• Winshuttle / Precisely Automate Studio or comparable SAP mass-maintenance tooling.
• Experience building workflow, intake, or approval solutions in Power Automate and SharePoint.
• SQL or scripting, and exposure to scheduled or unattended job execution and exception-based monitoring.
• Manufacturing or distribution planning background; awareness of ERP change control and segregation-of-duties principles.

Education / Experience

• 2+ years in supply chain, master data, ERP operations, or a related analytical function.
• Bachelor's degree in Supply Chain, Business, Information Systems, or a related field, or equivalent practical experience.

The US base salary range for this full-time position is $63,300.00 to $90,100.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