Solution Architect

Jobtailor; Jersey City (NJ); On-site; USD 150,000 - 210,000; Full time

Job summary

Jobtailor is seeking an experienced Data Architect to own the end-to-end architecture for its Microsoft Fabric and OneLake data platform. You will define target-state architecture, build scalable lakehouse/warehouse solutions, and establish Bronze/Silver/Gold data layers, while shaping enterprise data models and governance.

You will lead architecture workshops, set non-functional requirements, and guide data engineering teams to ensure alignment with enterprise standards.

Qualifications

• Bachelor's degree or equivalent in a related field.
• Microsoft Fabric Data Engineer / Azure Data Engineer / Azure Solutions Architect certifications preferred.
• 10+ years in Data Architecture, Solution Architecture, or Data Engineering.
• 3+ years designing enterprise data platforms on Azure / Microsoft Fabric.
• Strong expertise in data modeling, governance, and security.

Responsibilities

• Own end-to-end solution architecture for Microsoft Fabric and OneLake data platforms.
• Define target-state data architecture, principles, patterns, and standards.
• Design scalable Lakehouse and Warehouse architectures using Fabric and Medallion Architecture.
• Define enterprise data modeling strategies across conceptual to conformed models.
• Establish Bronze, Silver, and Gold data layers.
• Define Power BI semantic architecture and Direct Lake patterns.
• Ensure architecture scalability, performance, availability, DR, and cost optimization.
• Define security and governance architecture with Purview, RBAC, masking, lineage, PII/PHI controls.
• Lead architecture workshops and design reviews with stakeholders.
• Define non-functional requirements and acceptance criteria.
• Provide technical direction to Data Engineering teams to ensure alignment with standards.

Skills

Data architecture leadership

Stakeholder engagement

Workshop facilitation

Technical direction

Communication

Education

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

Tools

Microsoft Purview

Azure Data Factory

Synapse Pipelines

Spark

Delta Lake

OneLake

Microsoft Fabric

Job description

• 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