Bill of Material - Peoria, United States - Velocity Tech Inc
2 weeks ago
Description
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.
Typical Day:
- 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.
Technical Skills Required:
- SQL experience (24 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 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.
Education Requirements:
- Bachelor's Degree with 24 years' experience.
- Associates/ No college degree with a minimum of 6+ years of experience in this capacity.
Job Types:
Full-time, Contract
Pay:
$ $21.26 per hour
Benefits:
- 401(k)
- 401(k)
- Dental insurance
- Health insurance
- Life insurance
- Paid time off
- Vision insurance
Schedule:
- 8 hour shift
Experience:
- Python: 6 years (preferred)
- SQL: 7 years (preferred)
- BOM: 5 years (preferred)
Work Location:
On the road
More jobs from Velocity Tech Inc
-
Wordpress/php Developer
Bolton, United States - 1 week ago
-
Lan Analyst
East Peoria, United States - 1 week ago
-
Waterworks Superintendent
Sacramento, United States - 2 weeks ago
-
Production Operator
Austin, United States - 4 days ago
-
Machine Learning/data Scientist
Hoboken, United States - 2 weeks ago
-
Configuration Management Specialist
Augusta, United States - 2 weeks ago