Data Engineering Intern

Calamos Investments•Naperville, IL

About The Position

The Data Engineering Summer Intern will work alongside the Data Engineering team on data platform projects, contributing to planning, analysis, and pipeline development, and engaging in discussions with business partners. Responsibilities and summer projects will be tailored to the intern’s skills, academic journey, and interests. The intern will help rebuild legacy processes in Databricks, develop PySpark and SQL transformations with data quality checks and source-data reconciliation, and investigate undocumented ETL jobs to document business rules and data lineage. AI coding assistants may be used to support conversion, testing, and query drafting; the intern is expected to review results before they are delivered.

Requirements

  • Must be at least a bachelor’s degree candidate in a relevant STEM area of study.
  • Strong understanding of data engineering.
  • Proficiency in Python, SQL, and AI-assisted coding tools.
  • Entrepreneurial spirit and ability to work well in a team environment.
  • Creative problem-solving skills and impeccable attention to detail.

Nice To Haves

  • Experience with Databricks, Spark, and Claude Code is a plus.

Responsibilities

  • Help rebuild existing legacy processes in Databricks using AI coding assistants and validate that results match the old system.
  • Write PySpark and SQL transformations with data quality checks and reconciliation against source data.
  • Use AI to draft tests and queries, then review the work before it ships.
  • Investigate undocumented ETL jobs, capture business rules and data lineage, and produce maintainable documentation.
  • Contribute to planning, analysis, and pipeline development for data platform projects.
  • Engage in discussions with business partners.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service