{bc}
Apply
workday

Solution Architect Data Platforms

RSM
Chicago, USA
Full-time
Junior · 1–2 years experience
Onsite
Discovered 2 weeks ago

Full Job Posting

Key Responsibilities

  • Own the enterprise data platform architecture, including lakehouse/medallion (bronze/silver/gold) layering for the analytical platform serving Assurance, Consulting, Tax, and cross-LOB portfolios.
  • Evaluate and recommend platform technologies for storage, compute, and orchestration (e.g., Databricks, Snowflake, Azure Synapse/Fabric, ADLS), producing architecture decision records for steering committee review.
  • Design ingestion, ELT/ETL, and orchestration patterns spanning batch, micro-batch, and workloads.
  • Adhere to data governance and catalog architecture, partnering with data stewardship on lineage, classification, and data quality using Microsoft Purview.
  • Establish reference architecture and platform standards, including access controls, data residency, SOC 2 / SOX compliance, and IRS 7216 requirements.
  • Partner with the Solution Architect - Data Solutions Architect to align canonical data models, conformed dimensions, and integration contracts feeding the platform.
  • Guide build-vs-buy decisions and platform proof-of-concepts, comparing target architecture options (e.g., Medallion vs. Kimball, Inmon, Data Vault 2.0, Data Mesh) and documenting trade-offs.
  • Lead capacity and cost architecture for compute and storage, including FinOps considerations across cloud consumption.
  • Maintain platform documentation: reference architecture, data flow diagrams, architecture decision records.
  • Sponsor ARB submissions for platform-related initiatives and ensure adherence to enterprise architecture governance.
  • Qualifications & Experience
  • 8+ years of data/platform architecture experience, including at least 4 years designing enterprise-scale lakehouse or modern data warehouse platforms.
  • Deep hands-on expertise with one or more modern platform stacks (e.g., Microsoft Fabric, Databricks).
  • Strong understanding of medallion architecture, Data Mesh, and Data Vault 2.0 concepts and when each pattern applies.
  • Experience with data governance tooling (Microsoft Purview or comparable) for cataloging, lineage, and classification.
  • Familiarity with orchestration engines (e.g., ADF, Airflow) and streaming/change-data-capture approaches.
  • Knowledge of data platform security architecture (RBAC, row/column-level security, data residency).
  • Experience operating in regulated environments and adhering to SOC 2 / SOX control requirements.
  • Strong communication skills; ability to present architecture options and trade-offs to steering committees and leadership.
  • Prior experience partnering with integration and data modeling architects on canonical models and contracts.
  • Bachelor's degree in Computer Science or related field, or equivalent experience.
  • 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://rsmus.com/careers/working-at-rsm/benefits.
  • 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 at 800-274-3978 or send us an email at [email protected].
  • 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: $147,000 - $260,700
  • Individuals selected for this role will be eligible for a discretionary bonus based on firm and individual performance.

Qualifications

  • Experience with data governance tooling (Microsoft Purview or comparable) for cataloging, lineage, and classification.
  • Familiarity with orchestration engines (e.g., ADF, Airflow) and streaming/change-data-capture approaches.
  • Bachelor's degree in Computer Science or related field, or equivalent experience.

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at RSM

Senior Associate 1, Financial Services - Private Equity Funds

Kolkata, IND

Discovered 3 days agoFull-time

Supervisor – Risk Consulting (Financial Services)

Gurugram, IND

Discovered 3 days agoFull-time

Technology Risk Consulting Intern - Summer 2027

Chicago, USA

Discovered 3 days agoFull-time

Supervisor - Trade and Tariff Advisory Services

Chicago, USA

Discovered 3 days agoFull-time

Audit Associate - Winter 2027

Toronto, CAN

Discovered 3 days agoFull-time

Portfolio Delivery Leader

Chicago, USA

Discovered 3 days agoFull-time

Business Intelligence Consulting Intern - Summer 2027

Edmonton, CAN

Discovered 3 days agoFull-time

Payroll Services Supervisor (Workday) - Location Flexible

, USA

Discovered 3 days agoFull-time