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. We are seeking a skilled Business Intelligence and 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:Create and maintain data models (dimensional and 3NF) aligned with business requirements.Design and develop ETL 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.Facilitate business requirements sessions and conduct data analysis to accurately identify and specify the data needed to support impactful business objectives.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 in designing and developing business intelligence solutions.3+ years of designing and developing scalable, efficient data pipelines to ingest, transform, and load data from multiple sources into data lakes and data warehouses.Proficient in SQL.Experience with Python/Scala.Proven experience with major cloud platforms such as Microsoft Azure, AWS or GCP.Experience with data platforms like Fabric, Databricks or Snowflake.Experience with GIT, DevOps, CI/CD and Version Control.Experience with BI visualization tools such as Power BI,



Quick Sight or Tableau.Team-oriented with the ability to work independently and in virtual teams.Passion for solving complex business problems through data-driven solutions.This role requires periodic travel to the United States for business purposes. Candidates must be able to meet the travel requirements of the position, which may include up to 20% travel.Experience conducting solution / technical assessments.Experience with DBT, Spark and BigData technologies.Knowledge of Databricks.Collibra, Informatica, Talend, Alation, Purview).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.Sincerely held religious beliefs, practices or observances;
sex (including pregnancy or disabilities related to nursing);
national origin;
physical or mental disability;
medical condition (including family and medical leave);
domestic violence victim status;
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 prospect and reasonable accommodation for people with disabilities.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. Individuals selected for this role will be eligible for a discretionary bonus based on firm and individual performance.

📌 Senior Big Data Engineer - Remote (Toronto)
🏢 RSM Canada Operations ULC
📍 Toronto