Product Data Specialist

Full-Time | Houston, TX | On-Site

About the role

We have a large, complex product catalog and a small, capable e-commerce and IT team. Today, our Data Analyst handles scripted cleanup and pricing updates, our Ecommerce Director manages the website, and our Office Manager is the subject matter expert on product inside the ERP. What we are missing is someone who owns the product data itself: the person who defines what clean, complete, and consistent data looks like for our catalog, and who is accountable for getting it there and keeping it there. This role is the single point of ownership for our entire product data ecosystem. You will be the bridge between our ERP, our website, and our internal teams, ensuring that the 2.5 million items in our catalog are accurate, well-structured, and optimized for both customer experience and search visibility.

Responsibilities

• Define and enforce the canonical product data model: required fields, naming conventions, variant attribute standards, and category taxonomy across all 300 brands
• Create and maintain the master variant attribute mapping (e.g., consolidating hundreds of inconsistent finish names into a standardized set of canonical values)
• Establish minimum data quality thresholds for product pages to remain published on the website
• Lead the end-to-end data cleanup project across 300,000 parent items and 2.2 million variants, starting with our 50 actively sold brands and expanding to traffic-only brands
• Audit the existing catalog to quantify data quality issues by type, brand, and severity
• Work with the team to define normalization rules, mapping tables, and review criteria that all cleanup work follows, and approve the results before they publish
• Identify and resolve duplicate items, orphan variants, and incorrect parent-child relationships
• Cross-reference ERP product records against the live website to identify and fix discrepancies
• Define the required fields, formats, and image specifications that manufacturer data feeds (EDI, API, flat files) must meet before they are accepted into the catalog
• Evaluate and recommend product data syndication tools or PIM platforms to automate ongoing data ingestion
• Own the new product intake process: every item