Transaction Advisory Services - Deal Analytics Senior Associate

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.

RSM currently hasanopening fora business intelligence professional with a strongbackground in data modeling and business and data analysisto join ournationalDeal Analyticsservice line (an integrativepart of the Transaction Advisory ServicesM&Apractice) as an experienced professional.

As an experienced professional inTransaction Advisory,this individual willwork closely with professionals in the national practicedesign, develop and execute solutionsfor 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 supportforfinancial due diligence projects.

Core responsibilities include:

• Assistin project scoping and strategic planning

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

• Participatein 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 theprojectdata set, innovating new techniques when necessary

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

Requirements:

General

• Bachelor's degree

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

• 3+years experienceworking within a large public accounting or consulting firm

• Strongoral, written, and interpersonal communication skills

• Highly self-motivated with the ability to effectively prioritize, multi-taskand execute taskswhile 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 successfullyand effectivelyin 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%)

TechnicalData Abilities

• Strong knowledge of Microsoft Excel

• Experience in constructing and managing dimensionaldata models

• Experience in defining and managing ETL processand 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'sAzure environment is strongly preferred

• Experience in designing and developing reportingand data visualization solutions(preference isAlteryx,Power BI or Tableau)is strongly preferred

At RSM, we offer a competitive benefits and compensation package for all our people.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.

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; US Military/Veteran status; 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). If you are a recent U.S. college / university graduate possessing 1-2 years of progressive and relevant work experience in a same or similar role to the one for which you are applying, excluding internships, you may be eligible for hire as an experienced associate.

RSM will consider for employment qualified applicants with arrest or conviction records in accordance with the requirements of applicable law, including but not limited to, the California Fair Chance Act, the Los Angeles Fair Chance Initiative for Hiring Ordinance, the Los Angeles County Fair Chance Ordinance for Employers, and the San Francisco Fair Chance Ordinance. For additional information regarding RSM's background check process, including information about job duties that necessitate the use of one or more types of background checks, click here.

At RSM, an employee's pay at any point in their career is intended to reflect their experiences, performance, and skills for their current role. The salary range (or starting rate for interns and associates) for this role represents numerous factors considered in the hiring decisions including, but not limited to, education, skills, work experience, certifications, location, etc. As such, pay for the successful candidate(s) could fall anywhere within the stated range.