BI Consulting Intern — Data Analytics & Dashboards

RSM; Chicago (IL); On-site; USD 39,000 - 45,000; Full time

Job summary

RSM in Chicago is seeking a Business Intelligence Consulting intern to gain hands-on client experience while helping deliver solutions, document requirements, and build reports and dashboards.

You will work with cross‑regional consultants, learn SQL Server tools (SSRS/SSIS), data modeling, and ASP.NET basics, while developing strong communication and project management skills. Travel up to 25% and a GPA of 3.0+ preferred.

Qualifications

• Working towards B.A. or B.S. degree or equivalent from an accredited university.
• Currently pursuing or recently completed a Bachelor’s or Master’s degree in Business Administration, Accounting, Computer Science, Data Science/Analytics, Management Information Systems.
• 90 credit hours completed.
• Developing proficiency with Microsoft SQL Server Database Engine (database administration/maintenance), SQL Server Reporting Services, SQL Server Integration Services.
• Ability to work with Data Visualization tools and dashboards for reporting and storytelling purposes.
• Strong Excel fundamentals.
• Experience using T-SQL scripts (stored procedures, views, functions etc.) to manipulate data and simplify access to data.
• Experience with data modeling/manipulation (normalized and de-normalized data models).
• Experience developing basic web/desktop applications using ASP.NET framework.
• Ability to communicate effectively, both in writing and verbally.
• Ability to interact effectively with internal and external resources at all organizational levels.
• Excellent project management, organization, and follow-up skills.
• Strong critical thinking and problem-solving skills.
• Must be a team player; able to work in virtual teams and independently.
• Travel to assigned client locations is required. Must have access to reliable transportation.
• Ability to travel up to 25%.
• A minimum 3.0 GPA is preferred.

Responsibilities

• Executing solution delivery engagements.
• Discerning, defining, refining, and documenting client requirements.
• Building reports, dashboards and scorecards using a variety of tools.
• Providing ongoing support to existing clients.
• Building out demonstration scenarios and prototypes.
• Collaborating and working effectively with consultants in other regions and practices.

Skills

Problem solving

Communication

Teamwork

Organization

Project management

Critical thinking

Data storytelling

Education

Bachelor's or master's degree in relevant field

90 credit hours completed

Pursuing or recently completed degree in Business Admin, Accounting, CS, Data Science/Analytics, MIS

Tools

Microsoft SQL Server

SQL Server Reporting Services

SQL Server Integration Services

T-SQL

ASP.NET

Excel

Job description

RSM in Chicago is seeking a Business Intelligence Consulting intern to gain hands-on client experience while helping deliver solutions, document requirements, and build reports and dashboards.

You will work with cross‑regional consultants, learn SQL Server tools (SSRS/SSIS), data modeling, and ASP.NET basics, while developing strong communication and project management skills. Travel up to 25% and a GPA of 3.0+ preferred.