Bill of Material Analyst

3 weeks ago


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 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: $29.67 - $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


  • Bill of Material

    1 week 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...

  • Bill of Material

    1 week 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, United States Medix™ Full time

    Position Summary:The Clinical Research Billing (CRB) Analyst coordinates and executes the financial billing of clinical trials. The analyst is responsible for compilation of statistical, fiscal and metric data as it relates to clinical trial activities. The CRB Analyst also assists with clinical trial billing special projects, ensures timely invoicing,...


  • Peoria, United States Medix™ Full time

    Position Summary:The Clinical Research Billing (CRB) Analyst coordinates and executes the financial billing of clinical trials. The analyst is responsible for compilation of statistical, fiscal and metric data as it relates to clinical trial activities. The CRB Analyst also assists with clinical trial billing special projects, ensures timely invoicing,...


  • peoria, United States VTAL TECHNOLOGY SOLUTIONS LLC Full time

    Seeking a Technical Business Systems Analyst to work on a contract role with a leading construction equipment company, in Peoria, IL. 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) SQL experience (5 years...

  • Billing Analyst

    1 month ago


    Peoria, United States Medix™ Full time

    POSITION SUMMARY: The Clinical Research Billing (CRB) Analyst plays a crucial role in overseeing the financial aspects of clinical trials within our highly regulated field. This role involves compiling and analyzing diverse data, particularly focusing on Medicare Coverage Analysis (MCA), to ensure compliance with strict industry regulations. Collaborating...

  • Billing Analyst

    1 month ago


    Peoria, United States Medix™ Full time

    POSITION SUMMARY: The Clinical Research Billing (CRB) Analyst plays a crucial role in overseeing the financial aspects of clinical trials within our highly regulated field. This role involves compiling and analyzing diverse data, particularly focusing on Medicare Coverage Analysis (MCA), to ensure compliance with strict industry regulations. Collaborating...

  • Billing Analyst

    1 month ago


    Peoria, United States Medix™ Full time

    POSITION SUMMARY: The Clinical Research Billing (CRB) Analyst plays a crucial role in overseeing the financial aspects of clinical trials within our highly regulated field. This role involves compiling and analyzing diverse data, particularly focusing on Medicare Coverage Analysis (MCA), to ensure compliance with strict industry regulations. Collaborating...


  • Peoria, IL, United States VTAL TECHNOLOGY SOLUTIONS LLC Full time

    Seeking a Technical Business Systems Analyst to work on a contract role with a leading construction equipment company, in Peoria, IL. 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. SQL experience (5 years at a minimum). SQL,...


  • Peoria, IL, United States VTAL TECHNOLOGY SOLUTIONS LLC Full time

    Seeking a Technical Business Systems Analyst to work on a contract role with a leading construction equipment company, in Peoria, IL. 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) SQL experience (5 years at...

  • Financial Analyst

    5 days ago


    Peoria, United States Vonachen Group Full time

    Financial Analyst This strategic position with upward mobility is designed for the aspiring businessperson with an accounting background and training. The Accounting Analyst works in a team-oriented environment to provide management with accurate and timely financial data specific to the Company. Duties include financial statement preparation support,...


  • Peoria, United States TRIGO Global Quality Solutions Full time

    TRIGO Global Quality Solutions has several immediate openings for Sr. Logistics Analyst in Peoria, IL. Overall Purpose The Sr. Logistics Analyst acts as a daily liaison between suppliers and end customers. The Logistics Analyst also helps build and foster the relationship between the supplier, end customer, and TRIGO HT while maintaining the highest...


  • Peoria, United States Cullerton Group Full time

    Cullerton Group has a new opportunity for a Technical Business Systems Analyst 2 in Peoria, IL. The work will be done onsite 3 days a week. The rest will be work-from-home. This is a long term contract. It can lead to permanent employment with our customer. Compensation is $83,200/yr including benefits (vision, dental, health insurance, 401K, and holiday...


  • Peoria, United States ITC, Inc. Full time

    **Our large manufacturing client located in Peoria, Illinois, is looking for a Supply Chain Planning Analyst, to add to their team.** As a **Supply Chain Planning Analyst**, in this role you will assist in many of the day-to-day activities as well as participating with facility teams to develop material flow plans and pull material replenishment plans, to...


  • Peoria, United States ITC, Inc. Full time

    Job DescriptionJob DescriptionOur large manufacturing client located in Peoria, Illinois, is looking for a Supply Chain Planning Analyst, to add to their team.Job Description:As a Supply Chain Planning Analyst, in this role you will assist in many of the day-to-day activities as well as participating with facility teams to develop material flow plans and...


  • Peoria, United States Maui Jim Full time

    Partner with internal stakeholders on receiving, allocating and analyzing marketing materials, globally. Coordinate Systematic shipments across the Maui Jim network of distribution centers, suppliers, and customers. Support the department in evaluati Operations, Marketing, Logistics, Analyst, Operation, Transportation, Business Services, Manufacturing


  • Peoria, United States ITC Inc Full time

    Our large manufacturing client located in Peoria, Illinois, is looking for a Supply Chain Planning Analyst, to add to their team.Job Description:As a Supply Chain Planning Analyst, in this role you will assist in many of the day-to-day activities as well as participating with facility teams to develop material flow plans and pull material replenishment...


  • Peoria, United States Aditi Consulting Full time

    Summary: The main function of a business systems analyst is to analyze science, engineering, business and all other data processing problems for application to electronic data processing systems. A typical business systems analyst is responsible for analyzing user requirements, procedures and problems to automate or improve existing systems and review...


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

  • Accounting Analyst

    1 month ago


    Peoria, United States MH Equipment Company Full time

    If you are an outgoing and driven individual who is seeking career satisfaction with a financially stable and growing company, join the team at MH Equipment! As an Accounting Analyst within the Management Information Systems group, you will play a critical role in a strong, growing company. This position will report directly to the MIS Manager and will...