Senior Data Platform Solutions Architect (Fabric/OneLake)

EXL; New York (NY); On-site; USD 100,000 - 145,000; Full time

Job summary

EXL is seeking an experienced Solution Architect to define end-to-end architecture for a Microsoft Fabric/OneLake data platform in New York. You will translate business requirements into scalable data architecture, establish standards, and provide direction across engineering, governance, security, and BI teams.

The role focuses on designing Lakehouse/ Warehouse architectures, data modeling strategies, and semantic models for Power BI Direct Lake, with emphasis on performance, security, and cost

Qualifications

• 10+ years of experience in Data Architecture / Solution Architecture / Data Engineering.
• 3+ years designing enterprise data platforms on Azure / Microsoft Fabric.
• Expertise in Microsoft Fabric, OneLake, Lakehouse, Fabric Warehouse, Synapse Pipelines, Notebooks, Spark, and Delta Lake.
• Strong understanding of data integration architecture, CDC, ETL/ELT, APIs, batch processing, and file-based ingestion patterns.
• Strong expertise in data modeling and semantic architecture, including dimensional modeling, conformed dimensions, business entities, and Power BI Direct Lake.
• Experience architecting data governance, security, and compliance using Microsoft Purview, RBAC, masking, lineage, classification, and PII/PHI controls.

Responsibilities

• Own the end-to-end solution architecture for the Microsoft Fabric/OneLake data platform, including ingestion, storage, transformation, serving, and analytics.
• Define target-state data architecture, principles, design patterns, and reference architectures aligned with enterprise strategy.
• Design scalable Lakehouse and Warehouse architectures using Fabric and the Medallion Architecture.
• Establish architecture for Bronze, Silver, and Gold layers with clear separation of ingestion, transformation, and consumption.
• Lead architecture reviews and workshops with stakeholders across engineering, governance, security, and BI teams.
• Define non-functional requirements and acceptance criteria for performance, security, scalability, and availability.
• Provide technical direction to Data Engineering teams ensuring alignment with enterprise standards.

Skills

Microsoft Fabric

OneLake

Lakehouse

Synapse Pipelines

Notebooks

Spark

Delta Lake

Data Modeling

Power BI Direct Lake

Purview

RBAC

Education

B.Tech / Bachelor’s degree or equivalent in Computer Science, Engineering, IT

Tools

Purview

Power BI

Delta Lake

Job description

EXL is seeking an experienced Solution Architect to define end-to-end architecture for a Microsoft Fabric/OneLake data platform in New York. You will translate business requirements into scalable data architecture, establish standards, and provide direction across engineering, governance, security, and BI teams.

The role focuses on designing Lakehouse/ Warehouse architectures, data modeling strategies, and semantic models for Power BI Direct Lake, with emphasis on performance, security, and cost