Product Data Specialist

Hillman Group; Forest Park (OH); On-site; USD 65,000 - 90,000; Full time

Job summary

Hillman Group is seeking a Product Data Specialist to manage critical product information across the lifecycle. You will ensure data integrity across PLM, PIM, and related systems, while collaborating with cross-functional teams to collect, standardize, and distribute product data for operations and channels.

The role requires strong analytical skills, advanced Excel capabilities, and experience with PLM systems.

Qualifications

• Bachelor's degree in Information Systems, Business Administration, or related field.
• Experience in product data management in consumer products.
• Advanced Excel with macro development.
• Experience with database structures and data integration.
• Knowledge of PLM systems and governance.

Responsibilities

• Manage product data across lifecycle and ensure accuracy across systems.
• Create and maintain BOMs and PLM relationships.
• Develop and execute Excel macros to automate data population in PLM environments.
• Coordinate data integration with cross-functional teams.
• Document and improve data management SOPs.
• Support IT and Data Governance on data quality measures.

Skills

Analytical thinking

Detail oriented

Time management

Communication

Self-management

Education

Bachelor's degree in Information Systems, Business Administration, or related field

Equivalent combination of education and experience

Tools

Excel macros

Oracle PLM

PIM systems

PLM data mgmt

Databases

Job description

Job Summary

The Product Data Specialist is responsible for managing and maintaining critical product information throughout the product lifecycle. This role serves as the cornerstone for product data integrity across multiple systems, ensuring accurate product information is available for internal stakeholders and external channels. The specialist works cross-functionally to collect, organize, standardize, and distribute product data that supports business operations and decision-making.

Essential Job Functions

• Product Data Management
  • Initiate new item creation and setup in enterprise systems
  • Process master item set up submissions and manage part number assignment/creation
  • Maintain Product Lifecycle Management (PLM) systems by connecting technical information to items through bill of materials / relationship linkage
  • Manage Product Information Management (PIM) data for downstream consumption
  • Ensure data consistency across interconnected systems and databases
• Data Creation and Integration
  • Extract and transform product information from various sources including company personnel, technical documentation, websites, e-commerce platforms, and validation reports
  • Collect and standardize product specifications through collaboration with cross-functional teams
  • Convert technical drawings into structured product data within product data hub systems
  • Create and modify product bills of materials (BOMs) 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
• Process Management
  • Document and maintain standard operating procedures for data management processes
  • Prioritize workload to maximize efficiency while adapting to changing business priorities
  • Independently manage assigned projects with minimal supervision
  • Implement data automation solutions for routine tasks
  • Working with IT and Data Governance, design and execute bulk data upload approaches for large-scale projects (e.g., acquisitions)
  • Estimate task/project timelines and document outcomes for future reference
• System Support and Administration
  • Provide direction and troubleshooting for PLM and Product Data Hub (PDH) systems
  • Serve as backup support for management when needed
  • Maintain comprehensive 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

* This job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee. Duties, responsibilities and activities may change or new ones may be assigned at any time with or without notice.

Employees are expected and encouraged to participate in safety and health program activities including immediately reporting hazards, immediately reporting unsafe work practices and incidents to supervisors, wearing required personal protective equipment, and participating in and supporting safety committee activities.

Education & Experience

• Bachelor's degree in Information Systems, Business Administration, or related field; or 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/governance principles
• Strong analytical skills with attention to detail and accuracy
• Excellent organizational and time management capabilities
• Demonstrated ability to manage multiple priorities in a fast-paced environment
• 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

Competencies – Knowledge, Skills and Abilities

• Technical Expertise: Strong understanding of data structures, system relationships, and business application integration
• Analytical Thinking: Ability to evaluate complex data sets and identify patterns or inconsistencies as well as the ability to recognize and optimize out system inefficiencies
• Communication: Clear and effective communication with cross-functional teams
• Problem Solving: Creative approach to resolving data management challenges
• Adaptability: Comfort with changing priorities and evolving business needs
• Self-Management: Ability to work independently and proactively manage workload
• Continuous Learning: Commitment to staying current with emerging technologies and industry trends

Operational Equipment

• N/A

Work Environment and Physical Demands

• Office: Office setting. Seldom exposed to fumes or airborne particles. Loud working environment of the shop area. Functional vision and hearing required.
• Office: Sedentary.