Data Analytics Intern: Build Dashboards & Insights

AArete; New York (NY); On-site; USD 39,000 - 52,000; Part time

Job summary

AArete offers a Business Analytics Intern role for Summer 2027, based in Chicago, with hands-on client work across healthcare, financial services, and other industries. You will collect, clean, and analyze data, build dashboards, and develop business cases under mentoring from experienced consultants.

You’ll gain mentorship, grow problem-solving and storytelling skills, and contribute to pro-bono projects while learning analytics tools and BI platforms.

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

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

Skills

Excel

SQL

Data analysis

Communication

Problem solving

Teamwork

MS PowerPoint

Snowflake

BI platforms

Education

Undergraduate student in progress

Tools

Snowflake

Microsoft Excel

SQL

PowerPoint

Job description

AArete offers a Business Analytics Intern role for Summer 2027, based in Chicago, with hands-on client work across healthcare, financial services, and other industries. You will collect, clean, and analyze data, build dashboards, and develop business cases under mentoring from experienced consultants.

You’ll gain mentorship, grow problem-solving and storytelling skills, and contribute to pro-bono projects while learning analytics tools and BI platforms.