Business Analytics Intern (Summer 2027)

aarete; Chicago (IL); On-site; USD 38,000 - 53,000; Full time

Job summary

AArete in Chicago is seeking a Business Analytics Intern for the 2027 internship. You’ll work with our consulting team to analyze data, build dashboards, and support client projects across healthcare, financial services, retail, and other industries.

You’ll gain hands-on analytics experience, mentorship, and exposure to Excel, SQL, Snowflake, and BI tools, developing communication and problem-solving skills for real-world business challenges.

Qualifications

• Current undergraduate student entering their third year or in the fourth year of a 5-year program
• Minimum 3.0 cumulative GPA
• Authorized to work in the United States without sponsorship
• Able to spend the summer in downtown Chicago office (June 7 – August 13, 2027)

Responsibilities

• Collaborate with project teams to collect, clean, and analyze data
• Build dashboards and visualizations in BI platforms
• Utilize Excel, SQL, Snowflake to uncover trends and opportunities
• Support in building business cases, financial models, and insights for clients
• Work with healthcare clients on data analysis and problem solving
• Present findings clearly to technical and non-technical audiences
• Collaborate with interns on a pro-bono consulting project
• Partner with Analysts, Consultants, and Managers on real-world business challenges
• Other duties as assigned

Skills

Analytical thinking

Excel

SQL

PowerPoint

Communication

Python

R

Education

Undergraduate student (third year or 4th year of 5-year program)

Tools

SQL

Snowflake

Job description

Business AnalyticsIntern

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

• 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

What you’ll gain

• Real-world experience working on client and internal data projects
• Exposure to analytics in a consulting environment across multiple industries
• Hands-on technical skills in analytics tools and frameworks
• Mentorship and guidance from experienced data and consulting professionals
• Opportunities to grow your problem-solving, storytelling, and communication skills
• A supportive, collaborative, and fun internship cohort
• Competitive pay and a strong foundation to launch your career in analytics or consulting

Requirements

Education & Eligibility

• Current undergraduate student entering either their third year of a4-yeardegree program or in the fourth year of a 5-year program(Sprint 2028 Grad)
• Minimum3.0cumulative 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 business analytics
• Solid foundation in Microsoft Excel and SQL
• 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, and SQL, with the ability to further develop and apply these skills
• Knowledge of open-source Data Science applications such as R and Python
• Works effectively both independently and in group settings
• Ability to demonstrate professionalism through clear communication, reliability, and the ability to represent AArete effectively with peers, senior leaders, and clients

Preferred Requirements

• Degree/Major in Business Analytics or related field
• Prior internship or project experience involving healthcare data, healthcare analytics, or healthcare organizations
• 3.3 or higher cumulative and major GPA
• Relevant work experience, including internships, summer positions, or part-time jobs
• Active involvement in university clubs or organizations related to business, analytics, or technology

Compensation

The estimated pay rate for this position is $33 / hr. Please note that this estimated rate is a guideline and individual total compensation may vary due to numerous factors including but not limited to experience level, certifications, and other relevant business considerations.

AArete will accept applications until September 18th, 2026.

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

AArete, LLC (“AArete”) may utilize Artificial Intelligence/Automated Decision-Making Technology/Automated Employment Decision Technology tools and resources (“AI” or “tools” or “resources”) to assist humans in generating job descriptions and postings, recruitment, analyzation of information, screening candidates, evaluation of candidate information, and assisting humans in the selection of potential candidates by all levels of AArete employees for all positions.

AArete may use Microsoft Co-Pilot, OpenAI ChatGPT, Anthropic Claude, Google Gemini, LinkedIn Recruiter AI and Hiring Assistant, Jobvite Talent Fit and AArete HireSense. AArete may use all the information you provide. Submission of information to AArete shall serve as consent to AArete’s use of AI tools and resources. AArete complies with all applicable law and does not use AI to discriminate against any individual and does not use location or geographic data like zip codes to act in a discriminatory or illegal manner. Your personal data may be used in relation to prospective employment with AArete and will only be retained for so long as legally necessary.

AArete shall comply with its posted privacy policies and candidates may contact Recruiting or Privacy Departments, as identified below, to request accommodations or to exercise any of your applicable rights, pursuant to applicable law:

Recruiting: [e-mail]

Privacy: [e-mail]

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.

#LI-DNI