PeoriaILRecruiter Since 2001
the smart solution for Peoria jobs

Technical Business Systems Analyst

Location: Peoria
Posted on: May 11, 2024

Job Description:

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.

Keywords: VTAL TECHNOLOGY SOLUTIONS LLC, Peoria , Technical Business Systems Analyst, IT / Software / Systems , Peoria, Illinois

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest Illinois jobs by following @recnetIL on Twitter!

Peoria RSS job feeds