Business Intelligence Intern: Build Dashboards & Insights

RSM US LLP; Irvine (CA); On-site; USD 39,000 - 45,000; Full time

Job summary

RSM US LLP in Irvine, CA is seeking an intern for the Business Intelligence Consulting practice. You will gain hands-on client experience delivering solution engagements, defining requirements, and building dashboards using varied tools while supporting engagement teams across regions.

The role requires pursuing a BA/BS or higher in relevant fields, strong Excel, SQL knowledge, and ability to travel up to 25%.

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

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

Education

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

Tools

SQL Server

SQL

Excel

T-SQL

Data Visualization

ASP.NET

Job description

RSM US LLP in Irvine, CA is seeking an intern for the Business Intelligence Consulting practice. You will gain hands-on client experience delivering solution engagements, defining requirements, and building dashboards using varied tools while supporting engagement teams across regions.

The role requires pursuing a BA/BS or higher in relevant fields, strong Excel, SQL knowledge, and ability to travel up to 25%.