Data Analytics 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. Youll find an environment that inspires and empowers you to thrive both personally and professionally. Theres no one like you and thats why theres 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:

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

Required Qualifications:

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

Preferred Qualifications:

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

At RSM we offer a competitive benefits and compensation package for all our offer flexibility in your schedule empowering you to balance lifes demands while also maintaining your ability to serve clients. Learn more about our total rewards at does not tolerate discrimination and/or harassment based on race; colour; 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; 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 Canadian uniformed service; Canadian Military/Veteran status; pre-disposing genetic characteristics or any other characteristic protected under applicable provincial employment legislation.

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 or send us an email at .

At RSM an employees 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.