Product Data Specialist

Hillman•Forest Park, OH

About The Position

The Product Data Specialist manages and maintains critical product information throughout the product lifecycle, supporting data integrity across multiple systems and making accurate product information available to internal stakeholders and external channels. The role collects, organizes, standardizes, and distributes product data in support of business operations and decision-making. The specialist creates and maintains item records, product specifications, bills of materials, and product relationships in enterprise, PLM, and product data hub systems. The role gathers information from sources such as company personnel, technical documentation, websites, e-commerce platforms, and validation reports; converts technical drawings into structured product data; and uses Excel macros or equivalent tools to automate data population in Oracle PLM environments. The position also documents data-management procedures, manages projects and workload, develops automation solutions, and works with IT and Data Governance on bulk data uploads and data-governance practices. It provides troubleshooting and direction for PLM and Product Data Hub (PDH) systems and may serve as backup support for management. Duties may change or new ones may be assigned. Employees are expected to participate in safety and health program activities, including reporting hazards and unsafe practices, wearing required personal protective equipment, and supporting safety committee activities.

Requirements

Bachelor's degree in Information Systems, Business Administration, or a related field, or an equivalent combination of education and experience.
Working experience in product data management, preferably in the consumer products industry.
Advanced proficiency in Excel, including macro development and complex data manipulation.
Experience with database structures, relationships, and data integration.
Working knowledge of PLM systems and product data management and governance principles.
Strong analytical skills and attention to detail and accuracy.
Excellent organizational and time-management capabilities.
Demonstrated ability to manage multiple priorities in a fast-paced environment.
Strong understanding of data structures, system relationships, and business application integration.
Ability to evaluate complex data sets, identify patterns or inconsistencies, and recognize and optimize system inefficiencies.
Clear and effective communication with cross-functional teams.
Creative problem-solving skills for data-management challenges.
Comfort with changing priorities and evolving business needs.
Ability to work independently and proactively manage workload.
Commitment to staying current with emerging technologies and industry trends.

Nice To Haves

Experience with Oracle PLM systems.
Knowledge of consumer product development processes.
Familiarity with e-commerce data requirements.
Previous experience with data migration projects.
Understanding of product attribution standards in retail environments.

Responsibilities

Initiate new item creation and setup in enterprise systems; process master item setup submissions and manage part-number assignment or creation.
Maintain PLM systems by linking technical information to items through bills of materials and other relationships.
Manage PIM data for downstream consumption and ensure consistency across interconnected systems and databases.
Extract, transform, collect, and standardize product information from company personnel, technical documents, websites, e-commerce platforms, and validation reports.
Convert technical drawings into structured product data within product data hub systems.
Create and modify product bills of materials and maintain PLM relationships.
Develop and execute Excel macros or equivalent tools to automate data population in Oracle PLM environments.
Implement quality-control measures to verify data accuracy and completeness.
Document and maintain standard operating procedures for data-management processes.
Prioritize workload, independently manage assigned projects with minimal supervision, and adapt to changing business priorities.
Implement automation solutions for routine tasks.
Work with IT and Data Governance to design and execute bulk data-upload approaches for large-scale projects, such as acquisitions.
Estimate task and project timelines and document outcomes for future reference.
Provide direction and troubleshooting for PLM and Product Data Hub systems; serve as backup support for management when needed.
Maintain an understanding of item attribution and its business impact.
Archive project data according to company policies and industry regulations.
Collaborate with IT and business teams to implement data-governance best practices.
Participate in safety and health program activities, including reporting hazards and unsafe practices, wearing required personal protective equipment, and supporting safety committee activities.