Technical Business Systems Analyst

Seeking a Technical Business Systems Analyst to work on a contract role with a leading construction equipment company, in Peoria, IL.

Education & Experience Required: Bachelor's Degree with 5-7 years' experience.

Associates/ No college degree with a minimum of 9+ years of experience in this capacity.

Technical Skills (Required) SQL experience (5 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 Cat products and components to validate the completeness of engineering bill of materials.

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 Cat products and mechanical components will be necessary.

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

Soft Skills (Required) Verbal and written communication skills, problem solving skills, customer service and interpersonal skills.