Apply on Employer Site

IDEAL INDUSTRIES, INC · 7 hours ago

Data Analyst Intern - 6 month

Sycamore, IL

Internship

Onsite

Intern

$15/hr - $20/hr

1+ years exp

IDEAL Industries, Inc. is a vibrant and dynamic company known for crafting iconic tools and practical technology. They are seeking a highly motivated and detail-oriented Data Engineer Intern to join their data and analytics team, focusing on building and optimizing data pipelines while gaining exposure to modern cloud-based data platforms.

Electrical DistributionElectronic Health Record (EHR)ElectronicsManufacturing

Comp. & Benefits

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

Qualification

Microsoft SQL ServerETL processesMicrosoft Azure Data FactoryMicrosoft FabricSnowflakeAnalytical skillsProblem-solving skillsAttention to detail

Required

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

Company

IDEAL INDUSTRIES, INC

IDEAL INDUSTRIES, INC is a family of brands that have made their mark by developing the products and practical technology demanded by critical industries like data communications, aerospace, electrical, wire processing, construction and more.

Founded in 1916

Sycamore, Illinois, USA

1001-5000 employees