Bill of Materials Analyst - 12-Month W2 Contract - HYBRID in Peoria

NO CORP TO CORP

Job 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.

Position’s Contributions to Work Group:

The main function of the BOM Analyst is to cleanse and validate Bill of material (BOM) data for Cat 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 task breakdown:

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.
Thorough knowledge of Caterpillar Inc.; its products and services

Interaction with team:

Team of 2-3, occasionally including someone who works in ACM/coding.

Work environment:

Hybrid model

Education & Experience Required:

Bachelor’s Degree with 2-4 years’ experience.
Associates/ No college degree with a minimum of 6+ years of experience in this capacity.

Technical Skills

(Required)

SQL experience (2-4 years at a minimum).
Experience with CAT 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 Cat 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.

Disqualifiers/Red Flags:

If the candidate’s location is not listed on the resume, the candidate will be DQ.
If the candidate does not currently reside in the Peoria, IL area but will relocate at their own expense, make sure to list that on the resume or they will be DQ.
If candidate resume contains choppy tenure ( 1 year of less) without listening if it was project only role, they will not be considered.

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is required to use hands and fingers, reach, climb stairs, walk, sit for prolonged periods of time, talk, and hear. The employee must occasionally lift and/or move up to twenty-five pounds.

Data Analyst Jobs in Peoria, IL

Technical Data AnalystMay 26, 2024

Data Analyst Cat DigitalMay 24, 2024

Business Data Analyst Aftermarket InsightsMay 19, 2024

Data Analyst Business AnalystMay 18, 2024

Data Analyst Business AnalystMay 14, 2024

Junior Data AnalystMay 12, 2024

Data AnalystMay 8, 2024

Quick filters

Top companies

Technical Data Analyst
May 26, 2024

Data Analyst Cat Digital
May 24, 2024

Business Data Analyst Aftermarket Insights
May 19, 2024

Data Analyst Business Analyst
May 18, 2024

Data Analyst Business Analyst
May 14, 2024

Junior Data Analyst
May 12, 2024

Data Analyst
May 8, 2024