> Markdown version of [/jobs/ext/4625854-solution-architect-data-solutions-architect](https://www.wearedevelopers.com/jobs/ext/4625854-solution-architect-data-solutions-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Solution Architect, Data Solutions Architect

- **Company:** RSM US
- **Location:** Chicago, IL, United States
- **Experience:** Starter
- **Contract:** Internship / Graduate position
- **Skills:** Application Programming Interfaces (APIs), Application Integration Architecture, Command-Query Responsibility Segregation (Software Development), Data Dictionary, Data Hub, Data Systems, Data Vault Modeling, Entity Relationship Models, Reference Data, Management of Software Versions, Boomi, Change Data Capture, Information Technology, Data Management, Physical Data Models, Api Gateway, Workday
- **Published:** November 7, 2026
- **Apply:** https://www.juju.com/job/28_25197_29b05163686189606000506d9f7954f5

## About the Role

* 8+ years of experience in data modeling and/or integration architecture, including at least 4 years in enterprise environments.
 * Deep hands-on expertise with conceptual, logical, and physical data modeling and ER modeling tools.
 * Experience designing canonical data models and API / iPaaS integration contracts (e.g., Boomi AtomSphere or comparable).
 * Familiarity with API gateway / reverse-proxy patterns (e.g., YARP) and CQRS architecture.
 * Knowledge of master data management and reference data governance.
 * Experience operating in regulated environments and adhering to SOC 2 / SOX control requirements.
 * Strong communication skills; ability to engage business stakeholders, integration developers, and platform architects.
 * Prior experience partnering with data platform architects on lakehouse/medallion consumption patterns.
 * Bachelor's degree in computer science or related field, or equivalent experience., 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.

## Description

The Solution Architect - Data Solutions Architect owns enterprise data modeling standards and the integration architecture that bridges source systems to RSM's canonical data hub and downstream consumers. This role defines conceptual, logical, and physical data models, governs the canonical data model, and partners with the Solution Architect - Data Platforms and the Boomi iPaaS / API Gateway Architect on integration contracts, orchestration, and routing., * Own enterprise data modeling standards: conceptual, logical, and physical models, conformed dimensions, and canonical data model governance.

 * Design and maintain the canonical data hub and integration contracts (e.g., hub-first CQRS pattern) bridging source systems (Workday, CRM, tax platforms) to downstream consumers.
 * Partner with the Boomi iPaaS / API Gateway Architect on orchestration, routing (e.g., YARP-based gateway), and contract versioning.
 * Evaluate and apply data modeling methodologies (Kimball, Inmon, Data Vault 2.0) appropriate to each initiative.
 * Define entity relationship diagrams (ERDs) and metadata-driven schema patterns (e.g., JSONB generic store) where applicable.
 * Partner with the Solution Architect - Data Platforms to ensure canonical models align to lakehouse/medallion consumption layers.
 * Establish integration standards for master/reference data synchronization and change-data-capture strategies.
 * Lead data model reviews as part of ARB submissions, producing architecture review reports with severity-rated findings and action items.
 * Maintain the data dictionary, model documentation, and integration interface catalogs.
 * Support hyper-care for new integrations, driving root-cause analysis for data-model-related defects.