Job Title:

Product Data Specialist (E-Commerce / PIM)

Location:

Houston, TX (On-Site)

Pay:

$65,000-$75,000/year, based on experience

Job Type:

Full-time Job Description:

We're a growing Houston-based bath and kitchen business with a showroom and distribution center. We carry appliances, plumbing fixtures, door and cabinet hardware, and cabinets from about 300 brands, and our e-commerce catalog has 2.5 million product listings. We're investing in our digital infrastructure and need someone to own our product data. In this role, you're the single point of ownership for the entire product catalog. You'll connect our ERP, our website and our internal teams, and make sure every item is accurate, well-structured and optimized for both customers and search. You'll report to the Office Manager and work closely with our Data Analyst and Ecommerce Director. What You'll Own Data Standards & Architecture Define and enforce the product data model, including required fields, naming conventions, variant attributes and category taxonomy across all 300 brands Build and maintain a master variant attribute mapping (for example, consolidating hundreds of inconsistent finish names into one standard set) Set minimum data quality thresholds a product page must meet to stay published Catalog Cleanup (Initial Project) Lead a cleanup of 300,000 parent items and 2.2 million variants, starting with our 50 actively sold brands Audit the catalog and quantify issues by type, brand and severity Define normalization rules, mapping tables and review criteria, and approve results before they publish Resolve duplicates, orphan variants and incorrect parent-child relationships Cross-check ERP records against the live website and fix discrepancies Manufacturer Data & Governance Set the standards (fields, formats, image specs) that manufacturer feeds (EDI, API, flat files) must meet before they enter the catalog Evaluate and recommend PIM or data syndication tools Own the new product intake process Define data quality metrics, run quarterly audits and report catalog health to leadership Write documentation and playbooks for day-to-day catalog maintenance Cross-Functional Collaboration Partner with the Ecommerce Director so product data supports SEO, site search and filtering Work with the ERP Admin on data structures, workflows and integrations Guide the Data Analyst's daily catalog work Learn from the sales team which attributes drive buying decisions Define data migration requirements for future ERP evaluations What You Bring 2-5 years in product data management, catalog management or PIM administration in an e-commerce or distribution environment Hands-on experience cleaning and normalizing large catalogs (100,000+ SKUs) Advanced Excel skills, including pivot tables, VLOOKUP/INDEX-MATCH and data transformation Comfort working with large data sets and reports in spreadsheet, PIM and reporting tools A track record of defining data standards and enforcing them across an organization ERP experience in a product data context (Epicor Prophet 21 is a strong plus) Nice to Have Experience with building materials, plumbing, kitchen, bath or home improvement product lines PIM platforms such as Akeneo, Salsify, Pimberly or DDS Acadia Familiarity with manufacturer data feeds (EDI 832/846, flat files) Product data syndication and e-commerce SEO experience Variant and configuration management for products with multiple finishes, sizes or options Experience supporting ERP migrations from a data perspective Who You Are Obsessed with data quality: inconsistent finish names keep you up at night Able to design a data architecture and also fix a single product record by hand A clear communicator with technical and non-technical people Self-directed, able to run a multi-month project without constant oversight Aware that product data drives sales and customer experience, not just IT What Success Looks Like 30 days: Full catalog audit done, key data needs gathered from sales and operations, and current data flows documented 90 days: Data model, naming guide and variant master list proposed; all brands tiered; cleanup of the top 10 brands underway; manufacturer data requirements published 6 months: All 50 active brands cleaned up, variant normalization done across the catalog, new intake process live, and data quality dashboards in place Benefits 401(k) with 4% match Medical, dental and vision 2+ weeks PTO based on tenure

Pay:

$65,000.00 - $75,000.00 per year

Benefits:

Dental insurance Health insurance Vision insurance Application Question(s): Add a short note describing the largest product catalog you've managed and what you did to improve its data.

Work Location:

In person