Solution Architect, Data Solutions Architect

RSM US LLP

. Own enterprise data modeling standards, including conceptual, logical, and physical models, conformed dimensions, and canonical data model governance .

Posted 9/30/2026full-timeUnited StatesSeniorLead💰 $147,000 - $260,700 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates extensive expertise in enterprise data modeling, including conceptual, logical, and physical models, while ensuring compliance with SOC 2 and SOX control requirements. Proficient in designing canonical data models and integration contracts, with strong collaboration skills to engage stakeholders and architects effectively.

Highest-signal resume keywords

Data ModelingIntegration ArchitectureCanonical Data ModelsAPI / iPaaS Integration ContractsMaster Data Management

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Conceptual Data ModelingLogical Data ModelingPhysical Data ModelingEntity Relationship ModelingData Vault 2.0Kimball MethodologyInmon MethodologyChange-Data-Capture StrategiesMetadata-Driven Schema PatternsData Dictionary Maintenance

Soft Skills

Strong Communication SkillsStakeholder Engagement

Tools & Technologies

Boomi AtomSphereAPI GatewayYARPCQRS Architecture

Industry Keywords

Enterprise EnvironmentsRegulated EnvironmentsSOC 2 ComplianceSOX Control RequirementsData Governance

Tech Stack

Tools & technologies

Vault

About the role

Key responsibilities & impact

Own enterprise data modeling standards, including 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 such as Workday, CRM, and tax platforms to downstream consumers
Partner with the Boomi iPaaS / API Gateway Architect on orchestration, routing, and contract versioning
Evaluate and apply Kimball, Inmon, and Data Vault 2.0 data modeling methodologies
Define entity relationship diagrams and metadata-driven schema patterns where applicable
Partner with the Solution Architect - Data Platforms to align canonical models to lakehouse/medallion consumption layers
Establish integration standards for master/reference data synchronization and change-data-capture strategies
Lead data model reviews for ARB submissions and produce architecture review reports with severity-rated findings 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-related defects

Requirements

What you’ll need

8+ years of experience in data modeling and/or integration architecture
At least 4 years of experience 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, such as Boomi AtomSphere or comparable
Familiarity with API gateway / reverse-proxy patterns, such as 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
Applicants must not require sponsorship now or in the future if applying as entry-level candidates; F-1 visa holders are excluded from entry-level sponsorship

Benefits

Comp & perks

Competitive benefits and compensation package
Flexible schedule
Discretionary bonus based on firm and individual performance
Reasonable accommodation for people with disabilities