Product Data ManagerWe 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 NetSuite Admin builds workflows and manages 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, our manufacturers, 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.Data Standards & ArchitectureDefine and enforce the canonical product data model: required fields, naming conventions, variant attribute standards, and category taxonomy across all 300 brandsCreate 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 websiteOwn the translation of business and operational 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 brandsAudit the existing catalog to quantify data quality issues by type, brand, and severityBuild and execute normalization processes using a combination of scripting and manual reviewIdentify and resolve duplicate items, orphan variants, and incorrect parent-child relationshipsCross-reference NetSuite product records against the live website to identify and fix discrepanciesManufacturer Data RelationshipsObtain and integrate product data feeds (EDI, API, flat files) from key brand partners such as Brizo, Hansgrohe, and other Tier 1 brandsServe as the primary point of contact for manufacturer data inquiries and spec sheet sourcingEvaluate and recommend product data syndication tools or PIM platforms to automate ongoing data ingestionOngoing Data GovernanceOwn the new product intake process: every item that enters the catalog meets your standards before it goes liveBuild and maintain a data quality dashboard tracking completeness, consistency, and freshness metricsRun quarterly catalog audits and report on data health to leadershipCreate and maintain documentation and playbooks so the Data Analyst can execute day-to-day maintenance within your frameworkEstablish a repeatable 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 a QA checklist, and escalate anomalies before data goes live.Cross-Functional CollaborationWork with the Ecommerce Director to ensure product data supports SEO strategy, site search, and filteringWork with the NetSuite Admin to ensure data structures, workflows, and integrations support clean data flow between the ERP and the websiteDirect the Data Analyst's day-to-day catalog work, providing standards, priorities, and quality reviewCoordinate with the sales team to understand which product attributes drive customer purchasing decisions and trade partner requirementsSupport the ERP evaluation process by defining product data migration requirements and testing data mapping in any new systemDegree in Management Information Systems (MIS) preferred.How to applySend your resume and a brief note describing the largest product catalog you have managed and what you did to improve its data quality.Requirements3-7 years of experience in product data management, catalog management, or PIM administration in an e-commerce or distribution environmentHands-on experience cleaning and normalizing large product catalogs (100,000+ SKUs)Proficiency in SQL for data querying and analysisAdvanced Excel skills including pivot tables, VLOOKUP/INDEX-MATCH, and data transformationExperience with scripting for bulk data operations (Python, JavaScript, or similar)Demonstrated ability to define data standards and enforce them across an organizationExperience working with ERP systems in a product data context (NetSuite experience is a strong plus)Company InformationBaths 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.