Product Information Analyst in Middlefield, OH at Masco Cabinetry

Date Posted: 8/12/2019

Job Snapshot

Job Description

Job Description

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

Masco Cabinetry manufactures five nationally recognized cabinetry brands, KraftMaid®, Merillat®, QualityCabinets®, Cardell Cabinetry®, and One Two One Cabinetry®.  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.

Shift

Shift 1 (United States of America)

Full or Part Time

Full time

Masco Cabinetry (the “Company”) is an equal opportunity employer and we want to have the best available persons in every job. The Company makes employment decisions only based on merit. It is the Company’s policy to prohibit discrimination in any employment opportunity (including but not limited to recruitment, employment, promotion, salary increases, benefits, termination and all other terms and conditions of employment) based on race, color, sex, sexual orientation, gender, gender identity, gender expression, genetic information, pregnancy, religious creed, national origin, ancestry, age, physical/mental disability, medical condition, marital/domestic partner status, military and veteran status, height, weight or any other such characteristic protected by federal, state or local law. The Company is committed to complying with all applicable laws providing equal employment opportunities. This commitment applies to all persons involved in the operations of the Company regardless of where the employee is located and prohibits unlawful discrimination by any employee of the Company.

Masco Cabinetry is an E-Verify employer. E-Verify is an Internet based system operated by the Department of Homeland Security (DHS) in partnership with the Social Security Administration (SSA) that allows participating employers to electronically verify the employment eligibility of their newly hired employees in the United States. Please click on the following links for more information.

E-Verify Participation Poster: English & Spanish


E-verify Right to Work Poster: EnglishSpanish

No visa sponsorship is available for this position, unless specified within the job description.