Bill of Material

2 weeks ago


Peoria, United States Vision It US Full time
Job DescriptionJob 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 (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


Required Skills : Business Analysis,Python,SQL
Additional Skills : Applications Architect,Business Analyst,Big Data
  • Bill of Material

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


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

  • Compliance Auditor

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

  • Shop Clerk

    8 hours 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

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


  • Peoria, United States Palo Verde Cancer Specialists Full time

    Job Type Full-time Description This position is responsible for performing secretarial, reception, and initial patient needs assessment functions. Provides outstanding customer service and ensures a smooth patient flow process by providing services in admissions, financial counseling, billing, scheduling patients, paperwork completion, basic explanation of...

  • Warehouse Associate

    14 hours ago


    Peoria, United States Parker Hannifin Corporation Full time

    Warehouse Associate Location : Peoria, IL, United States Job Family : Manufacturing Job Type : Regular Posted : Jul 26, 2023 Job ID : 42302 Back to Search Results Job Description Apply Now > Save JobJob Saved The WAREHOUSE ASSOCIATE will prepare items for shipment by assembling, addressing, stamping, and utilizing systems to process and arrange for...


  • Peoria, United States OSF HealthCare Full time

    Overview Expected pay for this position is $56.87 - $75.35/hour. Actual pay will be determined by experience, skills and internal equity. POSITION SUMMARY: The Director of Compliance Audit is accountable for leading the essential functions of the OSF Compliance and Audit Program in the specified areas of responsibility. In this role, the Director focuses on...

  • Warehouse Associate

    6 hours ago


    Peoria, United States Parker Hannifin Corporation Parker Aerospace Group Full time

    Warehouse Associate Location: Peoria, IL, United StatesJob Family : ManufacturingJob Type : RegularPosted : Jul 26, 2023 Job ID: 42302 Back to Search ResultsJob DescriptionApply Now >Save Job Job Saved The WAREHOUSE ASSOCIATE will prepare items for shipment by assembling, addressing, stamping, and utilizing systems to process and arrange for the...


  • Peoria, United States Heartland Health Services Full time

    Description: **Position Summary** The Patient Access Representative 2 performs multiple medical office tasks including, but not limited to, obtaining appropriate patient information for billing and reimbursement of services, uses system-wide computer technology for scheduling and registration, and performs all necessary actions to assure quality customer...

  • Contract Admin

    12 hours 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...

  • Research Chemist

    1 month ago


    Peoria, 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...

  • Research Chemist

    2 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 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

    1 month ago


    Peoria, 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...


  • Peoria, United States Mcomm Group Full time

    Job Description Job Description Are you a forward-thinking all star who truly wants to make a difference? Join our outstanding team! Mcomm Group is a 20+ year marketing firm and technology solutions provider in the heavy equipment industry. We’re growing and looking for a highly motivated and dynamic Account Manager/Marketing Strategist with a self-starter...