Solution Architect Data Platforms
RSM International27 days ago
Chicago, IL, USA +6 moreSenior
Base Salary
$147k - $261k/yr
Responsibilities
- Own enterprise data platform architecture, including lakehouse and medallion layering for analytical platforms.
- Evaluate storage, compute, and orchestration technologies and produce architecture decision records.
- Design batch, micro-batch, ELT/ETL, ingestion, orchestration, and streaming or change-data-capture patterns.
- Establish data governance, catalog, lineage, classification, data quality, access control, residency, and compliance architecture.
- Align canonical data models, conformed dimensions, and integration contracts with data and integration architects.
- Lead build-versus-buy decisions, platform proof-of-concepts, architecture comparisons, and trade-off documentation.
- Lead capacity, storage, compute, and FinOps architecture and maintain platform documentation.
- Sponsor architecture review board submissions and ensure adherence to enterprise architecture governance.
Requirements
- 8+ years of data or platform architecture experience, including at least 4 years designing enterprise-scale lakehouse or modern data warehouse platforms.
- Deep hands-on expertise with one or more modern platform stacks such as Microsoft Fabric or Databricks.
- Strong understanding of medallion architecture, Data Mesh, and Data Vault 2.0 concepts and applications.
- Experience with Microsoft Purview or comparable data governance tooling for cataloging, lineage, and classification.
- Familiarity with orchestration engines such as ADF or Airflow and streaming or change-data-capture approaches.
- Knowledge of data platform security architecture, including RBAC, row-level and column-level security, and data residency.
- Experience working in regulated environments with SOC 2 and SOX control requirements.
- Strong communication skills and ability to present architecture options and trade-offs to steering committees and leadership.
- Experience partnering with integration and data modeling architects on canonical models and contracts.
- Bachelor’s degree in Computer Science or a related field, or equivalent experience.
Benefits
- Competitive benefits and compensation package.
- Generally hybrid workstyle aligned to an RSM office, with in-person work based on client, team, development, and relationship-building needs; some roles may be virtual or primarily on-site.
- Discretionary bonus eligibility based on firm and individual performance.
- Equal opportunity employment and reasonable accommodations are available.
Tech Stack
Apache AirflowDatabricksSnowflake
Categories
Data Engineering
About RSM International
RSM International is a global network of independent firms providing audit, tax, and consulting services to middle‑market and growth enterprises. Member firms deliver offerings such as assurance, risk and cyber advisory, transaction support, outsourcing, and IFRS/GAAP accounting, while the network supplies common standards, tools, and branding. Founded in 1964 and headquartered in London, it coordinates practices across many countries to serve privately held, public, and public‑sector organizations.