Bill of Material Analyst - Peoria, United States - optime-tech LLC

optime-tech LLC
optime-tech LLC
Verified Company
Peoria, United States

2 weeks ago

Mark Lane

Posted by:

Mark Lane

beBee recruiter
Description

Bill of Material (BOM) Analyst 3
Peoria, IL (
HYBRID)

12+ Months Contract


Primary Skills:
Snowflake, Business Analysis, Python, SQL


Description:


The main function of the BOM Analyst is to cleanse and validate Bill of material (BOM) data for the client's 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 (5 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 bonuses.

Experience with product structure and engineering bill of materials

Knowledge of client 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 5-7 years' experience.

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


Job Type:
Contract


Pay:
$ $37.00 per hour


Application Question(s):

  • Do you have experience working on Bill of material (BOM) data?
  • Do you have experience with product structure and engineering bill of materials?

Experience:


  • Snowflake: 5 years (required)
  • SQL: 5 years (required)
- python: 5 years (preferred)


  • Scripting: 5 years (preferred)

Ability to Commute:

  • Peoria, IL (required)

Work Location:
In person
More jobs from optime-tech LLC
See all jobs of optime-tech LLC