Back to jobs
Bellevue, WA, USA
2026-04-03
Anicca Data Science Solutions
North America
Data Engineer Intern
Role Description
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