Job Description
We are seeking a Principal Data Lakehouse Architect to define and lead the architecture roadmap and implementation of an enterprise Data Lakehouse using Microsoft Fabric for a financial services client.
The ideal candidate has 15+ years of overall experience, including 10+ years in data and data warehousing, and 2+ years of hands-on Microsoft Fabric experience. This role requires deep expertise in Fabric Lakehouse & Warehouse, data warehouse modeling, ETL/ELT pipelines, data governance, and banking/financial data domains.
Must-Have Skills & Experience
Microsoft Fabric: Fabric Lakehouse, Fabric Warehouse, OneLake
Data Warehousing & Modeling: Fact/Dimension tables, Star/Snowflake schemas, SCD Type 1 & 2, Kimball & Inmon
ETL / ELT: Fabric Data Factory, Pipelines, Dataflows Gen2, ADF, SSIS, Stored Procedures
Data Governance & Quality: Purview, data lineage, access controls, PII handling
Banking / Financial Data: GL, Loans, Deposits, Core Banking, Regulatory Reporting
Good-to-Have
Power BI (Semantic Models, DAX)
Azure Synapse / Fabric SQL, T-SQL optimization
Azure Data Lake / One Lake (Delta, Parquet)
Incremental Loads & CDC patterns