Lead Microsoft Fabric Data Engineer (Microsoft Fabric)

Location: USA; hybrid, with three days of office work per week in New York/New Jersey, Newark, or Tampa, Florida. Availability to visit the client office 2–3 times per week is required.

Salary: USD 130,000–140,000 per year.

Company

hirify.global delivers technology solutions for a global asset, investment, and financial products management company operating in the U.S. and more than 40 countries.

What you will do

• Design and implement end-to-end Microsoft Fabric solutions across OneLake, Lakehouse, Warehouse, Data Factory, notebooks, SQL/PySpark, and Power BI.
• Build scalable medallion architectures and batch or incremental pipelines integrating relational databases, files, APIs, cloud services, and other enterprise sources.
• Build and optimize Power BI semantic models, including dimensional models, DAX, aggregations, incremental refresh, Import, DirectQuery, Direct Lake, and composite models.
• Diagnose and resolve performance issues across pipelines, Delta tables, SQL workloads, semantic models, reports, and Fabric capacity.
• Define patterns for workspaces, domains, environments, OneLake sharing, security, governance, deployment, data quality, lineage, monitoring, and operational controls.
• Provide technical leadership, lead assessments and proofs of concept, develop reusable engineering patterns, and support modernization and production operations.

Requirements

• 8+ years of experience in data engineering, data architecture, analytics engineering, or enterprise data-platform delivery, including significant hands-on implementation.
• Strong hands-on production experience with Microsoft Fabric across several core workloads, including Lakehouse/Warehouse, Data Factory pipelines, notebooks, SQL/PySpark, and Power BI semantic models.
• Deep practical knowledge of OneLake, Fabric Lakehouse, Fabric Data Warehouse, Data Factory, Spark/notebook engineering, Power BI, medallion architectures, Delta Lake, Parquet, and scalable data processing.
• Experience with ingestion, transformation, orchestration, incremental processing, large-scale workloads, relational databases, files, APIs, cloud services, and enterprise data sources.
• Strong SQL skills and practical production experience with Python and/or PySpark.
• Strong data-modeling fundamentals, including dimensional modeling, star schemas, facts and dimensions, shared or conformed dimensions, and slowly changing dimensions.
• Experience building and optimizing enterprise Power BI semantic models using DAX, Power Query, aggregations, incremental refresh, and performance optimization; practical understanding of Direct Lake, Import, DirectQuery, and composite models.
• Experience diagnosing and optimizing SQL, pipelines, data processing, semantic models, Power BI reports, Fabric workloads, and Fabric capacity, including workload monitoring, capacity constraints, query optimization, and cost/performance considerations.
• Experience with existing enterprise data and BI environments, troubleshooting, optimization, modernization, incremental migration, Git-based development, CI/CD, automated testing, and environment management.
• Practical knowledge of security, access control, governance, lineage, data protection, Entra ID, RBAC, RLS/OLS, managed identities, data quality, reconciliation, observability, monitoring, and operational reliability.
• Ability to translate complex requirements into working solutions, own delivery from design through production support, make architecture decisions, and remain a hands-on contributor.
• Strong communication and collaboration skills across engineering, architecture, BI, infrastructure, security, governance, and business stakeholders.
• Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or equivalent practical experience.
• Availability to visit the client office 2–3 times per week.

Nice to have

• Microsoft Fabric certification, especially DP-600 and/or DP-700, or relevant Power BI, Azure Data, or architecture certifications.
• Experience with investment management, asset management, fixed income, financial products, risk, compliance, or distribution data.
• Experience with Microsoft Purview, Azure Data Lake Storage, Azure Data Factory, Azure Synapse Analytics, Azure Key Vault, and Azure Monitor.
• Experience integrating Fabric with SQL Server, Oracle, Snowflake, Databricks, or other enterprise data platforms.
• Experience modernizing or migrating legacy data warehouses, Power BI, Azure Synapse, Azure Data Factory, or other analytical workloads to Fabric.
• Knowledge of data mesh, domain-oriented data architecture, federated governance, Fabric Real-Time Intelligence, event streaming, or operational analytics.
• Familiarity with TMDL, PBIP, Tabular Editor, XMLA endpoints, semantic-model automation, Microsoft AI Foundry, GenAI, agents, or AI-enabled analytics.

Culture & Benefits

• Work with a medium-sized team of 10–20 people.
• Support enterprise reporting, investment, product, distribution, and operations capabilities.
• Collaborate across data engineering, BI, architecture, infrastructure, security, governance, and business functions.
• Hybrid work arrangement with regular client-office presence in the United States.