Data Solutions Architect: Canonical Data Hub & Integrations

RSM US LLP; Orlando (FL); On-site; USD 156,000 - 261,000; Full time

Job summary

RSM US LLP seeks a Solution Architect - Data Solutions Architect to own enterprise data modeling standards and manage the canonical data hub, bridging source systems to consumers. You will collaborate with Boomi iPaaS and API gateway teams on integration contracts, orchestration, and data governance.

The role requires 8+ years in data modeling/integration architecture, with hands-on experience in data vault, ER modeling, and API/iPaaS contracts.

Qualifications

• 8+ years of experience in data modeling and/or integration architecture 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 (Boomi AtomSphere or comparable).
• Familiarity with API gateway/reverse-proxy patterns (YARP) and CQRS architecture.
• Knowledge of master data management and reference data governance.
• Experience operating in regulated environments with SOC 2/SOX controls.
• Strong communication skills engaging stakeholders, developers, and platform architects.

Responsibilities

• Own enterprise data modeling standards (conceptual, logical, 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 on orchestration and routing with Boomi iPaaS and API gateway architects; manage contract versioning.
• Evaluate data modeling methodologies (Kimball, Inmon, Data Vault 2.0) for initiatives.
• Define ERDs and metadata-driven schema patterns where applicable.
• Align canonical models with lakehouse/medallion consumption layers with data platforms.
• Establish integration standards for master/reference data synchronization and CDC strategies.
• Lead data model reviews in ARB, producing reports with findings and actions.
• Maintain data dictionary, model documentation, and integration interface catalogs.
• Provide hyper-care support for new integrations and drive root-cause analysis.

Skills

Data modeling

Integration architecture

ER modeling

CQRS

API/iPaaS

Education

Bachelor's degree in computer science or related field

Tools

Boomi AtomSphere

YARP

Job description

RSM US LLP seeks a Solution Architect - Data Solutions Architect to own enterprise data modeling standards and manage the canonical data hub, bridging source systems to consumers. You will collaborate with Boomi iPaaS and API gateway teams on integration contracts, orchestration, and data governance.

The role requires 8+ years in data modeling/integration architecture, with hands-on experience in data vault, ER modeling, and API/iPaaS contracts.