Sr. Associate, Data Engineering

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.

As a Sr. Data Engineering Consultant, you 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 at least 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 up to 40% (with potential for more)

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

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; s