Data Engineering Intern

Req number: R8481

Employment type: Full time

Worksite flexibility: Remote

Who we are

CAI is a global services firm with over 9,000 associates worldwide and a yearly revenue of $1.3 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we have the freedom and focus to do what is right—whatever it takes. Our tailor-made solutions create lasting results across the public and commercial sectors, and we are trailblazers in bringing neurodiversity to the enterprise.

Job Summary

As the Data Engineering Intern, you will write Python code to build and maintain ETL/ELT pipelines in Databricks notebooks.

Job Description

We are looking for a Data Engineering Intern. This role is a full-time internship and is remote. This internship is a full-time opportunity requiring a commitment of 40 hours per week and will run from June 7, 2027 through August 6, 2027. Candidates must be available during core business hours for the entire 9-week duration of the program. Please note that all work must be performed within the United States.

What You'll Do

• Write Python code to build and maintain ETL/ELT pipelines in Databricks notebooks
• Develop data transformations using Apache Spark, Delta Lake, and SQL
• Collaborate with data engineers and analysts to understand data requirements and deliver scalable solutions
• Create and optimize Databricks jobs to process data at scale
• Write unit tests and validation logic to ensure data quality and pipeline reliability
• Document code, workflows, and technical decisions to support team knowledge sharing
• Participate in code reviews and contribute to improving data engineering practices
• Troubleshoot data issues and optimize pipeline performance
• Learn and apply best practices for building production-grade data platforms

What You'll Need

Required:

• Pursuing a degree in Computer Science, Data Science, Engineering, or a related field
• Current Junior with a 3.5 GPA or higher
• Strong Python programming skills with ability to write clean, maintainable code
• Understanding of SQL and relational data concepts
• Problem-solving mindset with attention to detail
• Ability to work independently and ask for help when needed

Preferred:

• Experience with Apache Spark or PySpark
• Familiarity with Git and version control workflows
• Knowledge of ETL/ELT concepts and data pipeline design
• Exposure to Databricks, cloud platforms (AWS/Azure), or similar data engineering tools
• Familiarity with SQL notebooks or Jupyter notebooks
• Experience with testing frameworks or CI/CD concepts

Physical Demands

Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal, state and local standards. Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor. Must be able to communicate with customers/team members over the phone and in person. Sedentary work that involves sitting or remaining stationary most of the time, with occasional need to move around the office to attend meetings, etc.

#DNP

EEO Statement

CAI is committed to equal employment opportunity. We do not discriminate based on race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability, or veteran status. All employment decisions are based on valid job requirements, including hiring, promotion, and compensation. Harassment and retaliation are prohibited.

Reasonable accommodation statement

If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to application.accommodations@cai.io or (888) 824 – 8111.

EEO Statement

It is the policy of Computer Aid, Inc.(CAI) not to discriminate against any employee or applicant for employment because of race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or because he or she is a protected veteran. It is also the policy of CAI to take affirmative action to employ and to advance in employment, all persons regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or protected veteran status, and to base all employment decisions only on valid job requirements. This policy shall apply to all employment actions, including but not limited to recruitment, hiring, upgrading, promotion, transfer, demotion, layoff, recall, termination, rates of pay or other forms of compensation and selection for training, including apprenticeship, at all levels of employment. Employees and applicants of CAI will not be subject to harassment on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or because he or she is a protected veteran. Additionally, retaliation, including intimidation, threats, or coercion, because an employee or applicant has objected to discrimination, engaged or may engage in filing a complaint, assisted in a review, investigation, or hearing or have otherwise sought to obtain their legal rights under any Federal, State, or local EEO law is prohibited.