Senior Data Architect: Canonical Models & API Integration

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

Job summary

RSM US LLP is seeking a Solution Architect - Data Solutions Architect to own enterprise data modeling standards and the integration architecture connecting source systems to the canonical data hub. You will collaborate with the Boomi iPaaS / API Gateway Architect on orchestration, routing, and contract versioning, while applying data modeling methodologies across initiatives.

You will define ERDs, metadata-driven schemas, and ensure alignment with lakehouse/medallion consumption layers, with a

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

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 entity relationship diagrams (ERDs) and metadata-driven schema patterns where applicable.
• Partner with the Data Platforms team to ensure canonical models align to lakehouse/medallion layers.
• Establish integration standards for master/reference data synchronization and change-data-capture strategies.
• Lead data model reviews as ARB submissions, producing architecture review reports with 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 defects.

Skills

Data modeling

Integration architecture

API/iPaaS integration

CQRS architecture

Master data management

SOC 2 / SOX controls

Stakeholder communication

Education

Bachelor's degree in computer science or related field, or equivalent experience

Tools

Boomi AtomSphere

YARP

ER modeling tools

Job description

RSM US LLP is seeking a Solution Architect - Data Solutions Architect to own enterprise data modeling standards and the integration architecture connecting source systems to the canonical data hub. You will collaborate with the Boomi iPaaS / API Gateway Architect on orchestration, routing, and contract versioning, while applying data modeling methodologies across initiatives.

You will define ERDs, metadata-driven schemas, and ensure alignment with lakehouse/medallion consumption layers, with a