Data Validation Analyst - Peoria, United States - HarveyNash USA

Description

The main function of the BOM Analyst is to cleanse and validate Bill of material (BOM) data for Client 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 the BOM data was successfully transformed and stored.
• They will also use their knowledge of Client 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.

• The main function of the BOM Analyst is to cleanse and validate Bill of material (BOM) data for Client 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 the BOM data was successfully transformed and stored.
• They will also use their knowledge of Client 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.

• Write SQL queries to cleanse and transform historical Bill of Material data into a structured format.
• Validate that Bill of Material data is accurate and properly structured.
• Validate completeness of the Bill of material data. Knowledge of Client products and mechanical components will be necessary.
• Thorough knowledge of Client Inc.; its products and services

• Team of 23 folks, occasionally including someone who works in ACM/ coding.

• Hybrid model

• Bachelor's Degree with 24 years' experience.
• Associates/ No college degree with a minimum of 6+ years of experience in this capacity.

• SQL experience (24 years at a minimum).
• Experience with Client products.
• Ability to work independently and manage one's time.
• SQL, Snowflake
• Scripting experience in Perl, Python, R, or Regular expressions are bonus.
• Experience with product structure and engineering bill of materials
• Knowledge of Client products and components to validate the completeness of engineering bill of materials

• Verbal and written communication skills, problemsolving skills, customer service, and interpersonal skills.

• 5 years

• 8 hour shift
• Monday to Friday

• Bachelor's (preferred)

• Data management: 4 years (preferred)
• SQL: 4 years (preferred)
• Snowflake: 4 years (preferred)

• Automotive engineering: 1 year (preferred)
• Manufacturing engineering: 1 year (preferred)

• Peoria, IL required)

• Peoria, IL 61602: Relocate before starting work (required)