Senior Analytics Associate Senior Analytics Associate …

in Chicago, IL, United States
Permanent, Full time
Be the first to apply
in Chicago, IL, United States
Permanent, Full time
Be the first to apply
Senior Analytics Associate
44498 ApplyButton Widget Job Field Widget

RSM currently has an opening for a business intelligence professional with a strong background in data modeling and business and data analysis to join our national Deal Analytics service line (an integrative part of the Transaction Advisory Services M&A practice) as a Senior Associate.

As a Senior Associate in the Great Lakes region, this individual will work closely with professionals in the Great Lakes region and other regions to design, develop and execute solutions for private equity and strategic clients to help evaluate their acquisition decisions and financing requirements. This individual will also work closely with teams to provide data support for financial due diligence projects.

Core responsibilities include:

  • Assist in project scoping and strategic planning

  • Research and study the business for a given project, critically dissect the strategy, and develop insightful analysis

  • Participate in client meetings (and potentially site visits) while interacting with top-level management to obtain pertinent information for financial analysis

  • Design and develop data integration workflows to integrate data from disparate source systems into an integrated business intelligence environment

  • Execute on a broad range of data and analytic techniques at the direction of practice managers and directors

  • Propose techniques to apply based on experience and familiarity with the project data set, innovating new techniques when necessary

  • Collaborate and work effectively with cross-functional RSM team members to develop and present project findings and assist in the preparation of client deliverables



  • Minimum bachelor’s degree in the field of accounting, business administration, economics, operations, mathematics, computer science, and/or information systems from an accredited university

  • Possesses a balance of strong financial and business acumen and ability to explain technical data concepts and analytical techniques in the language of business (including communication of concepts used and challenges encountered)

  • Strong oral, written, and interpersonal communication skills

  • Highly self-motivated with the ability to effectively prioritize, multi-task and execute tasks while under pressure

  • Demonstrates critical thinking and creative problem-solving skills, as well as the ability to apply theoretical concepts and best practices to solve business problems

  • Ability to work successfully and effectively in a team-oriented, collaborative environment, as well as independently

  • A self-starter who is confident when interacting with clients, internal team members and firm leadership

  • Consistently meets internal and client deadlines

  • Willingness and ability to travel overnight (up to 30%)

  • Eligibility to work within the U.S.

Technical Data Abilities

  • Strong knowledge of Microsoft Excel

  • Experience in constructing and managing dimensional data models

  • Experience in defining and managing ETL process and automating data integration routines (experience with Alteryx is a plus)

  • Experience using T-SQL scripts (functions, views, stored procedures, etc.) to manipulate and simplify access to data

  • Proficiency with the Microsoft business intelligence platform, including SQL Server databases, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), and Power BI

  • Experience with constructing tabular models in Microsoft’s Azure environment is strongly preferred

  • Experience in designing and developing reporting and data visualization solutions (preference is Power BI or Tableau) is strongly 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.

Text/HTML Job ID: Job Field Widget req14004 Text/HTML Line of Business: Job Field Widget Consulting Services Text/HTML SubFunction: Job Field Widget TAS Deal Analytics Text/HTML Job Type: Job Field Widget FullTime Text/HTML Req #: Job Field Widget req14004 Text/HTML Location: Job Field Widget Chicago, IL US Text/HTML Region: Job Field Widget Great Lakes Region Text/HTML Job Category: Job Field Widget Business Consulting/Technology Text/HTML Employment Type: Job Field Widget Experienced Text/HTML Degree Required: Job Field Widget Bachelor Text/HTML Travel: Job Field Widget Yes ApplyButton Widget Social Sharing