Business Analytics Intern: Build Dashboards & Insights

AArete; Vienna (VA); On-site; USD 39,000 - 52,000; Full time

Job summary

AArete is seeking a Business Analytics Intern to join our Chicago office for the Summer 2027 program. You will work with client teams to collect, clean, and analyze data, build dashboards, and develop actionable insights across healthcare, financial services, and retail sectors.

You will leverage Excel, SQL, Snowflake, and BI dashboards while receiving mentorship from experienced consultants. A strong communicator with a passion for analytics will thrive in this role.

Qualifications

• Current undergraduate student entering third year of a 4-year degree or 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 sponsorship.
• Must be able to spend the summer in our downtown Chicago office, in office daily June 7–Aug 13, 2027.

Responsibilities

• Collaborate with project teams to collect, clean, and analyze data supporting strategic recommendations.
• Build dashboards and visualizations within BI platforms to help teams and clients make informed decisions.
• Use Excel, SQL, Snowflake and visualization tools to uncover trends and opportunities.
• Support in building business cases, financial models, and actionable insights for clients.
• Analyze data for healthcare clients to solve problems and develop efficient solutions.
• Present findings clearly to technical and non-technical audiences.
• Work with other interns on a pro-bono consulting project for a nonprofit.
• Partner with Analysts, Consultants, and Managers to solve real-world business challenges.
• Other duties as assigned.

Skills

Analytical thinking

PowerPoint

MS Excel

SQL

Python

R

Education

Undergraduate degree in Business Analytics or related field

GPA 3.0+

Spring 2028 graduation

Tools

Microsoft Excel

SQL

Snowflake

BI platforms

Job description

AArete is seeking a Business Analytics Intern to join our Chicago office for the Summer 2027 program. You will work with client teams to collect, clean, and analyze data, build dashboards, and develop actionable insights across healthcare, financial services, and retail sectors.

You will leverage Excel, SQL, Snowflake, and BI dashboards while receiving mentorship from experienced consultants. A strong communicator with a passion for analytics will thrive in this role.