Solution Architect

• Own the end-to-end solution architecture for the Microsoft Fabric / OneLake data platform, covering ingestion, storage, transformation, serving, semantic models, and analytics


• Define target-state data architecture, architectural principles, design patterns, technology standards, and reference architectures


• Design scalable Lakehouse and Warehouse architectures using Fabric and the Medallion Architecture


• Define enterprise data modeling strategies across conceptual, logical, physical, dimensional, canonical, and conformed models


• Establish Bronze, Silver, and Gold layer architecture


• Define Power BI semantic architecture, including certified datasets, business metrics, reusable measures, security models, and Direct Lake patterns


• Design for scalability, performance, availability, disaster recovery, and cost optimization


• Define security and governance architecture using Purview, RBAC, classification, lineage, masking, PII/PHI protection, access patterns, and audit requirements


• Lead architecture workshops, technical deep dives, and design reviews with business and technical stakeholders


• Define non-functional requirements and architectural acceptance criteria


• Provide technical direction to Data Engineering teams and ensure implementation aligns with approved architecture and enterprise standards

Requirements

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


• Microsoft Certified: Fabric Data Engineer, Azure Data Engineer, Azure Solutions Architect, or equivalent certification preferred


• 10+ years of experience in Data Architecture, Solution Architecture, or Data Engineering


• 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


• 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


• Commercial insurance / brokerage domain experience preferred

Core Competencies

Demonstrates expertise in end-to-end solution architecture for Microsoft Fabric and OneLake data platforms, focusing on scalable Lakehouse and Warehouse architectures, data governance, and security. Proficient in defining enterprise data modeling strategies and providing technical direction to data engineering teams.

Highest-signal resume keywords

• Microsoft Fabric


• Data Architecture


• Enterprise Data Modeling


• Data Governance


• Power BI

ATS Optimization Keywords

Hard Skills

• Data Engineering


• Lakehouse Architecture


• Medallion Architecture


• Data Integration Architecture


• ETL/ELT


• Dimensional Modeling


• APIs


• Batch Processing


• Data Modeling


• Security Architecture

Soft Skills

• Technical Direction


• Stakeholder Engagement


• Workshop Facilitation

Certifications & Qualifications

• Microsoft Certified: Fabric Data Engineer


• Microsoft Certified: Azure Data Engineer


• Microsoft Certified: Azure Solutions Architect

Industry Keywords

• Commercial Insurance


• Brokerage Domain

Tools & Technologies

• Microsoft Purview


• Azure Data Factory


• Synapse Pipelines


• Spark


• Delta Lake