Senior Solution Architect, Data Platforms & Lakehouse

RSM US LLP; Orlando (FL); Hybrid; USD 147,000 - 261,000; Full time

Benefits offered by this job

Discretionary bonus

Job summary

RSM US LLP is seeking an accomplished Solution Architect - Data Platforms to own and evolve the enterprise data platform architecture, including lakehouse patterns and governance, for both internal and client-facing units.

You will drive technology evaluation, design ingestion/ETL patterns, ensure security/compliance, and mentor teams while collaborating with data modeling and integration architects to realize scalable, compliant data solutions.

Qualifications

• 8+ years of data/platform architecture experience, including at least 4 years designing enterprise-scale lakehouse or modern data warehouse platforms.
• Hands-on expertise with one or more modern platform stacks (e.g., Microsoft Fabric, Databricks).
• Strong understanding of medallion architecture, Data Mesh, and Data Vault 2.0 concepts and when each pattern applies.
• Experience with data governance tooling (Microsoft Purview or comparable) for cataloging, lineage, and classification.
• Familiarity with orchestration engines (e.g., ADF, Airflow) and streaming/change-data-capture approaches.
• Knowledge of data platform security architecture (RBAC, row/column-level security, data residency).
• Experience operating in regulated environments and adhering to SOC 2 / SOX control requirements.
• Strong communication skills; ability to present architecture options and trade-offs to steering committees and leadership.
• Prior experience partnering with integration and data modeling architects on canonical models and contracts.
• Bachelor's degree in Computer Science or related field, or equivalent experience.

Responsibilities

• Own the enterprise data platform architecture, including lakehouse/medallion layering for analytics across multiple business units.
• Evaluate and recommend platform technologies for storage, compute, and orchestration (e.g., Databricks, Snowflake, Azure Synapse/Fabric, ADLS).
• Design ingestion, ELT/ETL, and orchestration patterns spanning batch, micro-batch, and workloads.
• Adhere to data governance and catalog architecture, partnering with data stewardship on lineage, classification, and data quality using Microsoft Purview.
• Establish reference architecture and platform standards, including access controls, data residency, SOC 2 / SOX compliance, and IRS 7216 requirements.
• Partner with the Data Solutions Architect to align canonical data models, conformed dimensions, and integration contracts feeding the platform.
• Guide build-vs-buy decisions and platform proof-of-concepts, documenting trade-offs.
• Lead capacity and cost architecture for compute and storage, including FinOps considerations across cloud consumption.
• Maintain platform documentation: reference architecture, data flow diagrams, architecture decision records.
• Sponsor ARB submissions for platform-related initiatives and ensure adherence to governance.

Skills

Strong communication

Leadership

Presentation skills

Cross-functional collaboration

Education

Bachelor's degree in Computer Science

Tools

Microsoft Fabric

Databricks

Snowflake

Azure Synapse

ADLS

Purview

ADF

Airflow

Data Vault 2.0

Job description

RSM US LLP is seeking an accomplished Solution Architect - Data Platforms to own and evolve the enterprise data platform architecture, including lakehouse patterns and governance, for both internal and client-facing units.

You will drive technology evaluation, design ingestion/ETL patterns, ensure security/compliance, and mentor teams while collaborating with data modeling and integration architects to realize scalable, compliant data solutions.