Job Posting for BOM Analyst at Harvey Nash
Job 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.
Position’s Contributions to Work Group:
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.
Typical task breakdown:
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
Interaction with team:
Team of 2-3 folks, occasionally including someone who works in ACM/ coding.
Work environment:
Education & Experience Required:
Bachelor’s Degree with 2-4 years’ experience.
Associates/ No college degree with a minimum of 6 years of experience in this capacity.
Technical Skills
(Required)
SQL experience (2-4 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
Soft Skills
(Required)
Verbal and written communication skills, problem-solving skills, customer service, and interpersonal skills.
Job Types: Full-time, Contract
Pay: $26.70 - $41.16 per hour
Expected hours: 40 per week
Benefits:
401(k)
Dental insurance
Health insurance
Experience level:
Schedule:
8 hour shift
Monday to Friday
Education:
Experience:
SQL: 4 years (Preferred)
validate Bill of material (BOM) data: 3 years (Preferred)
Snowflake: 3 years (Preferred)
Bill of material data: 3 years (Preferred)
Ability to Commute:
Peoria, IL 61602 (Preferred)
Ability to Relocate:
Peoria, IL 61602: Relocate before starting work (Required)
Work Location: In person
View More
Apply for this job
Receive alerts for other BOM Analyst job openings
Report this Job