We are seeking a skilled
Data Engineer Intern
with 2+ years of experience in designing, building, and optimizing data pipelines and integration solutions. The ideal candidate will have strong expertise in ETL/ELT processes, SQL optimization, and modern data tools across cloud environments.
Duration - 3 months
Key Responsibilities
-
Design, develop, and maintain scalable ETL/ELT pipelines using SSIS, dbt, and Airbyte
-
Build and optimize data workflows to process large datasets efficiently
-
Write complex SQL queries, including joins, CTEs, window functions, and performance tuning
-
Develop and maintain data models and data warehouse architectures
-
Work with AWS services (Redshift, S3, Athena) for data storage, transformation, and analytics
-
Ensure data quality, integrity, and consistency across data pipelines
-
Collaborate with cross-functional teams to understand business requirements and translate them into technical solutions
-
Implement and manage version control using Git and support CI/CD pipelines for automated deployments
Qualifications
-
2+ years of experience in data engineering or related roles
-
Strong experience with SSIS for ETL development and data integration
-
Advanced proficiency in SQL with a focus on performance optimization
-
Hands-on experience with dbt and Airbyte for data transformation and ingestion
-
Experience working with AWS data services, including Redshift, S3, and Athena
-
Solid understanding of data modeling, data warehousing concepts, and scalable architecture design
-
Familiarity with version control systems (Git) and CI/CD practices
-
Strong problem-solving skills and ability to work with large, complex datasets