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

bHo2WXhCcTZWY2tZSlp5ck8rWnhNNzBuSEE9PQ==
  • 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 Amer ica'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

Computer Aid, Inc.

Data Analyst Intern Job at Computer Aid, Inc.

 ...collected there is subject to their terms and privacy notice. Data Analyst Intern Req Number R6105 Employment Type Full time...  ...data analysis projects. This role is a ? full-time internship role and is remote . The internship dates are June 1, 2026 to... 

PeakMade Real Estate

Maintenance Technician Job at PeakMade Real Estate

 ...Job Description Job Description The Maintenance Technician will be responsible for performing a variety of maintenance tasks necessary...  ...and reward programs through Peak's LiveWell program ~ Facilities related leadership program ~ Additional technical training... 

1-Stop Design Shop, Inc.

Associate Full Stack WordPress Developer (On-Site) Job at 1-Stop Design Shop, Inc.

 ...on-site position in Bedford MA. Do Not Apply if you are outside a 50 mile radius. The Role Were looking for a WordPress Web Developer whos confident in both front-end creative and back-end programmingwith an expert-level command of WordPress . Youll help... 

Tech Digital

Skilled Trade - Production Technician I - HPLC Job at Tech Digital

Production Technician I Organization Unit: Phenomenex Inc Pay Rate: 20/hr. Shift: 1st shift - 6am to 2:30pm Monday through Friday (Flexible) GENERAL SUMMARY: The Production Technician I is responsible for manufacturing a variety of different GC columns; will require...

Syntricate Technologies

MFT Developer Job at Syntricate Technologies

 ...Job Posting Skills Required: MFT & IBM Sterling B2B Integrator, Control Center Hands-on experience required. File Encryption Experience with PGP, GPG, and SSL certificates. Transfer Protocols: Skilled in SFTP, FTP, and Connect Direct. Networking Protocols Knowledge...