> Markdown version of [/jobs/ext/3089928-data-analyst](https://www.wearedevelopers.com/jobs/ext/3089928-data-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Analyst - **Company:** AMERICAN BATH LLC - **Location:** Houston, TX, United States - **Experience:** Experienced - **Salary:** $65,000.0 - $75,000.0 - **Contract:** Permanent contract - **Skills:** Microsoft Excel, Application Programming Interfaces (APIs), Big Data, Spreadsheets, Configuration Management, Data Architecture, Data Governance, Data Mapping, Data Transformation, Data Structures, Lookup Table, Minimum Data Set, Pivot Tables, Data Streaming, Systems Integration, Data Ingestion, Prophet, Epicor ERP, Tools for Reporting - **Published:** September 26, 2026 - **Apply:** https://www.thejobnetwork.com/job/cd478709-d4eb-4e87-bd3b-625ef7febec9/product-data-specialist ## About the Role * 2-5 years of experience in product data management, catalog management, or PIM administration in an e-commerce or distribution environment * Hands-on experience cleaning and normalizing large product catalogs (100,000+ SKUs) * Comfortable working with large data sets in spreadsheet, PIM, and reporting tools, including reading and interpreting reports built by others * Advanced Excel skills including pivot tables, VLOOKUP/INDEX-MATCH, and data transformation * Demonstrated ability to define data standards and enforce them across an organization * Experience working with ERP systems in a product data context (Epicor Prophet 21 experience is a strong plus) Required Experience * Experience in building materials, plumbing, kitchen, bath, or home improvement product lines * Experience with PIM platforms such as Akeneo, Salsify, Pimberly, or DDS Acadia * Familiarity with the structure and content of manufacturer data feeds (EDI 832/846, flat files) * Experience with product data syndication and SEO optimization for e-commerce * Understanding of variant/configuration management for products with multiple finishes, sizes, or options * Experience supporting ERP migrations or major system transitions from a data perspective Who You Are * You are obsessive about data quality and consistency - inconsistent finish names keep you up at night * You can zoom out to design a data architecture and zoom in to manually fix a product record * You communicate clearly with both technical and non-technical stakeholders * You are self-directed and can manage a multi-month project without constant oversight * You understand that product data is not just an IT problem - it directly impacts sales, customer experience, and operational efficiency, * 2-5 years of experience in product data management, catalog management, or PIM administration in an e-commerce or distribution environment * Hands-on experience cleaning and normalizing large product catalogs (100,000+ SKUs) * Comfortable working with large data sets in spreadsheet, PIM, and reporting tools, including reading and interpreting reports built by others * Advanced Excel skills including pivot tables, VLOOKUP/INDEX-MATCH, and data transformation * Demonstrated ability to define data standards and enforce them across an organization * Experience working with ERP systems in a product data context (Epicor Prophet 21 experience is a strong plus) ## 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 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., * 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 that tracks them * 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 Cross-Functional Collaboration * Work with the Ecommerce Director to ensure product data supports SEO strategy, site search, and filtering * Work with the ERP Admin to ensure data structures, workflows, and integrations support clean data flow between the ERP and the website * Guide 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 ## Related Videos - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) - [Empowering Retail Through Applied Machine Learning](https://www.wearedevelopers.com/videos/976-empowering-retail-through-applied-machine-learning) - [Why and when should we consider Stream Processing frameworks in our solutions](https://www.wearedevelopers.com/videos/1085-why-and-when-should-we-consider-stream-processing-frameworks-in-our-solutions) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany) - [Now is the time for industrialized software development](https://www.wearedevelopers.com/magazine/601-now-is-the-time-for-industrialized-software-development)