Product Data Manager

Ontario Trillium Foundation; Minnesota; On-site; USD 90,000 - 120,000; Full time

Job summary

Ontario Trillium Foundation seeks a Product Data Manager to own data standards for a vast product catalog and to act as the bridge between ERP, website, manufacturers, and internal teams. You will define canonical data models, enforce quality thresholds, and translate business needs into structured data specifications.

You will lead data cleanup across hundreds of brands, establish data contracts, and drive governance processes to ensure accurate, searchable product information across platforms.

Qualifications

• Own the canonical product data model: required fields, naming conventions, and taxonomy.
• Define data quality thresholds for product pages to stay published.
• Translate business needs into structured data specifications for systems.

Responsibilities

• Own the product data ecosystem from ERP to website, ensuring 2.5 million items are accurate and optimized.
• Lead end-to-end catalog cleanup across brands and variants, with data quality audits.
• Define and maintain data contracts and QA processes before imports or changes.

Skills

Data governance

SQL queries

Data modeling

Master data management

ERP integration

Catalog management

Education

MIS degree

Tools

NetSuite

Excel

API

Job description

Product Data Manager

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 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 & 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 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 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 inquiries 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 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 elevate anomalies before data goes live.

Cross‑Functional Collaboration

• Work with the Ecommerce Director to ensure product data supports SEO strategy, site search, 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 decisions and trade partner requirements
• Support the ERP evaluation process by defining product data migration requirements and testing data mapping in any new system

Degree in Management Information Systems (MIS) preferred.