Solution Architect Data Platforms
Chicago, IL - USA
Job Summary
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. Youll find an environment that inspires and empowers you to thrive both personally and professionally. Theres no one like you and thats why theres nowhere like RSM.
Solution Architect Data Platforms
The Solution Architect - Data Platforms owns the current and target-state architecture for RSMs analytical and data platform ecosystem servicing both our internal and client-facing business units. This role evolves the core data platform stack partners with the Solution Architect - Data Solutions Architect on canonical models and inbound contracts and represents platform architecture in ARB and steering committee reviews.
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.
- Bachelors degree in Computer Science or related field or equivalent experience.
At RSM we offer a competitive benefits and compensation package for all our offer flexibility in your schedule empowering you to balance lifes demands while also maintaining your ability to serve more about our total rewards at 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/ 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 or send us an email at .
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 employees 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: $147000 - $260700Individualsselected for this role will be eligible for a discretionary bonus based on firm and individual performance.
Required Experience:
Staff IC
About Company
RSM US LLP is the leading U.S. provider of assurance, tax and consulting services focused on the middle market.