Description:

• The main function of the BOM Analyst is to cleanse and validate Bill of material (BOM) data for 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 (2-4 years at a minimum).
• 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 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 2-4 years’ experience.
• Associates/ No college degree with a minimum of 6 years of experience in this capacity.

Travel: None

Additional Details :

Projected Start Date : 2024-06-03T00:00:00

Projected End Date : 2025-06-02T00:00:00

Client Company : Caterpillar Inc. / AGS / IQ Navigator

Vendor Pay Rate : 37

Selling points for candidate :

Face to face interview required : No

Candidate must be authorized to work without sponsorship : No

Background Check : No

Drug Screen : No