Business Data Analyst - Peoria, United States - Diversified Services Network

Mark Lane

Posted by:

Mark Lane

beBee recruiter


Description
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 a MUST

JOB RESPONSIBILITIES:

Cleanse and validate Bill of material (BOM) data for projects.

Use SQL in a Snowflake database to retrieve historical BOM data and transform it into an established structure.

Use strong SQL skills use of script languages and regular expressions.

Validate the BOM data was successfully transformed and stored.

Work with the As-Built BOM manager to determine the proper methods to achieve results.

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


Work environment:
Hybrid model


Education & Experience Required:

  • Bachelor's Degree with 57 years' experience.
  • Associates/ No college degree with a minimum of 9+ years of experience in this capacity.
Technical Skills (required)

  • Snowflake is a MUST
  • SQL experience (5 years at a minimum).
  • Ability to work independently and manage one's time.
  • Scripting experience in Perl, Python, R or Regular expressions are bonuses.
  • Experience with product structure and engineering bill of materials.
Soft Skills(required)

  • Verbal and written communication skills, problem solving skills, customer service and interpersonal skills.

Pay:
$62, $75,509.09 per year


Benefits:


  • 401(k)
  • Dental insurance
  • Green card sponsorship
  • Health insurance
  • Life insurance
  • Visa sponsorship
  • Vision insurance

Experience level:

  • 4 years
  • 5 years

Schedule:

  • 8 hour shift
  • Monday to Friday

Ability to Relocate:

  • Peoria, IL: Relocate before starting work (required)

Work Location:
In person

More jobs from Diversified Services Network