Business Data Analyst - Peoria, United States - Diversified Services Network
Description
Diversified Services Network, Inc. (DSN) is seeking a full-timeTechnical 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.
- 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.
- 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
-
Technical Business Analyst- Salesforce
Chicago, United States - 3 days ago
-
Component Technician
Monticello, United States - 1 week ago
-
Business Data Analyst
Peoria, United States - 3 weeks ago
-
Manufacturing Engineer
Mossville, United States - 2 weeks ago
-
Entry-level Gaming QA Tester
Rapid City, United States - 1 week ago
-
Electrical Project Manager
Alpharetta, United States - 2 weeks ago