Data Architecture & Engineering Intern (Summer 2027)

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

Data Architecture & Engineering Intern

2027 Internship Dates: June 7 - August 13, 2027

AArete is one‑of‑a‑kind when it comes to consulting firm culture

As an Intern at AArete, you'll have the opportunity to directly impact both team and client objectives while fostering your personal growth. We seek organized, motivated individuals excited to join our experienced consulting team and serve clients across healthcare, financial services, retail, and other industries.

AArete Interns work closely with clients to understand critical issues and develop strategies for meaningful change. You'll leverage your analytical skills, entrepreneurial spirit, and commitment to excellence. We're looking for critical thinkers with exceptional communication skills who are eager to dive deep into business challenges, data analytics, and business case development to drive project success.

In this role, you'll demonstrate your analytical abilities and support the successful execution of project goals and deliverables. You'll have the chance to make a significant impact by addressing unique business challenges in both client and internal projects.

Work you'll do

• As a Data Architecture & Engineering Intern, you will 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

What you'll gain

• Professional and personal growth through a comprehensive internship program designed to develop your skills and career
• Direct impact on team and client objectives, contributing meaningfully to real‑world healthcare projects
• Hands‑on experience with our experienced technology team, working on high‑impact engagements for healthcare payer clients
• Mentorship and guidance from experienced professionals in the field
• Networking opportunities with professionals and leaders in the consulting industry
• Competitive compensation and valuable insights to kickstart your engineering career

Requirements

Education & Eligibility

• 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

Skills & Abilities

• Strong interest in pursuing a career in data architecture or engineering
• Demonstrated passion for continuous learning and staying current with industry trends and technologies
• Ability to approach problem‑solving with logical and analytical thinking
• Capable of understanding business and project goals to craft and deliver meaningful solutions to our clients
• Proficient in MS Excel, MS PowerPoint, SQL and Python, with the ability to further develop and apply these skills
• Works effectively both independently and in group settings
• Excited to support Analysts, Consultants, Senior Consultants, and Managers in developing creative solutions for clients

Preferred Requirements

• Degree/Major in Data Engineering, Computer Science, or a related field
• 3.3 or higher cumulative and major GPA
• Relevant work experience, including internships, summer positions, or part‑time jobs
• Exposure to LLMs, prompt engineering, or AI‑assisted development, and interest in applying them within a governed enterprise data platform.
• Active involvement in university clubs or organizations related to consulting, business, or leadership, showcasing relevant skills and interests

We put humans at the center of our work

We're a global management and technology consulting firm specializing in strategic profitability improvement, digital transformation, and strategy & change for clients. Our cross‑industry solutions are powered by a digital‑first mindset, market intelligence, and data‑driven approach to deliver purposeful change, actionable insights, and guaranteed results.

But what sets us apart is our people. We are guided by our deeply embedded guiding principles: Excellence, Passion, Loyalty to Clients, Stewardship, Family, Community, Sustainability, and Inclusion.

And we've been recognized as a top firm to work for by companies like Forbes, Top Workplaces Chicago Tribune, and Consulting Magazine.

We've earned a Great Place to Work Certification and been named a World's Best Management Consulting Firm by Forbes, Vault's Top 50 Firms to Work For, Crain's Chicago Business Fast 50, Inc 5000's Fastest Growing Firms, and Consulting Magazine's Fastest Growing Firms.

Learn more about our award‑winning culture

We are an Equal Employment Opportunity Employer

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.