Solution Architect, Data Solutions Architect

About RSM US LLP Stay Alert: Avoid Recruitment Scams Across industries, cybercriminals are posing as company recruiters using fake job postings and employment offers to trick people into providing personal information or payment. Be alert and never provide personal/financial information or payment to anyone claiming to offer a job opportunity. During the recruiting process, RSM US will never: • Ask you for payment to process documents, purchase equipment, or for any other reason. • Request your banking or credit card information • Send you a check to purchase your own equipment If you believe you are a victim of a job scam, it’s recommended that you report it to law enforcement, contact your financial institution and notify the website in which the job was listed. --- RSM is the leading provider of assurance, tax and consulting services to the middle market. With over 17,000 professionals across the U.S. and Canada and a global presence in 120 countries, our purpose is to deliver the power of being understood to our clients, colleagues and communities. As first-choice advisors, we are focused on developing leading professionals and innovative services to meet our clients’ evolving needs in today’s ever-changing business environment. At RSM, we strive to deeply understand the full picture of an employee’s individual skills and passions. Our culture empowers you to own your career to reach your goals and make a meaningful impact on the world around you. Gain limitless opportunities to grow forward personally and professionally. Don’t just go forward. #GrowForwardatRSM For more information, visit rsmus.com Learn how you can #GrowForwardatRSM visit www.rsmus.com/careers

RSM US LLP

Experience the power of being understood.

AccountingAuditConsultingTax ServicesPrivate EquityIndustrial ProductsConsumer ProductsFinancial Servicesand Real Estate

R

rsmus.com

10,001+ employees

Accounting

Chicago, Illinois

1926

Partnership

432k LinkedIn followers

• The Solution Architect - Data Solutions Architect owns enterprise data modeling
• standards and the integration architecture that bridges source systems to RSM's
• canonical data hub and downstream consumers. This role defines conceptual,
• logical, and physical data models, governs the canonical data model, and
• partners with the Solution Architect - Data Platforms and the Boomi iPaaS / API
• Gateway Architect on integration contracts, orchestration, and routing.
• 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 (e.g.,
• hub-first CQRS pattern) bridging source systems (Workday, CRM, tax platforms)
• to downstream consumers.
• Partner with the Boomi iPaaS / API Gateway Architect on orchestration,
• routing (e.g., YARP-based gateway), and contract versioning.
• Evaluate and apply data modeling methodologies (Kimball, Inmon, Data Vault
• 2.0) appropriate to each initiative.
• patterns (e.g., JSONB generic store) 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.

• 8+ years of experience in data modeling and/or integration architecture,
• including at least 4 years in enterprise environments.
• Deep hands-on expertise with conceptual, logical, and physical data modeling
• and ER modeling tools.
• 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.
• lakehouse/medallion consumption patterns.
• experience.
• At RSM, we offer a competitive benefits and compensation package for all our
• people. Learn more about our total rewards at
• https://rsmus.com/careers/working-at-rsm/benefits
• We believe flexibility and in-person connection both play an important role in
• how we work and grow. Most roles at RSM follow a hybrid workstyle, which means
• team members are aligned to an RSM office and come together in person when it
• best supports clients, teams, development or relationship-building. Some roles
• may be virtual or primarily on-site based on role requirements, team priorities
• and client needs.
• All applicants will receive consideration for employment as RSM does not
• tolerate discrimination and/or harassment based on race; color; creed; sincerely
• held religious beliefs, practices or observances; sex (including pregnancy or
• disabilities related to nursing); gender; sexual orientation; HIV Status;
• national origin; ancestry; familial or marital status; age; physical or mental
• disability; citizenship; political affiliation; medical condition (including
• family and medical leave); domestic violence victim status; past, current or
• prospective service in the US uniformed service; US Military/Veteran status;
• pre-disposing genetic characteristics or any other characteristic protected
• under applicable federal, state or local law.
• Accommodation for applicants with disabilities is available upon request in
• connection with the recruitment process and/or employment/partnership. RSM is
• [careers@rsmus.com].
• RSM does not intend to hire entry level candidates who will require sponsorship
• now OR in the future (i.e. F-1 visa holders). If you are a recent U.S. college /
• university graduate possessing 1-2 years of progressive and relevant work
• experience in a same or similar role to the one for which you are applying,
• excluding internships, you may be eligible for hire as an experienced associate.
• At RSM, an employee’s pay at any point in their career is intended to reflect
• their experiences, performance, and skills for their current role. The salary
• range (or starting rate for interns and associates) for this role represents
• numerous factors considered in the hiring decisions including, but not limited
• to, education, skills, work experience, certifications, location, etc. As such,
• pay for the successful candidate(s) could fall anywhere within the stated range.

• Individuals selected for this role will be eligible for a discretionary bonus
• based on firm and individual performance.