Product Data Manager

Company Description

Baths of America is a Houston-based bath and kitchen business operating a showroom and distribution center. We carry appliances, plumbing fixtures, door hardware, cabinet hardware, and cabinets from approximately 300 brands, with an e-commerce catalog of 2.5 million product listings. We are growing and investing in our digital infrastructure to deliver the best possible experience for our customers and trade partners.

Role Description

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 E-Commerce Director manages the website, and our NetSuite Admin builds workflows and manages the ERP. What we are missing is someone who owns the product date 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.

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
• Own the translation of business and operations needs into structured data specifications
• Document requirements, define acceptance criteria, and maintain clear data contracts before any system change or import enters development
• Design and maintain the product data schema, including table structure, naming conventions, and indexing strategy
• Write and optimize complex SQL queries

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
• Build and execute normalization processes using a combination of scripting and manual review
• Identify and resolve duplicate items, orphan variants, and incorrect parent-child relationships
• Cross-reference NetSuite product records against the live website to identify and fix discrepancies

Manufacturer Data Relationships

• Obtain and integrate product data feeds (EDI, API, flat files) from key brand partners such as Brizo, Hansgrohe, and other Tier 1 brands
• Serve as the primary point of contact for manufacturer data inquires and spec sheet sourcing
• 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
• Build and maintain a data quality dashboard tracking completeness, consistency, and freshness metrics
• Run quarterly catalog audits and report on data health to leadership
• Create and maintain documentation and playbooks so the Data Analyst can execute day-to-day maintenance within your framework
• Establish a reputable testing protocol after every data import, including field-level validation checks, image integrity verification, pricing accuracy audits, and variant completeness reviews
• Document pass/fail criteria, maintain QA checklist, and escalate anomalies before data goes live

Cross-Functional Collaboration

• Work with the Ecommerce Director to ensure product data supports SEO strategy, site searching, and filtering
• Work with the NetSuite Admin to ensure data structures, workflows, and integrations support clean data flow between the ERP and the website
• Direct the Data Analyst's day-to-day catalog work, providing standards, priorities, and quality review
• Coordinate with the sales team to understand which product attributes drive customer purchasing decision and trade partner requirements
• Support the ERP evaluation process by defining product data migration requirements and testing data mapping in any new system