Data Solutions Architect: Canonical Models & Integrations

RSM US LLP; Denver (CO); Hybrid; USD 147,000 - 261,000; Full time

Benefits offered by this job

Hybrid workstyle

Discretionary bonus

Competitive total rewards

Job summary

RSM US LLP seeks a Solution Architect - Data Solutions Architect to own enterprise data modeling standards and the integration architecture bridging source systems to the canonical data hub and downstream consumers. You will define conceptual, logical, and physical models and govern the canonical data model.

You will partner with Platform and API gateway architects on orchestration, routing, and contract versioning, while applying data modeling methodologies and maintaining documentation.

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 (e.g., Boomi AtomSphere).

Responsibilities

• Own enterprise data modeling standards: conceptual, logical, and physical models and canonical data governance.
• Design and maintain the canonical data hub and integration contracts bridging source systems to downstream consumers.
• Partner on orchestration, routing, and contract versioning with integration architects.
• Evaluate data modeling methods (Kimball, Inmon, Data Vault 2.0) for initiatives.
• Define ERDs and metadata-driven schema patterns where applicable.
• Align models to lakehouse/medallion consumption layers with data platforms.
• Lead data model reviews and ARB reporting with action items.
• Maintain data dictionary, model documentation, and integration catalogs.
• Support hyper-care for new integrations and root cause analysis.

Skills

Data modeling

Integration architecture

ER modeling

Canonical data model

API/iPaaS integration

Education

Bachelor's degree in computer science or related field

Tools

Boomi iPaaS

API Gateway

YARP

Job description

RSM US LLP seeks a Solution Architect - Data Solutions Architect to own enterprise data modeling standards and the integration architecture bridging source systems to the canonical data hub and downstream consumers. You will define conceptual, logical, and physical models and govern the canonical data model.

You will partner with Platform and API gateway architects on orchestration, routing, and contract versioning, while applying data modeling methodologies and maintaining documentation.