Technical Business Systems Analyst 2

3 weeks ago

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 pay). Cullerton Group will provide sponsorship.
Position Overview: The primary responsibility of the Technical Business Systems Analyst is to cleanse and validate Bill of Material (BOM) data for mechanical products. The role involves using SQL within a Snowflake database to retrieve, transform, and structure historical BOM data. This position requires strong SQL capabilities along with knowledge of mechanical components to ensure data completeness and accuracy.

Key Responsibilities:
  • Retrieve and transform BOM data using SQL queries within a Snowflake environment.
  • Validate the accuracy and structure of BOM data.
  • Ensure the completeness of BOM data using detailed knowledge of mechanical products.
  • Collaborate with the As-Built BOM manager to determine effective data handling methods.

Story Behind the Need:
  • This role is crucial for maintaining high data integrity and supporting the operations of the mechanical products group.

Typical Day:
  • Writing and executing SQL queries to manage BOM data.
  • Validating data accuracy and structural integrity.
  • Engaging with a small team to discuss and solve BOM-related issues.

Candidate Requirements:

Education & Experience:
  • Bachelor’s Degree with 2-4 years’ experience in a related field, or
  • Associate's/No college degree with a minimum of 6+ years of experience in data management.

Technical Skills:
  • Proficient in SQL with 2-4 years of experience.
  • Experience with mechanical product structures and engineering BOMs.
  • Familiarity with scripting in Perl, Python, R, or usage of regular expressions is preferred.

Soft Skills:
  • Excellent verbal and written communication skills.
  • Strong problem-solving abilities and interpersonal skills.
  • Ability to work independently and manage time effectively.

Disqualifiers/Red Flags:
  • Absence of candidate's location on the resume.
  • Non-residence in the Peoria, IL area without indication of willingness to relocate at own expense.
  • Choppy tenure on resume without clarification if positions were project-based.

Interview Process:
  • Single round panel interview conducted via Teams.

This position is integral to ensuring the integrity and reliability of BOM data within the company, contributing significantly to operational efficiency and product development.

  • Technical Business Systems Analyst

    3 weeks ago

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

  • Technical Business Systems Analyst

    1 week ago

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

  • Technical Business Systems Analyst

    3 weeks ago

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

  • IT Business System Analyst

    3 weeks ago

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

  • Associate Business Analyst

    5 days ago

    Peoria, United States RLI Full time

    About Us We're not like other insurance companies. From our specialty products to our business model, our culture to our results - we're different. Different is who we are, and how we work, interact, deliver and succeed together. Creating a different and better insurance experience doesn't just happen. It takes focus and a shared passion for going beyond...

  • Business Analyst

    2 weeks ago

    Peoria, United States Martin Engineering Full time

    Celebrating our 80th year, Martin Engineering is a privately owned global manufacturing company located in Neponset, IL. As the leader in our industry, we believe it is our people who are responsible for our SUCCESS. Our culture is unique; we want our employees to arrive to work happy and leave for the day feeling that same way. We strive to deliver superior...

  • Business Analyst

    2 weeks ago

    Peoria, United States Martin Engineering Full time

    Job DescriptionJob DescriptionCelebrating our 80th year, Martin Engineering is a privately owned global manufacturing company located in Neponset, IL.  As the leader in our industry, we believe it is our people who are responsible for our SUCCESS.  Our culture is unique; we want our employees to arrive to work happy and leave for the day feeling that same...

  • Business Analyst

    2 weeks ago

    Peoria, United States Martin Engineering Full time

    Job DescriptionJob DescriptionCelebrating our 80th year, Martin Engineering is a privately owned global manufacturing company located in Neponset, IL.  As the leader in our industry, we believe it is our people who are responsible for our SUCCESS.  Our culture is unique; we want our employees to arrive to work happy and leave for the day feeling that same...

  • Business Analyst

    13 hours ago

    Peoria, United States Martin Engineering Full time

    Job DescriptionJob DescriptionCelebrating our 80th year, Martin Engineering is a privately owned global manufacturing company located in Neponset, IL.  As the leader in our industry, we believe it is our people who are responsible for our SUCCESS.  Our culture is unique; we want our employees to arrive to work happy and leave for the day feeling that same...

  • Technical Lead

    1 day ago

    Peoria, Illinois, United States Caterpillar Full time

    Career Area: Business Technologies, Digital and Data Job Description: Your Work Shapes the World at Caterpillar Inc. When you join Caterpillar, you're joining a global team who cares not just about the work we do - but also about each other. We are the makers, problem solvers, and future world builders who are creating stronger, more sustainable...

  • Business Data Analyst, Aftermarket Insights

    3 weeks ago

    Peoria, Illinois, United States Caterpillar Full time

    Career Area: Business Technologies, Digital and Data Job Description: Your Work Shapes the World at Caterpillar Inc. When you join Caterpillar, you're joining a global team who cares not just about the work we do - but also about each other. We are the makers, problem solvers, and future world builders who are creating stronger, more sustainable...

  • Lead Business Intelligence Analyst

    2 weeks ago

    Peoria, United States Caterpillar Full time

    Career Area: Business Technologies, Digital and Data Job Description: Your Work Shapes the World at Caterpillar Inc. When you join Caterpillar, you're joining a global team who cares not just about the work we do - but also about each other. We are the makers, problem solvers, and future world builders who are creating stronger, more sustainable...

  • Business Data Analyst, Aftermarket Insights

    3 weeks ago

    Peoria, United States Caterpillar Full time

    Career Area: Business Technologies, Digital and Data Job Description: Your Work Shapes the World at Caterpillar Inc. When you join Caterpillar, you're joining a global team who cares not just about the work we do - but also about each other. We are the makers, problem solvers, and future world builders who are creating stronger, more sustainable...

  • Lead Business Intelligence Analyst

    2 weeks ago

    Peoria, Illinois, United States Caterpillar Full time

    Career Area: Business Technologies, Digital and Data Job Description: Your Work Shapes the World at Caterpillar Inc. When you join Caterpillar, you're joining a global team who cares not just about the work we do - but also about each other. We are the makers, problem solvers, and future world builders who are creating stronger, more sustainable...

  • Application Support Analyst

    4 days ago

    Peoria, United States Saxon Global Full time

    The main function of an Application Security Analyst is to ensure the digital product is designed, configured, tested, implemented, and supported in alignment with the defined Security Model. Analyst will be responsible for evaluating and ensuring product & process enhancements align with the Security Model.Typical task breakdown:-Define, Test, Implement,...

  • Application Support Analyst

    6 days ago

    Peoria, United States Saxon Global Full time

    The main function of an Application Security Analyst is to ensure the digital product is designed, configured, tested, implemented, and supported in alignment with the defined Security Model. Analyst will be responsible for evaluating and ensuring product & process enhancements align with the Security Model. Typical task breakdown: -Define, Test, Implement,...

  • Application Support Analyst

    3 days ago

    Peoria, United States Saxon Global Full time

    The main function of an Application Security Analyst is to ensure the digital product is designed, configured, tested, implemented, and supported in alignment with the defined Security Model. Analyst will be responsible for evaluating and ensuring product & process enhancements align with the Security Model. Typical task breakdown: -Define, Test, Implement,...

  • Technical Writer

    2 days ago

    Peoria, United States Diversified Services Network Full time

    Diversified Services Network, Inc. (DSN) is seeking a full-time **Technical Writer **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! **JOB RESPONSIBILITIES**: - Write technical...

  • Logistics Analyst 2

    3 weeks ago

    Peoria, United States Aditi Consulting Full time

    Responsibilities: Perform a variety of Supply Chain and Logistics support activities related to order processing, order receipt and order shipment. Assess order completeness and accuracy. Use of multiple Client information systems to track and plan Logistics Node and dealer shipments. Investigate issues or order discrepancies and problem solve. ...

  • Test Automation Engineer

    2 weeks ago

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