Bill of Material BOM Analyst 3

Description:

• The main function of the BOM Analyst is to cleanse and validate Bill of material (BOM) data for the clients Products.
• The BOM analyst will use SQL in a Snowflake database to retrieve historical BOM data and transform it into an established structure.
• This will require strong SQL skills and occasional use of script languages and regular expressions.
• The analyst will also validate that they BOM data was successfully transformed and stored.
• They will also use their knowledge of Products and mechanical components to validate the completeness of BOM Data.
• The BOM Analyst will work with the AsBuilt BOM manager to determine the proper methods to achieve results.

Typical Day:

• Write SQL queries to cleanse and transform historical Bill of Material data into a structured format.
• Validate Bill of Material data is accurate and properly structured.
• Validate completeness of Bill of material data. Knowledge of products and mechanical components will be necessary.

Technical Skills Required:

• SQL experience (5 years at a minimum).
• Experience with client products.
• Ability to work independently and manage ones time.
• SQL Snowflake
• Scripting experience in Perl Python R or Regular expressions are bonuses.
• Experience with product structure and engineering bill of materials
• Knowledge of client products and components to validate the completeness of engineering bill of materials

Soft Skills Required:

• Verbal and written communication skills problem solving skills customer service and interpersonal skills.

Education Requirements:

• Bachelors Degree with 57 years experience.
• Associates/ No college degree with a minimum of 9 years of experience in this capacity.

Travel: none