2022- Summer - Consulting Associate - Data and Digital Services - Data Analytics DIMS

Washington DC
Business Consulting/Technology

Job Description

Req ID: req21520

2022- Summer - Consulting Associate - Data and Digital Services - Data Analytics DIMS Summary:

Data & Digital Solutions - Data Integration & Migration Services (DIMS) - Associate

Position Description

As an Associate in the Data Integration & Migration Services Consulting practice at RSM, you will work with various sized businesses in diverse industries and receive hands-on client experience. This 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.

Responsibilities include:

• Executing solution delivery engagements
• Discerning, defining, refining, and documenting client requirements
• Building ETL (extract, transform, load) processes, 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:

• Currently pursuing or recently completed a Bachelor's or Master's degree in Math, Computer Science, Information Systems, Business Administration, Data Science or Business Analytics

• Developing proficiency with Microsoft SQL Server, Azure SQL Database, and Azure Data Factory.
• Experience using T-SQL scripts (stored procedures, views, functions etc.), Alteryx to transform data and simplify access to data
• Experience with data modeling (normalized and de-normalized data models), understanding of the appropriate purpose for each
• 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.
• Ability to travel up to 25%

• A minimum 3.0 GPA is preferred

You want your next step to be the right one. You've worked hard to get where you are today. And now you're ready to use your unique skills, talents and personality to achieve great things. RSM is a place where you are valued as an individual, mentored as a future leader, and recognized for your accomplishments and potential. Working directly with clients, key decision makers and business owners across various industries and geographies, you'll move quickly along the learning curve and our clients will benefit from your fresh perspective.

Experience RSM US. Experience the power of being understood.

RSM is an equal opportunity/affirmative action employer. Minorities/Females/Disabled/Veterans.

Location Street Address: 2021 L St NW, Washington, DC 20036 USA
Region: Southeast Region
Position Type: Campus Associate
Job Type: Full Time
Degree Required: Bachelor
Travel Required: Yes
Sponsor candidates who are not eligible to work in US: No
Requisition ID: req21520