Data Architecture & Engineering Intern: Build Data Pipelines

AArete; Denver (CO); On-site; USD 12,000 - 18,000; Full time

Job summary

AArete is seeking a Data Architecture & Engineering Intern for the 2027 summer program. You’ll support client engagements, analyze data, and collaborate with senior consultants in a fast-paced environment.

The role emphasizes hands-on experience with Snowflake Cortex AI, Airflow, and AWS, applying coursework to real-world healthcare and data challenges. You’ll gain mentorship, professional growth, and exposure to high-impact projects while developing skills in data engineering and analytics

Qualifications

• Current undergraduate student entering either their third year of a 4-year degree program or in the fourth year of a 5-year program (Spring 2028 Grad).
• Minimum 3.0 cumulative GPA
• Must be legally authorized to work in the United States without the need for employer sponsorship
• Must be able to spend the summer in our downtown Chicago office, in office daily during the dates of June 7 - August 13, 2027

Responsibilities

• Work with our consultants in the field to support client engagements and facilitate the delivery of analytics
• Work with advanced technologies including Snowflake and its native Cortex AI capabilities, Apache Airflow for pipeline orchestration, and a range of AWS services
• Participate in R&D projects applying Snowflake Cortex AI and other emerging capabilities to healthcare claims data, connecting your academic coursework to real‑world engineering challenges
• Analyze, synthesize, and interpret complex data sets, finding efficient ways to integrate client data and produce analytical outputs that support client delivery
• Utilize industry‑standard DevOps practices to develop and maintain high‑quality, version‑controlled data engineering solutions, ensuring smooth deployment to high‑availability production environments

Skills

MS Excel

MS PowerPoint

SQL

Python

Education

Undergraduate student

Spring 2028 Grad

Tools

Snowflake

Cortex AI

Apache Airflow

AWS

Job description

AArete is seeking a Data Architecture & Engineering Intern for the 2027 summer program. You’ll support client engagements, analyze data, and collaborate with senior consultants in a fast-paced environment.

The role emphasizes hands-on experience with Snowflake Cortex AI, Airflow, and AWS, applying coursework to real-world healthcare and data challenges. You’ll gain mentorship, professional growth, and exposure to high-impact projects while developing skills in data engineering and analytics