Enterprise Data Solutions Architect: Modeling & Integration

RSM US LLP; New York (NY); On-site; USD 147,000 - 261,000; Full time

Benefits offered by this job

Competitive benefits

Flexible schedule

Job summary

RSM US LLP, a leading provider of professional services to the middle market, seeks a Solution Architect - Data Solutions Architect to own enterprise data modeling standards and the integration architecture bridging source systems to the data hub and downstream consumers.

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

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 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 the 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 Solution Architect - Data Platforms to ensure canonical models align to lakehouse/medallion consumption 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 severity-rated findings and 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-related defects.

Skills

Data modeling

Integration architecture

ER modeling

API/iPaaS

CQRS

Master data mgmt

SOC 2/SOX

Communication

Stakeholder engagement

Lakehouse patterns

Education

Bachelor's degree in CS

Tools

Boomi AtomSphere

ER modeling tools

Job description

RSM US LLP, a leading provider of professional services to the middle market, seeks a Solution Architect - Data Solutions Architect to own enterprise data modeling standards and the integration architecture bridging source systems to the data hub and downstream consumers.

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