Supervisor, Data Architect

RSM Canada Operations ULC; Toronto; Hybrid; CAD 88,000 - 162,000; Full time

Job summary

RSM Canada Operations ULC is seeking a senior data & BI professional to design scalable data models and build end-to-end ETL pipelines. You will develop semantic models and dashboards based on business needs, and collaborate with clients and regional teams to drive data-driven decisions.

The role requires 5+ years in BI, data modeling, and data pipeline development across multiple domains, with strong SQL and cloud platform experience (Azure/AWS/GCP). Hybrid work arrangements are common.

Qualifications

• Bachelor's degree or equivalent in Math, CS, IS, Finance, Economics or Analytics.
• 5+ years designing data models across multiple domains.
• 5+ years building BI solutions and data pipelines.
• 5+ years ingesting data into data lakes/warehouses.
• Proficient in SQL; experience with Python/Scala.
• Experience with major cloud platforms (Azure, AWS or GCP).
• Experience with data platforms like Fabric, Databricks or Snowflake.
• Experience with BI tools like Power BI, Quick Sight or Tableau.

Responsibilities

• Create and maintain dimensional and 3NF data models.
• Design and develop ETL pipelines consolidating data from multiple sources.
• Develop Semantic Models and reports/dashboards based on business requirements.
• Facilitate requirements sessions and analyze data needs to support business objectives.
• Collaborate with clients and teams across regions.

Skills

SQL

Python/Scala

Data modeling

BI reporting

Communication

Education

Bachelor's degree

Tools

Databricks

Snowflake

Power BI

Azure/AWS/GCP

Git/CI-CD

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

• 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.
• Develop Semantic Models and Reports / Dashboards based on business requirements.
• Facilitate business requirements sessions and conduct data analysis to accurately identify and specify the data needed to support impactful business objectives.
• 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.
• 5+ years of experience designing data models across multiple subject areas and business domains.
• 5+ years of experience in designing and developing business intelligence solutions.
• 5+ 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.
• 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.

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.

Preferred Qualifications

• Experience conducting solution / technical assessments.
• Experience with DBT, Spark and BigData technologies.
• 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. 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 [e-mail].

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: $88,000 - $162,000.

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

Why work at RSM?

At RSM, we accomplish meaningful work and make an impact on the world around us. We work hard to fully understand our clients and work even harder to understand and identify your unique skills. We celebrate the differences among us and empower our talented professionals to grow forward, both personally and professionally. Our clients benefit from fresh insights and energy as we collaborate to support them, and our teams enjoy a work environment that inspires and empowers them to thrive.