Data Architect with Microsoft Fabric

Job Title: Data Architect with Microsoft Fabric (JR1043031)
Location: Piscataway, NJ – Hybrid (3 days onsite a week)
End Client: the end client

Job Summary
We are seeking an experienced Data Architect to design, implement, and govern modern enterprise data platforms using Microsoft Fabric. The successful candidate will define scalable data architectures across OneLake, Lakehouse, Warehouse, Data Factory, Real-Time Intelligence, and Power BI, while ensuring strong security, governance, performance, and data quality.

Key Responsibilities
MS Fabric warehouse experience, someone who can be hands-on with Fabric (OneLake, pipelines, governance), has integrated data across multiple source systems including documents, and can explain it to non-technical stakeholders.

• Define the overall enterprise data architecture and Microsoft Fabric adoption roadmap.
• Design scalable data solutions using:
  • Microsoft Fabric OneLake
  • Lakehouse and Warehouse
  • Data Factory pipelines and Dataflows Gen2
  • Notebooks and Spark
  • Real-Time Intelligence and Eventstreams
  • Power BI semantic models and Direct Lake
• Develop and govern medallion architecture patterns, including Bronze, Silver, and Gold layers.
• Design batch, streaming, and near-real-time data integration solutions.
• Establish standards for data modeling, including dimensional modeling, data vault, and semantic-layer design.
• Define data ingestion, transformation, orchestration, and distribution patterns.
• Design secure, highly available, and cost-effective Fabric environments.
• Implement data governance, cataloging, lineage, classification, retention, and quality practices.
• Integrate Microsoft Purview and other governance and security capabilities.
• Define workspace architecture, deployment strategies, capacity planning, and tenant-level controls.
• Establish CI/CD and DataOps practices using Azure DevOps or GitHub.
• Collaborate with data engineers, BI developers, security teams, application teams, and business stakeholders.
• Review technical designs, provide architecture guidance, and ensure adherence to enterprise standards.
• Troubleshoot performance, scalability, data quality, and reliability issues.
• Produce architecture diagrams, technical specifications, standards, and operating procedures.
• Support migration from legacy data warehouses, data lakes, and ETL platforms to Microsoft Fabric.

Required Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related discipline.
• 7 years of experience in data architecture, data engineering, BI, or enterprise analytics.
• 3 years of experience with Microsoft Azure data services and/or Microsoft Fabric.
• Strong knowledge of:
  • Microsoft Fabric architecture
  • OneLake, Lakehouse, and Warehouse
  • Fabric Data Factory and Dataflows Gen2
  • Spark, PySpark, SQL, and notebooks
  • Power BI semantic models and DAX
  • Direct Lake, Import, and DirectQuery storage modes
  • Data integration and orchestration patterns
• Experience designing scalable data platforms and enterprise data models.
• Strong understanding of data governance, security, privacy, and compliance.
• Experience with Git-based development, CI/CD, infrastructure automation, and release management.
• Proficiency in SQL and practical experience with Python or PySpark.
• Excellent communication, stakeholder management, and technical documentation skills.