Product Data Specialist
Full-Time | Houston, TX | On-Site
WHY THIS ROLE EXISTS
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.
WHAT YOU WILL OWN
Data Standards & Architecture
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
Catalog Cleanup & Normalization (Initial Project)
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
Manufacturer Data Standards
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
Ongoing Data Governance
Own the new product intake process: every item that enters the catalog meets your standards before it goes live
Define the completeness, consistency, and freshness metrics the catalog is measured against, and own the reporting tha