Data Analyst Intern - 6 month Job at Ideal Industries, Sycamore, IL

U1h1ZUt6Wll4M0RRbVIzK1dLYzF5d1kvUGc9PQ==
  • Ideal Industries
  • Sycamore, IL

Job Description

IDEAL Industries, Inc. has built a reputation for over a century by crafting iconic tools and practical technology required in aerospace, data communications, electrical, wire processing and construction. The global family of IDEAL brands includes IDEAL Electrical, Anderson Power, and Enatel. A vibrant and dynamic company, IDEAL is best known for our wire connectors, the gold standard for making electrical connections around the world. Nearly every commercial jet is assembled using IDEAL wire strippers and, as part of the critical equipment on NASA missions, our tools even help NASA astronauts fly to the moon. Most important, our products benefit skilled tradespeople, who reach for IDEAL tools every day. IDEAL is propelled by the concept of Building an IDEAL World. Our family-run business is committed to building ideal relationships with customers, employees, and communities by crafting some of our industry's most innovative and trusted tools. We are seeking a highly motivated and detail-oriented Data Engineer Intern to join our data and analytics team. As a Data Engineer Intern, you will focus on building, maintaining, and optimizing data pipelines with a specific emphasis on working with Microsoft SQL databases. You will also gain exposure to modern cloud-based data platforms such as Microsoft Fabric and Snowflake, ensuring that data is transformed and loaded accurately for analytics and reporting Responsibilities:

  • Design, develop, and maintain efficient data pipelines using Microsoft Azure Data Factory and/or FiveTran.
  • Perform data transformations to ensure data is optimized for reporting and analytics.
  • Assist in integrating data from various internal and external data sources into SQL-based systems.
  • Ensure data quality, consistency, and integrity through the use of best practices in data management.
  • Collaborate with data analysts, business users, and other team members to understand data requirements and deliver solutions.
  • Gain experience working with Microsoft Fabric and Snowflake, helping with data migration and cloud-based data solutions.
  • Document data pipeline processes, transformations, and database structures for future reference.
  • Maintain data lineage through developed data transformational pipelines.
  • Maintain data security standards defined by the organization.
  • Support organization change management policies
  • Maintain data technical documentation and standards
Requirements:
  • Bachelor's degree or Master's degree in computer science, Information Systems, Engineering, or a related field.
  • 1-2 years of experience in data engineering or a related field (internships, advanced degree, or relevant projects considered).
  • Proficiency in Microsoft SQL Server for querying, data manipulation, and optimization.
  • Experience with ETL processes and tools for data transformation (Azure Data Factory, FiveTran).
  • Familiarity with database management and performance tuning in Microsoft SQL environments.
  • Basic understanding of Microsoft Fabric or Snowflake or similar cloud-based data platforms.
  • Strong analytical and problem-solving skills with attention to detail.
  • A satisfactory equivalent combination of experience and training which ensures the ability to perform the work may be considered.
The expected pay rate for this position is between $15.00 and $20.00 per hour and is full time. IDEAL INDUSTRIES, INC. is proud to be one of America's Top 100 Most Loved Workplaces and an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, or protected veteran status. We know when you honor relationships, success for all will follow. To learn more about us, visit

Job Tags

Hourly pay, Full time,

Similar Jobs

Maximus Inc.

Vice President of Finance / CFO (Remote US) (Los Angeles) Job at Maximus Inc.

 ...Command : Own cash flow forecasting, liquidity planning, and our banking relationships. You will be the trusted advisor to the CEO and...  ...You will play a critical role in securing the capital that allows us to scale our impact. Capital Planning & Fundraising :... 

The Fountain Group LLC

Document Specialist Job at The Fountain Group LLC

 ...is Thomas Gillitzer, and I am a Recruiter with The Fountain Group. We are a national staffing firm and are currentlyseeking a Documentation Specialist for a prominent clientofours.Details for the positionare as follows: Job Description: Supporting... 

Eaton

Field Commissioning Representative - Wenatchee Job at Eaton

Eaton's ES AMER ESS division is currently seeking a Field Commissioning Representative - Wenatchee in Wenatchee, WA.The expected annual...  ...QA/QC procedures.Qualifications:BASIC QUALIFICATIONS:* High School Diploma or GED equivalent or higher with minimum 1 year... 

Puzzle HR

Entry-Level Data Entry Specialist Job at Puzzle HR

Job Description Job Description Overview Job Title: Entry-Level Data Entry Specialist

Tower Semiconductor

Learning & Organizational Development Business Partner (Newport Beach) Job at Tower Semiconductor

 ...Learning & Organizational Development Business Partner Location: Newport Beach, CA, USA, 92660 Company: Tower Semiconductor Ltd. About Tower Semiconductor Recruiting World Class Talent For A World Class Leader!Join Tower Semiconductor! Looking for a career...