Lead Data Engineer

THIS IS A W2 ROLE, ANY VISA IS FINE

MS Fabric Architect / Lead Data Engineer

• Job Title: MS Fabric Architect / Lead Data Engineer
• Location: Remote (USA only)
• Experience Level: 10+ years in data engineering; 1+ year hands-on in Microsoft Fabric
• Employment Type: W2 with NYTP only

Role Overview

Senior data engineer who can architect and build end-to-end data solutions on Microsoft Fabric — owns the Fabric data platform design, from ingestion through Lakehouse to modeled, analytics-ready data — while staying hands-on in pipelines, Dataflows Gen2, and SQL, and guiding the team.

Key Responsibilities

• Design and implement the end-to-end data architecture on Microsoft Fabric: OneLake, Lakehouse, and Warehouse
• Build and orchestrate ingestion and transformation pipelines using Fabric Data Factory (Pipelines and Dataflows Gen2)
• Design and manage Delta tables and Lakehouse layers (bronze / silver / gold) , with performance tuning and partitioning
• Develop dimensional and semantic data models that support reporting and analytics, including Power BI
• Write and optimize complex SQL for transformation, validation, and data quality
• Define standards for naming, reusable pipeline patterns, error handling, monitoring, and CI/CD across Fabric workspaces
• Lead and mentor data engineers, review designs and code, and work with business and analytics stakeholders

Must-Haves

• 10+ years in data engineering
• 1+ year of hands-on, production experience in Microsoft Fabric
• Fabric Data Factory: Pipelines and Dataflows Gen2
• OneLake and Lakehouse architecture, and Delta tables
• Strong SQL and data modeling (dimensional / star schema)
• Architect / lead-level experience while still hands-on

Nice to Have

• Azure Synapse, Azure Data Factory, or Databricks background, especially migrations to Fabric
• PySpark / Spark notebooks in Fabric
• Power BI semantic models, and Direct Lake
• Microsoft Fabric certification: DP-600 or DP-700
• Fabric CI/CD (Git integration, deployment pipelines)

Screening Notes

• Resume must show real Microsoft Fabric project work with dates — Synapse- or ADF-only profiles relabeled as "Fabric" will be rejected
• Ask which Fabric components they personally built (Pipelines, Dataflows Gen2, Lakehouse, Warehouse) and how they structured OneLake
• Confirm they are US-based and OK working on NYTP W2 — drop anyone who insists on C2C or 1099

Note

• Remote position – USA only
• W2 with NYTP only
• 10+ years data engineering experience required
• 1+ year hands-on Microsoft Fabric experience required
• Real Fabric project work with dates must be visible on the resume