Technical Business Systems Analyst at VTAL TECHNOLOGY SOLUTIONS LLC

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.