RSM US LLP Logo

RSM US LLP

Business Intelligence Consulting Associate - Fall 2027

Posted 15 Days Ago
Be an Early Applicant
In-Office
Toronto, ON, CAN
Entry level
In-Office
Toronto, ON, CAN
Entry level
Supports client-facing business intelligence consulting engagements by defining and documenting requirements, delivering reports, dashboards, scorecards, prototypes, and demonstrations. Provides ongoing client support and collaborates with consultants across practices. The role requires developing proficiency with Microsoft SQL Server, SSRS, SSIS, T-SQL, data visualization, data modeling, Excel, and ASP.NET, along with strong communication, organization, problem-solving, and teamwork skills.
The summary above was generated by AI

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.

As an associate in the Business Intelligence Consulting practice at RSM, you will work with various sized businesses in diverse industries and receive hands-on client experience. This is a client-facing role and you will be responsible for providing the highest level of operational support to RSM clients and the RSM engagement teams serving those clients. The successful candidate must demonstrate willingness to go the extra mile for the team’s success. They will be a problem solver, creative thinker, fast learner, be detail oriented and interested in learning new technology.  

 

Examples of the candidate’s responsibilities include: 

 

  • Executing solution delivery engagements 

  • Discerning, defining, refining, and documenting client requirements 

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

  • Providing ongoing support to existing clients 

  • Building out demonstration scenarios and prototypes 

  • Collaborating and working effectively with consultants in other regions and practices 

 

Qualifications: 

 

  • Working towards B.A. or B.S. degree or equivalent from an accredited university   

  • Currently pursuing or recently completed a Bachelor’s or Master’s degree in Business Administration, Accounting, Computer Science, Data Science/Analytics, Management Information Systems 

  • Ability to travel to the United States for the purpose of performing work or attending training during your tenure in this role is a requirement of this position 

  • Developing proficiency with Microsoft SQL Server Database Engine (database administration/maintenance), SQL Server Reporting Services, SQL Server Integration Services 

  • Ability to work with Data Visualization tools and dashboards for reporting and storytelling purposes 

  • Strong Excel fundamentals 

  • Experience using T-SQL scripts (stored procedures, views, functions etc.) to manipulate data and simplify access to data 

  • Experience with data modeling/manipulation (normalized and de-normalized data models), understanding of the appropriate purpose for each 

  • Experience developing basic web/desktop applications using ASP.NET framework 

  • Ability to communicate effectively, both in writing and verbally 

  • 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 

  • Travel to assigned client locations is required. Must have access to and ability to arrange for use of reliable modes of transportation to those locations. 

  • Ability to travel up to 25% 

  • A minimum 3.0 GPA is preferred 


At RSM, we offer a competitive benefits and compensation package for all our people. Learn more about our total rewards at https://rsmcanada.com/careers/life-at-rsm/rewards-and-benefits.html.


We believe flexibility and in-person connection both play an important role in how we work and grow. Most roles at RSM follow a hybrid workstyle, which means team members are aligned to an RSM office and come together in person when it best supports clients, teams, development or relationship-building. Some roles may be virtual or primarily on-site based on role requirements, team priorities and client needs.


RSM 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 800-274-3978 or send us an email at [email protected].


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: $61,600 - $73,500

Similar Jobs

28 Minutes Ago
Hybrid
Toronto, ON, CAN
Expert/Leader
Expert/Leader
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Lead technology risk and governance across five enterprise technology asset management transformation workstreams for a major Canadian bank. Responsibilities include risk assessments, control design and testing, audit evidence management, regulatory remediation, governance reporting, issue escalation, and remediation tracking. The role partners with architects, information security teams, technology leaders, risk functions, and delivery partners to embed effective controls and ensure compliance with enterprise policies, security standards, and regulatory expectations.
Top Skills: ArcherCgeitCobitGovernance Risk And ComplianceIso 27001Itil 4Servicenow Integrated Risk Management
29 Minutes Ago
Hybrid
Toronto, ON, CAN
Expert/Leader
Expert/Leader
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Leads organizational change and Build-Operate-Transfer activities across five enterprise technology asset management workstreams. Develops change strategies, stakeholder plans, impact assessments, communications, training, SOPs, runbooks, knowledge-transfer plans and readiness evaluations. Supports adoption of ServiceNow, CMDB and technology asset lifecycle management capabilities, partnering with senior stakeholders and delivery teams to embed sustainable operating models and transition capabilities into business-as-usual operations within a major Canadian financial institution.
Top Skills: Configuration Management Database (Cmdb)Itil 4SafeServicenowTechnology Asset Lifecycle Management (Talm)
29 Minutes Ago
Hybrid
Toronto, ON, CAN
Senior level
Senior level
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Lead integrated delivery of a five-workstream Enterprise Technology Asset Management transformation for a Tier 1 Canadian bank. Manage governance, risks, issues, dependencies, resources, milestones, executive reporting, financials, vendor performance, and delivery commitments. Serve as the primary client contact, align senior stakeholders and distributed technology teams, resolve delivery challenges, and translate strategy into measurable outcomes across Agile, Waterfall, and hybrid environments.
Top Skills: AgileHybrid DeliveryServicenowWaterfall

What you need to know about the Toronto Tech Scene

Although home to some of the biggest names in tech, including Google, Microsoft and Amazon, Toronto has established itself as one of the largest startup ecosystems in the world. And with over 2,000 startups — more than 30 percent of the country's total startups — Toronto continues to attract new businesses. Be it helping entrepreneurs manage their finances, simplifying business operations by automating payroll or assisting pharmaceutical companies in launching new drugs, the city's tech scene is just getting started.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account