Data Solutions Architect: Enterprise Modeling & Integration

RSM US LLP; Chicago (IL); On-site; USD 147,000 - 261,000; Full time

Job summary

RSM US LLP is seeking an experienced Solution Architect – Data Solutions Architect to own enterprise data modeling and integration standards. You will govern the canonical data model and partner with platform architects to design scalable data flows across Workday, CRM, and tax platforms.

You will define ER diagrams, metadata-driven schemas, and integration contracts using Boomi iPaaS and API gateway patterns, while leading model reviews and maintaining data dictionaries to support

Qualifications

• 8+ years of data modeling and/or integration architecture in enterprise environments.
• Deep hands-on experience with conceptual, logical, and physical data models.
• Experience designing canonical data models and API/iPaaS integration contracts.

Responsibilities

• Own enterprise data modeling standards: conceptual, logical, and physical models; conformed dimensions; canonical data model governance.
• Design and maintain the canonical data hub and integration contracts bridging source systems to downstream consumers.
• Partner with Boomi iPaaS / API gateway architect on orchestration, routing, and contract versioning.
• Evaluate and apply data modeling methodologies (Kimball, Inmon, Data Vault 2.0) as appropriate.
• Define ER diagrams and metadata-driven schema patterns where applicable.
• Collaborate with data platforms teams to align canonical models with lakehouse/medallion consumption layers.
• Establish integration standards for master/reference data synchronization and change-data-capture strategies.
• Lead data model reviews as ARB submissions with architecture reports and action items.
• Maintain the data dictionary, model documentation, and integration interface catalogs.
• Support hyper-care for new integrations and drive root-cause analysis for data-model defects.

Skills

Data modeling

Integration architecture

API/iPaaS

Communication

CQRS

Education

Bachelor's degree in computer science or related field

Tools

Boomi AtomSphere

YARP

ER modeling tools

Data modeling tools

Job description

RSM US LLP is seeking an experienced Solution Architect – Data Solutions Architect to own enterprise data modeling and integration standards. You will govern the canonical data model and partner with platform architects to design scalable data flows across Workday, CRM, and tax platforms.

You will define ER diagrams, metadata-driven schemas, and integration contracts using Boomi iPaaS and API gateway patterns, while leading model reviews and maintaining data dictionaries to support