Microsoft Fabric Architect

About the role

We are seeking a Microsoft Fabric Technical Architect who will oversee the technical architecture, platform design, and implementation quality of the firm’s data platform. This role involves translating strategic data objectives into well-architected, scalable, and well-governed technical solutions.

Responsibilities

• Serve as the primary technical authority for the firm’s Microsoft Fabric platform, owning architectural decisions, platform standards, and implementation patterns across all data workloads.
• Design and implement end-to-end data solutions within Microsoft Fabric, including ingestion, transformation, semantic modeling, orchestration, and reporting layers.
• Define and uphold architectural standards aligned with modern data patterns such as Medallion (Bronze/Silver/Gold), Data Vault, and related methodologies.
• Architect and implement scalable data transformation workflows using PySpark and SQL, with an emphasis on performance, maintainability, and reuse.
• Design and optimize orchestration pipelines using Azure Data Factory and/or Fabric Pipelines, including parameterized and modular pipeline designs.
• Establish and lead CI/CD practices for data workloads, including automated deployments, environment promotion strategies, and integration with Azure DevOps or GitHub.
• Lead capacity planning and workload optimization efforts across the Fabric platform, ensuring efficient computer utilization and cost control.
• Architect and guide the enterprise implementation of Copilot in Fabric, including capacity architecture, workload separation, and evaluation of trade-offs and best practices.
• Develop and maintain semantic layer assets, including semantic models, Power BI report structures, and DAX measures, ensuring consistency and reusability across the firm.
• Collaborate with the Data Strategy Program Manager to ensure the technical architecture supports roadmap priorities, data governance requirements, and desired business outcomes.
• Provide technical leadership and hands-on support to data engineers and implementation teams, establishing coding standards, review practices, and reusable frameworks.
• Partner with Information Governance and Security teams to implement data security, access controls, auditing, and compliance requirements within the Fabric ecosystem.
• Evaluate and integrate supporting tools such as Microsoft Purview for data cataloging, lineage tracking, and governance enforcement.
• Work directly with vendors and Microsoft partners to assess platform capabilities, align implementation approaches, and ensure high-quality delivery.
• Maintain a high level of confidentiality of all firm and client information.

Requirements

• Knowledge of modern data architecture patterns, including Medallion architecture (Bronze/Silver/Gold), Data Vault, and dimensional modeling.
• Knowledge of semantic layer development, including Power BI report design and DAX calculations.
• Knowledge of Copilot in Fabric, including recommended capacity architecture, implementation considerations, and trade-off analysis.
• Knowledge of data security, governance, lineage, and compliance within the Microsoft data ecosystem.
• Exceptional written and verbal communication skills, with the ability to present architectural decisions and trade-offs to both technical teams and business stakeholders.
• Demonstrated ownership mindset, with the ability to lead technical delivery and independently drive results.
• Advanced analytical and problem-solving abilities; able to identify issues, craft practical solutions, and resolve conflicts with sound business judgment.
• Ability to balance multiple priorities, remain composed under pressure, and adapt to shifting demands.
• Strong commitment to client service, ethical conduct, and firm values.
• Demonstrated ability to self-manage and work independently in a remote, hybrid, and in-office settings.
• Strong organizational and prioritizing skills to streamline processes and improve efficiency.

Qualifications

• Minimum eight (8) years of experience in data engineering or data platforms.
• Minimum four (4) years of experience architecting and implementing solutions on Microsoft Fabric and/or its predecessor technologies (Azure Synapse Analytics, Azure Databricks, Azure Data Factory, Azure Machine Learning).
• Expertise with Microsoft Fabric, including Lakehouses, Warehouses, Data Pipelines, Notebooks, Semantic Models, and the broader OneLake architecture.
• Strong proficiency in SQL, including query optimization and complex analytical transformations.
• Expertise with Azure Data Factory and/or Fabric Pipelines, including orchestration design, parameterization, and error handling patterns.
• Experience in PySpark for large-scale transformation workflows.
• Experience implementing CI/CD pipelines for data workloads using Azure DevOps or GitHub Actions.