Data Engineer Intern

Anicca Data Science SolutionsBellevue, WA

About The Position

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 Anicca Data Science Solutions is the one stop shop from objective to accomplishment in the data driven world. Our focus is to provide big data services and building algorithmic products to help business houses in process efficiency. The skill of Anicca is in putting together data platforms and applications with AI/ML solutions for addressing numerous modern day business challenges. The data space spans across multiple domains with numerous use cases. Anicca is on a mission to explore those strings of data and find insights that drives performances of the business practices. Anicca team strongly believe in transforming the way businesses operate with data driven decision making. Anicca is a group of talented, dedicated folks who crave to find patterns, analyze the sentiments, deep dive for insightful influencers with solo motto of building transformational systems. Our team consists of data scientists, data engineers, software developers, data architects, and user-experience experts from diverse backgrounds like Computer Science, Physics, and Mathematics. This humble team brings forth the prerequisite system knowledge and hands on experience that are required to solve real world business problems. Working at Anicca means joining a group of people obsessed with solving problems — making things that inspire new ways of thinking and bringing about real change. A team that has big talent, small egos and is always hungry to learn, lead and grow.

Requirements

  • 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

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
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service