Sr. Associate, Data & Analytics

RSM Canada

Calgary

On-site

CAD 79,000 - 126,500

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

Competitive benefits package

Flexible schedule

Job summary

A leading consulting firm is seeking a skilled Sr. Associate, Data & Analytics in Calgary. The role involves designing data models, developing data pipelines, and collaborating with teams. Candidates should have a bachelor's degree and extensive experience in data analytics. A competitive salary range of $79,000 – $126,500 is offered, alongside discretionary bonuses.

Qualifications

3+ years of experience designing data models across multiple subject areas and business domains.
3+ years of experience designing and developing business intelligence solutions.
3+ years of optimizing data pipeline processes and database structures.

Responsibilities

Facilitate business requirements sessions and conduct data analysis.
Create and maintain data models aligned with business requirements.
Design and develop data pipelines that consolidate data.

Skills

Data modeling

Business analytics

SQL

Python (e.g., PySpark, Pandas)

Communication skills

Critical thinking

Education

Bachelor’s degree in relevant field

Tools

AWS

Azure

Google Cloud Platform

Power BI

Tableau

Snowflake

SQL Server

SSIS

SSAS

Job description

Join to apply for the Sr. Associate, Data & Analytics role at RSM Canada

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.

We are seeking a skilled Business Intelligence & Data Engineering professional with a strong background in design and development, data modeling, and business analytics. This individual will collaborate closely with our Data Analytics team to:

Facilitate business requirements sessions and conduct data analysis to accurately identify and specify the data needed to support impactful business objectives.
Create and maintain data models (dimensional and 3NF) aligned with business requirements.
Design and develop data pipelines that consolidate data from various source systems into a unified data platform, including defining source‑to‑target mappings, business rules, and any necessary data transformations.
Develop reports and dashboards based on business requirements.
Collaborate effectively with clients and team members across regions.

Basic Qualifications

Bachelor’s degree or equivalent experience in Math, Computer Science, Information Systems, Finance, Accounting, Economics, or Analytics.
3+ years of experience designing data models across multiple subject areas and business domains.
3+ years of experience designing and developing business intelligence solutions.
3+ years of optimizing data pipeline processes and database structures.
Proven experience with major cloud service providers such as AWS, Azure, or Google Cloud Platform.
Proficient in BI visualization tools such as Power BI or Tableau.
Experience with data platforms such as Snowflake and MS Fabric.
Familiarity with SQL Server, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and other data management tools.
Proficient in SQL and Python (e.g., PySpark, Pandas).
Expertise in defining, managing, and automating data pipelines/workflows.
Strong communication skills, both written and verbal.
Excellent critical thinking and problem‑solving abilities.
Team‑oriented with the ability to work independently and in virtual teams.
Passion for solving complex business problems through data‑driven solutions.

Preferred Qualifications

Experience conducting solution/technical assessments.
Knowledge of Databricks.
Working knowledge of the modernized information management tool (e.g., Collibra, Informatica, Talend, Alation, Purview).

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 also maintaining your ability to serve clients. Learn more about our total rewards at https://rsmcanada.com/careers/life-at-rsm/rewards-and-benefits.html.

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 careers@rsmus.com.

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: $79,000 – $126,500

Individuals selected for this role will be eligible for a discretionary bonus based on firm and individual performance.

Seniority Level

Mid‑Senior level

Employment Type

Full‑time

Job Function

Information Technology

Industry

Accounting

Location

Surrey, British Columbia, Canada