Masco Corporation Product Information Analyst in Middlefield, Ohio
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.
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
Product Information Analyst
Full or Part Time:
State / Province:
Masco Cabinetry is an Affirmative Action and Equal Opportunity Employer
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: English , Spanish
Masco Cabinetry is an equal opportunity employer. Applicants are considered for all positions without regard to race, color, religion, sex, sexual orientation, protected status as a veteran, national origin, age, disability, genetic information, gender identity, or any other legally protected status under federal, state or local law.