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 has an opening for a Senior Associate focused on Business Intelligence in our Technology Consulting Practice. This is a client-facing role focusing on the sale, implementation, and support of Business Intelligence products and services for health care organizations. You will work closely with Project Managers and fellow Consultants in conducting multiple client projects ranging from consulting services, customization design, and technical support, to full implementation. The successful candidate must be knowledgeable in all aspects of design and construction of health care Business Intelligence solutions. They will be a problem solver, creative thinker, fast learner, be detail-oriented, and interested in learning their clients' business.

Responsibilities:

• Guide clients and prospects in their evaluation of Business Intelligence solutions providing information and demonstrations to help them assess fit for their business

• Design, architect, implement and support simple to complex enterprise data warehouses using Microsoft SQL on-premises or cloud technologies including Azure and Snowflake

• Scope the implementation services required to help clients achieve their objectives including clinical details and health care KPIs.

• Ensure completion of tasks, milestones, and components including but not limited to functional specifications, design specifications, configurations, quality assurance, implementations, and project reviews

• Spearheads development of logical and physical data models, and ETL development, as needed

• Building reports, dashboards and scorecards using a variety of tools

• Train end users and system administrators

• Provide clients with ongoing technical support and troubleshooting

• Lead additional optimization projects as clients businesses change and grow

• Work on multiple projects at the same times

• Interact effectively with internal and external resources at all organizational levels
   

Basic 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, Business or Health Care

• Proficiency with Microsoft SQL Server Database Engine (database development and tuning), Azure Data Factory, SQL Server -Integration Services (SSIS), SQL Server Reporting Services (SSRS)Experience using  T-SQL scripts (stored procedures, views, functions etc.) to manipulate data and simplify access to data

• Also will consider strong Oracle, SAP Hana, Microstrategy, and/or Snowflake analytics experience

• 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

• Deep understanding of health care data and business model

• Knowledge of data sources and models from multiple Electronic Medical Records (EMRs) including Epic or Cerner

• FHIR or HL7 experience preferred

• Experience with designing visualizations in multiple BI tools including Tableau and PowerBI

• Ability to communicate effectively, both in writing and verbally, with clinicians and health care leadership

• 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 health care

• Curiosity about business and technology

• Experience with the following will be a plus: SQL Server Analysis Services (SSAS)SQL Server Integration Services (SSIS)QlikView/QlikSense SharePoint Microsoft SQL Server

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 [email protected].

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.

Compensation Range: $82,400 - $156,200