Product Data Specialist

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

Job summary

The Hillman Group in Cincinnati is seeking a Product Data Specialist to manage and maintain critical product information across the product lifecycle, ensuring data accuracy for internal teams and external channels.

You will collect, standardize, and distribute product data, manage bills of materials and PLM relationships, develop Excel-based automation, and collaborate with IT and data governance to improve data quality across systems.

Qualifications

• Bachelor's degree in Information Systems, Business Administration, or related field.
• 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.

Responsibilities

• Initiate new item creation and setup in enterprise systems.
• Process master item set up submissions and manage part number assignment/creation.
• Maintain PLM data by linking technical information to items.
• Manage PIM data for downstream consumption.
• Develop and execute Excel macros to automate data population in Oracle PLM.
• Implement quality control to ensure data accuracy and completeness.
• Document and maintain SOPs for data management processes.
• Prioritise workload and manage projects with minimal supervision.
• Collaborate with IT and Data Governance on bulk data uploads for large projects.

Skills

Excel macros

PLM systems

Data governance

Analytical thinking

Cross-functional collaboration

Data migration

Oracle PLM

Education

Bachelor's degree in Information Systems/Business

Consumer products experience

SQL/databases

Tools

PLM systems

ERP systems

Data governance tools

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 standardise 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
• Prioritise workload to maximise 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 recognise 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

Work Environment

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

Physical Demands

Office Sedentary.

The Hillman Group is an Equal Employment Opportunity and Affi¬native Action Employer and will not discriminate against an applicant or employee on the basis of race, color, religion, creed, national origin or ancestry, sex, age, physical or mental disability, protected veteran or military status, genetic information, citizenship status, sexual orientation, gender identity, marital status, or any other legally recognised protected basis under federal, state or local laws, regulations or ordinances. The information collected by this application is solely to determine suitability for employment, verify identity and maintain employment statistics on applicants.