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 is looking to hire a Data Analyst on our National Finance and Operations team.

The Data Analyst is responsible for the development, automation, and compilation of data. This position will prepare reports through Excel, Access, SharePoint, and Power BI using compiled data from several internal systems.

Essential Duties

Analytical duties may include but are not limited to:

• Developing data and storage requirements, reporting, analytics, and delivery methods in data standards and metadata.
• Develop, analyze, and evaluate data to create and maintain business intelligence frameworks.
• Integrate and mine large data sets, connecting data from disparate sources to identify critical insights and pragmatic data solutions.
• Maintain/update/create technical specifications (ex. data mapping, data flows, and dashboard content).
• Develop real-time reporting for analyzing KPIs.
• Design and create analysis and reports that include summaries, graphs, diagrams, and other visual representations in BI or excel.
• Develop and maintain forecasting databases/tools and provide analysis to leaders on outcomes.
• Discover and define new processes for improvement and opportunities.

Minimum Qualifications

• Bachelor's degree or equivalent experience. Accounting or Finance major preferred.
• Strong Microsoft Office skills.
• Ability to communicate effectively both verbally and written.
• Ability to work autonomously and part of a team.
• Effective organization and time management skills.
• Solid understanding of developing data requirements.
• Knowledge of Excel, Power BI, SQL, and understanding of concepts of database structures and data querying.
• Advanced Microsoft Office skills with exposure to Visual Basic.
• Previous experience with SQL preferred.
• Previous experience with a Business Intelligence (BI) tool preferred.
• Previous experience analyzing data and predicting future outcomes preferred.
• Prepare and review monthly work papers; perform account reconciliations, investigate general ledger balance discrepancies.
• Assist with month-end closing process.

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 .

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 .

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.