As a Manager within the Great Lakes region's practice, the Data & Analytics Consultant will be responsible for working with the Data & Analytics practice leadership in the region to serve clients, by:

• Executing solution delivery engagements Discerning, defining, refining, and documenting client requirements
• Effectively managing relationship with customer technical leads and business stakeholders
• Thinking proactively and acting with complete follow-through
• Designing and developing data warehouses, data ,marts, and data models
• 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

Required Qualifications:

• Bachelor's degree or graduate degree and 6-8 years of related work experience degree with an emphasis in Math, Computer Science, Information Systems, or Business
• Proficiency with ETL(extract, transform, load), Microsoft SQL Server Database Engine (database development and tuning), Azure Data Factory
• Experience with data migrations and conversions
• Experience using T-SQL scripts (stored procedures, views, functions etc.) to manipulate data and simplify access to data
• Experience with data modeling (3NF and dimensional data models), understanding of the appropriate purpose for each
• Strong focus and ability to manage and construct Dimensional Data Warehouses
• Experience with Power BI for data modeling and creating visualizations
• 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
• Willingness and ability to travel
• Strong financial and business acumen, and ability to speak about technology in the language of business
• Curiosity about business and technology
• Experience with the following will be a plus: SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS)

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.

Job ID: req21013_Indianapolis

Line of Business: Consulting Services

SubFunction: DDS DA DIMS

Job Type: FullTime

Req #: req21013_Indianapolis

Location: Indianapolis, IN US

Region: Great Lakes Region

Job Category: Business Consulting/Technology

Employment Type: Experienced

Degree Required: Bachelor

Travel: Yes