Product Information Analyst in Middlefield at Masco Cabinetry

Date Posted: 6/10/2018

Job Snapshot

Job Description

Masco Cabinetry has an immediate opening for a Product Information Analyst at our facility in Middlefield, OH!


Masco Cabinetry manufactures three nationally recognized cabinetry brands, KraftMaid®, Merillat® and QualityCabinets®. Offering an unmatched selection of stylish, high-quality products at a variety of price levels, Masco Cabinetry brands are favored by builders, dealers, distributors and home centers throughout North America. A leader in environmental stewardship, Masco Cabinetry products have been granted an Environmental Stewardship Program certificate by the Kitchen Cabinet Manufacturers Association.


JOB SUMMARY:

Responsible for creating and maintaining product information and bills of material in computer systems. Analyzes bill of material structure for accuracy and completeness in accordance with product standards, procedures, and engineering requirements.


PRINCIPAL FUNCTIONAL RESPONSIBILITIES:

  • Manipulate and analyze large volumes of tabulated data in Excel using complex formulas to construct and setup new and alter current bills of material (BOM) in Unidata ERP system
  • Apply judgment to corrections to determine priority and timing of data changes.
  • Analyze engineering drawings or excel part listings
  • Modify and run queries to support various research or inquiries.
  • Analyze query results to monitor data integrity and validate setup in the system(s).
  • Research/troubleshoot change requests or error notifications received for modification, validation and/or creation in system.
  • Proactively make changes to BOMs and other data based on research from non-related change requests.
  • Provide data creation and troubleshooting support for new product development process and manufacturing.
  • Leverage technology such as macro recorders and automated data loaders to increase efficiency in data entry and corrections.
  • Create process documents, Standard Operating Procedures and strive to improve existing processes

ESSENTIAL QUALIFICATIONS AND SKILLS:

  • High School Diploma
  • Familiarity with the cabinet industry and products
  • Ability to perform analytical root/cause analysis
  • Ability to manipulate large volumes of data in Excel using complex formulas with a high accuracy rating, and strong attention to detail
  • Intermediate proficiency with Microsoft Office Suite
  • Demonstrated successful ability to build positive partnerships and work collaboratively with cross-functional business teams
  • Demonstrated successful ability to prioritize and multi-task various and conflicting responsibilities
  • Excellent problem solving, critical thinking and decision making skills
  • Excellent verbal and written communication skills with the ability to interact with internal customers
  • Ability to function at a high level of effectiveness, flexibility, independence and initiative without daily interaction with management

PREFERRED QUALIFICATIONS AND SKILLS:

  • Bachelor’s degree in business, information systems or related field or equivalent experience
  • Prior SQL or equivalent query writing experience
  • Ability to read and understand engineering drawings