Bill of Material

4 weeks ago


Peoria, Illinois, United States Randstad USA Full time
job summary:
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 (2-4 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 2-4 years' experience.

Associates/ No college degree with a minimum of 6+ years of experience in this capacity. Travel: None

location: Peoria, Illinois
job type: Contract
salary: $ per hour
work hours: 8am to 5pm
education: Bachelors

responsibilities:
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.
qualifications:
Experience level: ExperiencedMinimum 2 years of experienceEducation: Bachelors (required)
skills: SQL (2 years of experience is required)Snowflake (2 years of experience is required)PerlPythonRBusiness Analysis (2 years of experience is required)

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact

Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).

Applications accepted on ongoing basis until filled.


  • Bill of Material

    4 weeks ago


    Peoria, Illinois, United States Randstad USA Full time

    job summary: 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...

  • Bill of Material

    1 month ago


    Peoria, Illinois, United States Randstad USA Full time

    job summary: 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...


  • Peoria, Illinois, United States Goodwill Industries of Central Illinois, Inc. Full time

    Summary The Material Handler is a member of the Retail team who is responsible for accepting donated items at the donation door and or drop off locations, as well as identifying and communicating to the customer items that cannot be accepted. Other primary duties include processing donated items which consists of sorting, tagging, and hanging donated items....

  • Shop Clerk

    4 weeks ago


    Peoria, Illinois, United States Komatsu Full time

    Komatsu is an indispensable partner to the construction, mining, forestry, forklift, and industrial machinery markets, maximizing value for customers through innovative solutions. With a diverse line of products supported by our advanced IoT technologies, regional distribution channels, and a global service network, we tap into the power of data and...

  • Shop Clerk

    1 month ago


    Peoria, Illinois, United States Komatsu Full time

    Komatsu is an indispensable partner to the construction, mining, forestry, forklift, and industrial machinery markets, maximizing value for customers through innovative solutions. With a diverse line of products supported by our advanced IoT technologies, regional distribution channels, and a global service network, we tap into the power of data and...

  • Compliance Auditor

    2 weeks ago


    Peoria, Illinois, United States OSF HealthCare Full time

    Overview Expected pay for this position is $ $38.66/hour. Actual pay will be determined by experience, skills and internal equity. POSITION SUMMARY: The Compliance Auditor responds to suspected, reported or confirmed instances of non-compliance through audits and other activities to effectively meet the goals of the OSF compliance program. Works...

  • Research Chemist

    4 weeks ago


    Peoria, Illinois, United States Department Of Agriculture Full time

    Summary The Agricultural Research Service (ARS) is the United States Department of Agriculture's chief scientific research agency and one of the world's premiere scientific organizations. ARS Postdoctoral Research Associates are hired to supplement a lead scientist's research on agricultural problems of high national priority affecting American...

  • Research Chemist

    2 months ago


    Peoria, Illinois, United States Department Of Agriculture Full time

    Summary The Agricultural Research Service (ARS) is the United States Department of Agriculture's chief scientific research agency and one of the world's premiere scientific organizations. ARS Postdoctoral Research Associates are hired to supplement a lead scientist's research on agricultural problems of high national priority affecting American...

  • Research Chemist

    4 weeks ago


    Peoria, Illinois, United States Department Of Agriculture Full time

    Summary The Agricultural Research Service (ARS) is the United States Department of Agriculture's chief scientific research agency and one of the world's premiere scientific organizations. ARS Postdoctoral Research Associates are hired to supplement a lead scientist's research on agricultural problems of high national priority affecting American...

  • Research Chemist

    2 months ago


    Peoria, Illinois, United States Department Of Agriculture Full time

    Summary The Agricultural Research Service (ARS) is the United States Department of Agriculture's chief scientific research agency and one of the world's premiere scientific organizations. ARS Postdoctoral Research Associates are hired to supplement a lead scientist's research on agricultural problems of high national priority affecting American...

  • Ct Tech

    2 weeks ago


    Peoria, Illinois, United States Aureus Group Full time

    Job Description: The CT Technologist is responsible for performing computerized axial tomography procedures using different imaging equipment and contrast material following company policies and procedures.Essential Functions:Conducts computerized axial tomography procedures and specified invasive procedures by capturing and processing patient exams in...


  • Peoria, Illinois, United States Peoplelink Staffing Solutions Full time

    Painting & Shipping CoordinatorPeoplelink Staffing Solutions, in partnership with a prominent manufacturer in the Peoria, IL area, is seeking aPainting & Shipping Coordinator to join their team This is a great temp-to-hire opportunity that's full-time, day shift, Monday through Friday.Painting & Shipping Coordinator Job Summary:Pay: $20-25/hour (based on...


  • Peoria, Illinois, United States Komatsu Full time

    Komatsu is an indispensable partner to the construction, mining, forestry, forklift, and industrial machinery markets, maximizing value for customers through innovative solutions. With a diverse line of products supported by our advanced IoT technologies, regional distribution channels, and a global service network, we tap into the power of data and...


  • Peoria, Illinois, United States U.S. Army Corps Of Engineers Full time

    Engaged in construction and maintenance of shore protection and channel control work on the Illinois Waterway. Operate crawler-type equipment with wheeled or crawler-type traction; including material handlers, bulldozers, motor grades, tractors,pavement rollers, etc. Utilizes equipment to push and grade or load and relocate earth, riprap, gravel, or other...


  • Peoria, Illinois, United States Department Of Agriculture Full time

    Summary This position is located with the Agricultural Research Service, National Center for Agricultural Utilization Research, Peoria, Illinois.In this position you will support research in the Renewable Product Technology Research Unit. The overall mission of RPT is to develop technologies that employ a variety of chemical, microbial, biochemical, and...


  • Peoria, Illinois, United States Komatsu Full time

    Komatsu is an indispensable partner to the construction, mining, forestry, forklift, and industrial machinery markets, maximizing value for customers through innovative solutions. With a diverse line of products supported by our advanced IoT technologies, regional distribution channels, and a global service network, we tap into the power of data and...


  • Peoria, Illinois, United States City of Peoria, IL Full time

    Applications are required for each vacancy. Resumes may be attached but will not be accepted in lieu of applications. The application must be signed, dated, completely filled in and returned to the Human Resources Department by the filing date indicated on the Vacancy Announcement. All information submitted is subject to verification. The City only accepts...


  • Peoria, Illinois, United States City of Peoria, IL Full time

    If selected, City residency must be established within one year of hire (or within the timeframe outlined in bargaining unit contract, if applicable). Residency must be maintained for the duration of employment. Applicants need not be current residents of the City of Peoria to be considered. After an offer of employment but prior to hire, all applicants must...


  • East Peoria, Illinois, United States Advanced Technology Services (ATS) Full time

    Founded in 1985, ATS is a company with a presence in the United States, Mexico and the United Kingdom. We are professionals in Industrial Maintenance, and we make factories run better.Principal Duties/Responsibilities:To Live and Lead Safety· Manages the Site Safety Program and ensures all policies are being followed by employees· Drives housekeeping...


  • Peoria, United States optime-tech LLC Full time

    **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...

  • Bill of Material

    3 weeks ago


    Peoria, United States Velocity Tech Inc Full time

    **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...


  • Peoria, United States Goodwill Industries of Central Illinois, Inc. Full time

    Description Summary The Material Handler is a member of the Retail team who is responsible for accepting donated items at the donation door and or drop off locations, as well as identifying and communicating to the customer items that cannot be accepted. Other primary duties include processing donated items which consists of sorting, tagging, and hanging...


  • Peoria, United States Goodwill Industries of Central Illinois, Inc. Full time

    Description Summary The Material Handler is a member of the Retail team who is responsible for accepting donated items at the donation door and or drop off locations, as well as identifying and communicating to the customer items that cannot be accepted. Other primary duties include processing donated items which consists of sorting, tagging, and hanging...


  • Peoria, United States Goodwill Industries of Central Illinois, Inc. Full time

    Description Summary The Material Handler is a member of the Retail team who is responsible for accepting donated items at the donation door and or drop off locations, as well as identifying and communicating to the customer items that cannot be accepted. Other primary duties include processing donated items which consists of sorting, tagging, and hanging...


  • Peoria, United States Goodwill Industries of Central Illinois, Inc. Full time

    Description Summary The Material Handler is a member of the Retail team who is responsible for accepting donated items at the donation door and or drop off locations, as well as identifying and communicating to the customer items that cannot be accepted. Other primary duties include processing donated items which consists of sorting, tagging, and hanging...


  • Peoria, United States Nimble Byte Full time

    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) -...

  • Business Data Analyst

    3 weeks ago


    Peoria, United States Diversified Services Network Full time

    Diversified Services Network, Inc. (DSN) is seeking a full-time **Technical Business Systems Analyst **to join our team in **Peoria, IL! **We offer a **HYBRID** work model, full benefits, PTO, 401k, and more! If you're looking to grow your technical career within an extremely reputable, stable Fortune 500 company - let's talk! ** Manufacturing Background is...


  • East Peoria, United States Goodwill Industries of Central Illinois, Inc. Full time

    Description Summary The Material Handler is a member of the Retail team who is responsible for accepting donated items at the donation door and or drop off locations, as well as identifying and communicating to the customer items that cannot be accepted. Other primary duties include processing donated items which consists of sorting, tagging, and hanging...


  • Peoria, United States Eco Building Systems Full time

    **Responsibilities**: - Shipping Inventory count - Organize inventory - Prioritize orders going out - Bill of Lading’s - Driving a box truck to pick up and deliver materials (No CDL required) - Keep area organized/clean - Will be cross-trained on the factory floor - Filling out Bill of Lading’s - Create a system for shipping - Loading inventory on...

  • Warehouse Associate

    3 weeks ago


    Peoria, United States Eco Building Systems Full time

    **Responsibilities**: - Shipping Inventory count - Organize inventory - Prioritize orders going out - Bill of Lading’s - Driving a box truck to pick up and deliver materials (No CDL required) - Keep area organized/clean - Will be cross-trained on the factory floor - Filling out Bill of Lading’s - Create a system for shipping - Loading inventory on...

  • Warehouse Assistant

    3 weeks ago


    Peoria, United States Allied Instrumentation Full time

    Job DescriptionJob DescriptionJob SummaryThe Material Expeditor is responsible for monitoring the on-time delivery of materials to maximize customer on-time deliveries (OTD). You will identify gaps, manage/revise purchase order dates and consult with team members to determine solutions. Maintaining a clear and open line of communication is crucial in this...

  • Team Clerical

    3 weeks ago


    Peoria, United States State of Illinois Full time

    **DCFS is deeply committed to the welfare and protection of children. Our goal is to protect children by strengthening and supporting families. In every effort, from receiving hotline calls to reaching family reunification or foster care and adoption, children and families are our focus.** **Agency** : Department of Children and Family Services **Agency**...

  • Compliance Auditor

    4 weeks ago


    Peoria, United States OSF HealthCare Full time

    Overview: - Expected pay for this position is $32.87 - $38.66/hour. Actual pay will be determined by experience, skills and internal equity.***: The Compliance Auditor responds to suspected, reported or confirmed instances of non-compliance through audits and other activities to effectively meet the goals of the OSF compliance program. Works collaboratively...

  • Compliance Auditor

    2 months ago


    Peoria, United States OSF Healthcare Full time

    Overview Expected pay for this position is $32.87 - $38.66/hour. Actual pay will be determined by experience, skills and internal equity. POSITION SUMMARY: The Compliance Auditor responds to suspected, reported or confirmed instances of non-compliance through audits and other activities to effectively meet the goals of the OSF compliance program. Works...

  • Compliance Auditor

    4 weeks ago


    Peoria, United States OSF Healthcare Full time

    Overview Expected pay for this position is $32.87 - $38.66/hour. Actual pay will be determined by experience, skills and internal equity. POSITION SUMMARY: The Compliance Auditor responds to suspected, reported or confirmed instances of non-compliance through audits and other activities to effectively meet the goals of the OSF compliance program. Works...


  • Peoria, United States University of Illinois Full time

    **Reimbursement Coding Representative (UICOMP Pediatric Cardiology)** **Hiring Department**: Pediatrics **Location**: Peoria, IL USA **Requisition ID**: 1026001 **Posting Close Date**: July 2, 2024 **_ This position is located on the Peoria campus 170 miles southwest of Chicago. (On-Site Work - Not Remote)._** UIC is among the nation’s preeminent...

  • Shop Clerk

    1 month ago


    Peoria, United States Komatsu Full time

    Komatsu is an indispensable partner to the construction, mining, forestry, forklift, and industrial machinery markets, maximizing value for customers through innovative solutions. With a diverse line of products supported by our advanced IoT technologies, regional distribution channels, and a global service network, we tap into the power of data and...

  • Shop Clerk

    4 weeks ago


    Peoria, United States Komatsu Full time

    Komatsu is an indispensable partner to the construction, mining, forestry, forklift, and industrial machinery markets, maximizing value for customers through innovative solutions. With a diverse line of products supported by our advanced IoT technologies, regional distribution channels, and a global service network, we tap into the power of data and...

  • Team Clerical

    3 weeks ago


    Peoria, United States Illinois Department of Children and Family Services Full time

    Location: Peoria, IL, US, 61603 Job Requisition ID: 37006 **DCFS is deeply committed to the welfare and protection of children. Our goal is to protect children by strengthening and supporting families. In every effort, from receiving hotline calls to reaching family reunification or foster care and adoption, children and families are our...