Data Solutions Architect: Modeling & Integration Lead

RSM US LLP; Dallas (TX); Hybrid; USD 147,000 - 261,000; Full time

Benefits offered by this job

Discretionary bonus

Hybrid workstyle

Job summary

RSM US LLP is seeking a Solution Architect - Data Solutions Architect to own enterprise data modeling standards and the integration architecture bridging source systems to the canonical data hub.

You will define conceptual, logical, and physical data models, govern the canonical data model, and partner with the Solution Architect - Data Platforms and the Boomi iPaaS / API Gateway Architect on integration contracts, orchestration, and routing.

Qualifications

• 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.

Responsibilities

• 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 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) appropriate to each initiative.
• Define ERDs and metadata-driven schema patterns where applicable.
• Partner with Data Platforms to align canonical models to lakehouse/medallion 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 findings.
• 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

ER modeling

API/iPaaS integration

CQRS architecture

Master data management

SOC 2 / SOX compliance

Stakeholder communication

Education

Bachelor's degree in computer science or related field

Tools

Boomi AtomSphere

API gateway patterns

YARP

Job description

RSM US LLP is seeking a Solution Architect - Data Solutions Architect to own enterprise data modeling standards and the integration architecture bridging source systems to the canonical data hub.

You will define conceptual, logical, and physical data models, govern the canonical data model, and partner with the Solution Architect - Data Platforms and the Boomi iPaaS / API Gateway Architect on integration contracts, orchestration, and routing.