Description:

• The main function of the BOM Analyst is to cleanse and validate Bill of material (BOM) data for the client's 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 As-Built 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 one's 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:

• Bachelor's Degree with 5-7 years' experience.
• Associates/ No college degree with a minimum of 9 years of experience in this capacity.

Travel: none

location: Peoria, Illinois
job type: Contract
salary: $48 - 49 per hour
work hours: 8am to 5pm
education: Bachelors

responsibilities:

Description:

• The main function of the BOM Analyst is to cleanse and validate Bill of material (BOM) data for the client's 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 As-Built BOM manager to determine the proper methods to achieve results.

• Experience level: Experienced
• Minimum 5 years of experience
• Education: Bachelors (required)