Business Intelligence Consulting Associate Fall 2026

RSM; Vancouver; On-site; CAD 61,000 - 74,000; Full time

Job summary

A leading professional services firm in Vancouver is seeking an Associate in the Business Intelligence Consulting practice. The role involves working closely with clients to deliver operational support, develop reports, and collaborate with teams. Candidates should be exploring degrees in relevant fields and show proficiency in data visualization and SQL. Competitive compensation between $61,600 and $73,500 annually. Travel up to 25% may be required.

Qualifications

• Working towards Bachelor's or Master's degree from an accredited university.
• Developing proficiency with SQL Server Database Engine and Reporting Services.
• Ability to communicate effectively and work with virtual teams.

Responsibilities

• Execute solution delivery engagements.
• Build reports, dashboards, and scorecards.
• Provide ongoing support to existing clients.

Skills

Business Intelligence

Cognos

SQL

Power BI

QlikView

Data Visualization

SSRS

Tableau

SSIS

Data Modeling

Data Warehouse

Data Analysis Skills

Education

B.A. or B.S. degree or equivalent

Bachelor's or Master's degree in Business Administration, Accounting, Computer Science, Data Science/Analytics, Management Information Systems

Tools

Microsoft SQL Server

Data Visualization tools

Job description

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.

As a n 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 toRSM clients and the RSM engagement teams serving those clients. The successful candidate must demonstrate willingness to go the extra mile for the teams success. They will be a problem solver creative thinker fast learner be detail oriented and interested in learning new technology .

Examples of the candidates responsibilities include :

Responsibilities

• Executin g 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 Bachelors or Masters degree in Business Administration Accounting Computer Science Data Science / Analytics Management Information Systems
• 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 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 . 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 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.

Compensation Range : $61600 - $73500

Required Experience : IC

Key Skills

• Business Intelligence
• Cognos
• SQL
• Power BI
• QlikView
• Data Visualization
• ssrs
• Tableau
• SSIS
• Data Modeling
• Data Warehouse
• Data Analysis Skills

Employment Type : Full-Time

Experience : years

Vacancy : 1

Monthly Salary Salary : 61600 - 73500