Fabric Architect

Global asset investment and financial products management company operating in the U.S. and 40 countries.Project InfoPosition InfoWe are looking for an experienced Microsoft Fabric Architect to design and implement scalable enterprise data solutions using Microsoft Fabric.The role focuses on OneLake Lakehouse Data Warehouse Fabric Data Factory Spark SQL and enterprise Power BI semantic models. You will define architecture standards data modeling practices medallion architecture ingestion patterns governance security data quality performance and CICD.This is a hands-on architecture position requiring close collaboration with data engineering BI infrastructure security governance and business teams.The estimated salary range for this position is USD 150000 to 175000 per year.The role requires three days of office work per week in New YorkNew Jersey Newark or Tampa Florida.TechnologiesResponsibilities Design end-to-end Microsoft Fabric architectures using OneLake Lakehouse Data Warehouse pipelines notebooks and Power BI. Define BronzeSilverGold medallion architecture and enterprise standards for ingestion transformation storage modelling and consumption. Establish OneLake workspace domain naming shortcut and data-sharing standards. Design scalable solutions for structured semi-structured and unstructured data. Build enterprise Power BI semantic architectures using dimensional modelling star schemas shared dimensions governed measures DAX and calculation groups. Determine the appropriate use of Direct Lake Import DirectQuery and composite models based on performance scale freshness security and business requirements. Design batch near-real-time and event-driven data integration patterns using Data Factory Dataflows Gen2 Spark SQL notebooks and APIs. Optimize Fabric capacity Delta tables SQL workloads pipelines semantic models and reports for performance and cost. Define enterprise security using Entra ID RBAC RLS OLS managed identities and data classification. Establish governance lineage metadata retention auditing compliance and data-quality standards. Create reusable architecture patterns templates reference implementations and technical standards. Lead architecturedesign reviews technical assessments and proofs of concept. Define source control testing CICD deployment and environment-management practices. Troubleshoot complex performance security capacity and data-reliability issues. Maintain architecture diagrams data flows standards and design documentation.Requirements 8 years of experience in data architecture data engineering business intelligence analytics architecture or enterprise data-platform delivery. Strong hands-on experience designing and implementing production solutions using Microsoft Fabric Microsoft Fabric certification DP-600 andor DP-700 is preferred. Relevant Power BI Azure data or architecture certification. Deep understanding of OneLake Fabric Lakehouse Fabric Data Warehouse Data Factory notebooks pipelines semantic models and Power BI. Strong experience with medallion architecture data-lake architecture Delta Lake Parquet and scalable data-processing patterns. Expertise in dimensional modelling star and snowflake schemas slowly changing dimensions shared dimensions metrics and enterprise semantic modelling. Strong Power BI semantic-model development experience including DAX Power Query calculation groups relationships aggregations incremental refresh and performance optimisation. Experience selecting and implementing Direct Lake Import DirectQuery and composite storage modes. Advanced SQL skills and strong working knowledge of Python or PySpark. Experience integrating relational databases files APIs cloud services external data sources and streaming or event-based sources. Strong knowledge of data security governance lineage classification privacy and access-control principles. Experience designing data-quality reconciliation observability monitoring and exception-management frameworks. Strong understanding of Fabric capacity management workload monitoring query optimisation scalability resilience and cost management. Experience with Git-based development automated testing CICD deployment pipelines and environment-management practices. Ability to convert complex business requirements into clear architecture models technical specifications and delivery plans. Strong analytical troubleshooting documentation consulting and stakeholder-management skills. Ability to provide technical leadership across multiple teams without losing hands-on involvement. Bachelors degree in Computer Science Data Engineering Information Systems or an equivalent discipline.Additional Requirements Experience working with investment management asset management fixed income financial products risk compliance or distribution datasets. Experience with Microsoft Purview Azure Data Lake Storage Azure Data Factory Azure Synapse Analytics Azure Key Vault and Azure Monitor. Experience integrating Microsoft Fabric with Snowflake Databricks Oracle SQL Server or other enterprise data platforms. Experience migrating legacy data warehouses Power BI solutions Azure Synapse or Azure Data Factory workloads to Microsoft Fabric. Knowledge of data mesh domain-oriented architecture data products and federated governance. Experience with real-time intelligence event-streaming or operational analytics. Familiarity with TMDL PBIP Tabular Editor XMLA endpoints or semantic-model automation.