Business Intelligence Consulting Associate - Fall 2027

rsm; Des Moines (IA); On-site; USD 22,000 - 36,000; Full time

Job summary

RSM in Des Moines is seeking a student for an internship focused on analytics and solution delivery. You will collaborate with senior consultants to capture client requirements, build reports and dashboards, and develop demonstration prototypes.

You will gain hands-on experience with SQL Server, SSRS/SSIS, data modeling, and data visualization while working in virtual teams. Travel up to 25% may be required; a 3.0 GPA is 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
• 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

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
• 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

Skills

Microsoft SQL Server

SQL Server Reporting Services

SQL Server Integration Services

Data Visualization tools

Excel

T-SQL

Data modeling

ASP.NET

Communication skills

Team collaboration

Education

BA/BS in Business Administration, Accounting, Computer Science, Data Science/Analytics, MIS

Pursuing Bachelor's or Master's degree

Tools

ASP.NET framework

Job description

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.

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
• 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

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
• 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

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 [e-mail] .

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, pleas