- Location
- PA-CLIENT-STATE, United States of America
- Workplace
- Remote
- Type
- Internship
- Department
- Engineering
- Seniority
- Internship
- Education
- Certification
- Source
- Workday
Description
Req number:
R8481Employment type:
Full timeWorksite flexibility:
RemoteWho 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 [email protected] 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.
$20 per hourThe pay range for this position is listed above. Exact compensation may vary based on several factors, including location, experience, and education. Benefit packages include medical, dental, and vision insurance, as well as 401k retirement account access. Employees in this role may also be entitled to paid sick leave and/or other paid time off as provided by applicable law.
