RSM US LLP Logo

RSM US LLP

Business Intelligence Consulting Intern - Summer 2027

Posted 11 Days Ago
Be an Early Applicant
In-Office
Chicago, IL, USA
28-33 Hourly
Internship
In-Office
Chicago, IL, USA
28-33 Hourly
Internship
Supports business intelligence consulting engagements by gathering and documenting client requirements, building reports, dashboards, scorecards, prototypes, and demonstration scenarios, and providing ongoing client support. The intern collaborates with consultants across regions, applies SQL Server, T-SQL, data modeling, visualization, Excel, and ASP.NET skills, and contributes to solution delivery for clients across diverse industries.
The summary above was generated by AI

We are the leading provider of professional services to the middle market globally, our purpose is to instill confidence in a world of change, empowering our clients and people to realize their full potential. Our exceptional people are the key to our unrivaled, culture and talent experience and our ability to be compelling to our clients. You’ll find an environment that inspires and empowers you to thrive both personally and professionally. There’s no one like you and that’s why there’s nowhere like RSM.

As an intern in the Business Intelligence Consulting practice at RSM, you will work with various sized businesses in diverse industries and receive hands-on client experience. The Consulting Intern position is a client-facing role and you will be responsible for providing the highest level of operational support to RSM clients and the RSM engagement teams serving those clients. The successful candidate must demonstrate willingness to go the extra mile for the team’s success. They will be a problem solver, creative thinker, fast learner, be detail oriented and interested in learning new technology.  

 

Examples of the candidate’s responsibilities include: 

  • 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 

 

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), understanding of the appropriate purpose for each 

  • 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 and ability to arrange for use of reliable modes of transportation to those locations. 

  • Ability to travel up to 25% 

  • A minimum 3.0 GPA is preferred 

At RSM, we offer a competitive benefits and compensation package for all our people. We offer flexibility in your schedule, empowering you to balance life’s demands, while also maintaining your ability to serve clients. Learn more about our total rewards at https://rsmus.com/careers/working-at-rsm/benefits.

All applicants will receive consideration for employment as RSM does not tolerate discrimination and/or harassment based on race; color; creed; sincerely held religious beliefs, practices or observances; sex (including pregnancy or disabilities related to nursing); gender; sexual orientation; HIV Status; national origin; ancestry; familial or marital status; age; physical or mental disability; citizenship; political affiliation; medical condition (including family and medical leave); domestic violence victim status; past, current or prospective service in the US uniformed service; US Military/Veteran status; pre-disposing genetic characteristics or any other characteristic protected under applicable federal, state or local law. 

Accommodation for applicants with disabilities is available upon request in connection with the recruitment process and/or employment/partnership. RSM is committed to providing equal opportunity and reasonable accommodation for people with disabilities. If you require a reasonable accommodation to complete an application, interview, or otherwise participate in the recruiting process, please call us at 800-274-3978 or send us an email at [email protected].

RSM does not intend to hire entry-level candidates who require sponsorship now or in the future. This includes individuals who will one day request or require RSM to file or complete immigration-related forms or prepare letters on their behalf in order for them to obtain or continue their work authorization.

RSM will consider for employment qualified applicants with arrest or conviction records. For those living in California or applying to a position in California, please click here for additional information.

At RSM, an employee’s pay at any point in their career is intended to reflect their experiences, performance, and skills for their current role. The salary range (or starting rate for interns and associates) for this role represents numerous factors considered in the hiring decisions including, but not limited to, education, skills, work experience, certifications, location, etc. As such, pay for the successful candidate(s) could fall anywhere within the stated range.

Compensation Range: $28 - $33 per hour

RSM US LLP Chicago, Illinois, USA Office

30 S Wacker Dr, Chicago, IL, United States, 60606

RSM US LLP Schaumburg, Illinois, USA Office

Schaumburg, United States

Similar Jobs

3 Hours Ago
Hybrid
Internship
Internship
Cloud • Information Technology • Internet of Things • Machine Learning • Software • Cybersecurity • Infrastructure as a Service (IaaS)
Build and prototype AI-powered solutions, intelligent agents, automated workflows, data models, and Power BI dashboards for People Analytics. Extract and transform HR data using tools such as Power Query, Dataflows, Snowflake, and SQL. Apply Python, prompt engineering, and generative AI tools to improve HR insights, data access, decision-making, and employee experience while collaborating across HR and analytics teams.
Top Skills: Azure Ai FoundryChatgptClaudeCopilot StudioDataflowsGeminiGlean Work AiLarge Language ModelsMicrosoft CopilotPower BIPower QueryPythonSnowflakeSnowflake CortexSnowflake CoworkSQL
3 Hours Ago
In-Office
Expert/Leader
Expert/Leader
Cloud • Information Technology • Internet of Things • Machine Learning • Software • Cybersecurity • Infrastructure as a Service (IaaS)
Leads global commercial strategy for Ericsson Enterprise Wireless Solutions, overseeing pricing, subscription economics, portfolio profitability, value propositions, business-model innovation, and commercial governance. Partners with executive, product, sales, channel, finance, supply chain, and operations leaders to improve recurring revenue, win rates, margins, and customer value. Builds a global commercial management organization, develops scalable tools and processes, drives competitive intelligence, supports strategic deal shaping, and establishes enterprise standards for negotiation and price management.
Top Skills: Cloud ComputingSaaSTelecommunications
3 Hours Ago
In-Office
Expert/Leader
Expert/Leader
Cloud • Information Technology • Internet of Things • Machine Learning • Software • Cybersecurity • Infrastructure as a Service (IaaS)
Leads Ericsson’s Americas Automation Enablement function, defining AI, automation, data, and reporting roadmaps. Oversees a geographically dispersed team, prioritizes AI initiatives, scales proofs of concept into secure production services, and establishes governance for data quality, documentation, monitoring, responsible AI, and lifecycle management. Partners with global teams, suppliers, and matrixed stakeholders to improve network operations, profitability, tools strategy, and organizational transformation.
Top Skills: AIAi/MlAutomationDashboardsData ManagementNatural-Language InsightsReporting PlatformsWorkflow Automation

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account