Product Data Specialist

Mcnaughton-mckay Electric Co; Columbus (OH); On-site; USD 80,000 - 110,000; Full time

Job summary

McNaughton McKay Group is seeking a Product Data Specialist to oversee the PIM platform (Stibo STEP) and data pipelines, partnering with the Product Data Manager to optimize workflows and ensure data quality across ERP and ecommerce channels.

You will maintain runbooks and documentation, triage data issues, and support platform initiatives, with emphasis on accuracy, process improvement, and cross-functional collaboration.

Qualifications

• Bachelor’s degree in a related field with 3–5 years in data operations, analytics, or related discipline; equivalence considered.
• Proficiency in Alteryx Designer for building and validating data workflows; strong scheduling and validation skills.
• Experience in a PIM/MDM platform; familiarity with Stibo STEP is a strong plus.
• Solid SQL skills for reading, writing, and troubleshooting queries and validating pipeline outputs.
• Understanding of programming concepts in Java and JavaScript; scripting for platform configuration and integration troubleshooting.
• Awareness of how master data relates to sales, purchasing, and ecommerce reporting.
• Interest in AI-powered tools to improve data workflows and problem-solving; willingness to adopt new tech.
• Proficiency in Excel for data review and validation; familiarity with AI-assisted tools is a plus.
• Attention to detail; ability to identify data anomalies in large datasets; strong documentation habits.

Responsibilities

• Monitor PIM and Alteryx workflow outputs to identify anomalies and data quality issues.
• Maintain documentation and version control for automation library and runbooks.
• Coordinate rollout of platform initiatives, including testing and validation with external integrator.
• Triage service desk tickets related to PIM data and ERP attributes; resolve or escalate.
• Perform data quality tasks: enrichment review, classification gap identification, remediation flagging.
• Assist taxonomy maintenance and attribute schema updates per direction.
• Support onboarding of new product data into the PIM platform with mapping and validation.
• Document data standards with cross-functional teams and support process improvements.
• Test applications during STEP upgrades and ongoing development initiatives.

Skills

Alteryx Designer

Stibo STEP

SQL

PIM/MDM

Java/ JavaScript basics

XML

FTP transfers

Linux

Data governance

Data enrichment

Excel

Documentation

Problem solving

Education

Bachelor’s degree in related field

Tools

Stibo STEP

Alteryx Designer

ERP systems

Job description

Job Details

Job Location: Madison Heights, MI - 1357 E. Lincoln Ave - Madison Heights, MI 48071
Position Type: Full Time
Job Category: Information Technology
Product Data Specialist

About McNaughton McKay Group

McNaughton McKay Group (MMG) is a 100% employee-owned distributor of electrical and PVF (pipes, valves, and fittings) solutions, serving the industrial, commercial and construction markets.Our portfolio of trusted brands operates from more than 60 branches across nine states and Germany. At MMG, we do more than deliver products. We build lasting partnerships—backed by deep inventory and local expertise—to keep your projects moving and businesses growing. Our empowered team provides the support, insight and scalable solutions needed to navigate today’s demands and solve our customers’ most complex challenges.

Role Purpose

This position supports the architecture and day-to-day orchestration of the company’s Product Information Management (PIM) platform (Stibo STEP) and related data pipelines. The role serves as an operational partner to the Product Data Manager, helping monitor automated workflows and suggesting and implementing improvements to optimize them for efficiency, maintaining documentation and version control, triaging incoming data quality issues, and supporting the rollout of new platform initiatives. The position requires familiarity with data workflows, automation tooling (particularly Alteryx), and the operational systems the PIM platform connects to, including the ERP and ecommerce channel.

As a Product Data Specialist, you will:

• Monitor automated PIM and Alteryx workflow outputs; identify and expedite anomalies, failures, or data quality exceptions requiring expert resolution.
• Maintain documentation and version control for the Alteryx and Stibo STEP automation library, including workflow change logs, process guides, and runbooks.
• Support rollout of new platform initiatives, including testing, validation, and coordination with the external integrator under direction of the Product Data Manager.
• Perform first-level triage on service desk tickets related to PIM data, ecommerce product content, and ERP product attributes; resolve or elevate appropriately.
• Execute defined data quality improvement tasks: reviewing enrichment output, identifying classification gaps, and flagging records for remediation.
• Assist with taxonomy maintenance, attribute schema updates, and category-level data standards as directed.
• Contribute to the enrichment and publishing pipeline for standard catalog products, supporting match rate improvements against IDEA and Affiliated Distributors aggregator feeds.
• Support onboarding of new product data into the PIM platform, including data mapping, validation, and workflow testing.
• Collaborate with the Product Data Manager and cross-functional stakeholders to document data standards and support process improvement efforts.
• Perform application testing during Stibo STEP upgrades and ongoing development initiatives.

Desired Knowledge/Skills/Abilities Include:

• Bachelor’s degree in a related field plus 3–5 years of professional experience in data operations, data analytics, or a related discipline. Equivalent experience considered in lieu of degree.
• Proficiency in Alteryx Designer for building, running, and maintaining data workflows. Hands‑on experience with workflow scheduling, data blending, and output validation.
• Experience in a PIM or MDM platform in a professional setting — managing product data, taxonomy, enrichment workflows, or data governance. Experience with Stibo STEP specifically is a strong plus.
• Solid understanding of relational database concepts and SQL — comfortable reading, writing, and troubleshooting queries involving joins, filtering, aggregation, and subqueries. Ability to use SQL to investigate data issues and validate pipeline outputs independently.
• Understanding of programming and scripting concepts, particularly Java and JavaScript, is a plus. Familiarity with these languages supports platform configuration, workflow scripting, and integration troubleshooting within enterprise data environments like Stibo STEP.
• Understanding of how master data (product, customer, supplier) relates to sales, purchasing, ecommerce, and operational reporting.
• Demonstrated interest in adopting new technologies and AI-powered tools to improve how work gets done — whether independently or collaboratively. Candidates who actively use or are curious about emerging tools for data work, problem-solving, and workflow automation are strongly preferred.
• Proficiency in Microsoft Excel or equivalent tools for data review and validation; familiarity with AI-assisted alternatives is a plus.
• Strong attention to detail; ability to identify data anomalies and inconsistencies within large datasets.
• Strong organizational skills with a consistent habit of maintaining clean, up-to-date documentation — process guides, workflow logs, change records, and runbooks.
• Ability to work independently on defined tasks, manage competing priorities, and communicate proactively when blockers arise.
• Experience with XML and FTP file transfers preferred. Working knowledge of Linux operating systems a plus, particularly in relation to server‑side data operations and digital asset workflows.

Reporting Structure

Reports To: Product Data Manager

Direct Reports: None

Working Conditions

Normal office environment; occasional after-hours work may be required during platform updates or initiative rollouts.

EEO/AA/M/F/Vet/Disability Employer

The above statements are intended to describe the essential functions and related requirements of persons assigned to this job. They are not intended as an exhaustive list of all job duties, responsibilities and requirements.