Data Analytics Associate

About the role

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 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.

The Data Analytics Associate develops and analyzes data requirements, integrates large data sets, and creates business intelligence frameworks to identify critical insights. They design real-time reporting and visual representations of KPIs, maintain technical specifications, and provide forecasting analysis to leaders, while continuously discovering new improvement opportunities.

Responsibilities

• Develop 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, and create technical specifications (e.g., 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.

Requirements

• Bachelor’s degree or equivalent experience.
• Accounting or Finance major preferred.
• Advanced Microsoft Office skills with exposure to Visual Basic.
• Ability to communicate effectively both verbally and in writing.
• Ability to work autonomously and as 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.

Preferred Qualifications

• Previous experience with SQL.
• Previous experience with a Business Intelligence (BI) tool.
• Previous experience analyzing data and predicting future outcomes.

Benefits

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 maintaining your ability to serve clients. Learn more about our total rewards.

Pay

Compensation Range: $66,100 - $110,000. Individuals selected for this role will be eligible for a discretionary bonus based on firm and individual performance.