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, inclusive 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.

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, anddocumenting 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 minimum 3 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

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

At RSM, we offer a competitive benefits and compensation package for all our people. We support and inspire you to prioritize your wellbeing by delivering personalized, holistic programming for your physical, emotional, financial and community wellbeing. RSM has a generous time off policy with at least 14 paid holidays, wellbeing days and associate and above access to self-managed time off. 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.

RSM is proud to be an Affirmative Action and Equal Employment Opportunity employer. We are proud to provide our employees with tools to assist them in being successful in achieving both personal and professional goals. We welcome and support all our employees to thrive in an environment free of discrimination and harassment. As an Affirmative Action and Equal Opportunity Employer 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 (including gender identity and/or gender expression); 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; 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 careers@rsmus.com.

RSM does not intend to hire entry level candidates who will require sponsorship now OR in the future (i.e. F-1 visa holders). However, those candidates who may be recent U.S. college / university graduates possessing 1-2 years of progressive and relevant work experience, excluding internships, in the U.S. or his/her home country would be eligible for hire as an experienced candidate and thus eligible for sponsorship.

Compensation Range: $68,400 - $123,700

RSM is the leading provider of audit, tax and consulting services to the middle market, with over 16,600 professionals across the U.S., Canada, El Salvador and India. RSM has a global presence in 120 countries, we are focused on developing leading professionals and innovative services to meet our clients’ evolving needs in today’s ever-changing business environment. Our culture embodies inclusiveness and understanding, empowering our people to be their authentic selves, share their unique perspectives and own their futures to achieve their personal and professional aspirations.