LiftmyCVLiftmyCV

Supervisor, Data Architect

RSM US LLPOn-siteChicago, US$95,400–$192,000 per year
AI job summary

RSM is seeking a skilled Business Intelligence and Data Engineering professional to join their Data Analytics team. The role involves creating data models, designing ETL pipelines, and developing reports and dashboards to meet business requirements. Candidates should have a Bachelor’s degree or equivalent experience, with at least 5 years in data modeling and business intelligence solutions. Proficiency in SQL, cloud platforms, and BI visualization tools is essential. RSM offers a competitive benefits package and follows a hybrid workstyle, combining both in-office and remote work.

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, 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 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.
  • 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.
  • Willingness and ability to 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. 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. All applicants will receive consideration for employment as RSM does not tolerate discrimination and/or harassment based on race; color; creed; sincerely held religious beliefs, practices or observances; sex (including pregnancy or disabilities related to nursing); gender; sexual orientation; HIV Status; 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 US uniformed service; US Military/Veteran status; pre-disposing genetic characteristics or any other characteristic protected under applicable federal, state or local law. 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 or send us an email. RSM does not intend to hire entry level candidates who will require sponsorship now OR in the future (i.e. F-1 visa holders). If you are a recent U.S. college / university graduate possessing 1-2 years of progressive and relevant work experience in a same or similar role to the one for which you are applying, excluding internships, you may be eligible for hire as an experienced associate. RSM will consider for employment qualified applicants with arrest or conviction records. For those living in California or applying to a position in California, please click here for additional information. 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: $95,400 - $192,000 Individuals selected for this role will be eligible for a discretionary bonus based on firm and individual performance.

Responsibilities

Create and maintain data models aligned with business requirements. Design and develop ETL pipelines that consolidate data from various source systems. Develop Semantic Models and Reports / Dashboards based on business requirements. Facilitate business requirements sessions and conduct data analysis. Collaborate with clients and team members across regions.

Job details

Published
October 28, 2026
Job source
myworkdayjobs
Workplace
On-site · Chicago, US
First seen
October 29, 2026

Benefits

RSM offers a competitive benefits and compensation package for all our people.

Skills mentioned in this job

SQLPythonScalaMicrosoft AzureAWSGCPFabricDatabricksSnowflakeGITDevOpsCI/CD

LiftmyCV exclusive data

RSM US LLP hiring intelligence

RSM US LLP currently has 6 active jobs tracked by LiftmyCV. 5 new jobs in the past 7 days.

Active openings

6

Currently tracked by LiftmyCV

New in 7 days

5

6 new jobs in the past 30 days

Published salaries

—

Not published by this employer yet

Average opening age

2 days

Across 6 active openings

Workplace breakdown

Remote0%
Hybrid17%
On-site83%

Hiring countries

United States of America

Top hiring cities

Chicago
Austin
Miami
New York

Most in-demand roles

  • • Cyber Response & Remediation Delivery Lead
  • • Manager – Zuora Revenue (RevPro) Consulting
  • • Portfolio Delivery Leader
  • • Process Transformation Manager
  • • Senior Associate QA Tester
  • • Senior Associate, Financial Due Diligence

As of November 17, 2026

Hiring insights calculated from active jobs tracked by LiftmyCV.

AI match explained

See how well you match this job

Log in or sign up and Eva will compare your profile with this role, explain your strengths and show what to improve.

Sign up to see your matchAlready have an account? Log in

More at RSM US LLP

Similar jobs from this company

Across the market

Similar jobs from other companies

Related job searches

Third-party content disclaimer

Full job descriptions are sourced directly from third-party applicant tracking systems (ATS), job boards, recruitment platforms, and employer career pages.

LiftmyCV does not claim ownership of this content or guarantee its accuracy or current availability. All original content is the intellectual property of the respective employers or other rights holders.

LiftmyCV hiring intelligence, availability checks, and related-job recommendations are generated from LiftmyCV data and public sources.

If you prefer, you may apply directly via the original listing for transparency.