Solutions Architect

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

We are looking for an experienced Solution Architect to define the end-to-end architecture for a modern Microsoft Fabric / OneLake data platform. The role will be responsible for translating business and enterprise requirements into scalable data architecture, defining integration and modeling patterns, establishing technical standards, and providing architectural direction across engineering, governance, security, and BI teams.

Key Responsibilities

• Own the end-to-end solution architecture for the Microsoft Fabric / OneLake data platform, covering ingestion, storage, transformation, serving, semantic models, and analytics.
• Define the target-state data architecture, architectural principles, design patterns, technology standards, and reference architectures aligned with enterprise strategy.
• Design scalable Lakehouse and Warehouse architectures using Fabric and the Medallion Architecture.
• Define enterprise data modeling strategies, including conceptual, logical, physical, dimensional, canonical, and conformed data models.
• Establish architecture for Bronze, Silver, and Gold layers, ensuring clear separation of ingestion, transformation, business logic, and consumption responsibilities.
• Define the semantic architecture for Power BI, including certified datasets, business metrics, reusable measures, security models, and Direct Lake implementation patterns.
• Design for scalability, performance, availability, disaster recovery, and cost optimization across the Fabric platform.
• Define security and governance architecture, including Purview, RBAC, data classification, lineage, masking, PII/PHI protection, access patterns, and audit requirements.
• Lead architecture and solution design workshops, technical deep dives, and design reviews with business stakeholders, engineering, security, infrastructure, governance, and BI teams.
• Define non-functional requirements and architectural acceptance criteria covering performance, security, scalability, availability, maintainability, and operational support.
• Provide technical direction to Data Engineering teams and ensure implementation is aligned with the approved architecture and enterprise standards.

Required Experience & Skills

• 10+ years of experience in Data Architecture / Solution Architecture / Data Engineering, with 3+ years designing enterprise data platforms on Azure / Microsoft Fabric.
• Strong expertise in Microsoft Fabric, OneLake, Lakehouse, Fabric Warehouse, Synapse Pipelines, Notebooks, Spark, and Delta Lake.
• Proven experience designing enterprise data lake/lakehouse architectures and scalable Medallion implementations.
• 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.

Education & Certifications

• B.Tech / Bachelor’s degree or equivalent in Computer Science, Engineering, Information Technology, or a related field.

Base Compensation Range: 100,000 - 145,000

The posted range is the hiring range for this role — a subset of the broader range available to employees over time — and reflects base salary across our national hiring scale. Final offers are based on several factors, including the candidate's skills and experience, internal pay equity, work location, market conditions for the role, and the specific scope and responsibilities of the position. The top of the range is reserved for candidates who notably exceed the requirements; the lower end applies to those with less experience or fewer preferred qualifications. For positions based in higher-cost zones (e.g., California, New York, New Jersey), actual compensation may exceed the posted range; your recruiter will share specifics during the process.

For more information on benefits and what we offer please visit us at https://www.exlservice.com/us-careers-and-benefits