Microsoft Fabric Architect (hybrid)

InfoVision, Inc.

Dallas, TX, United States

about 2 months ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

2 years minimum

Working hours

Regular working hours

Job source

dice.com

Tech stack

Artificial Intelligence Business Logic Data Architecture Database Design Software Design Patterns Microsoft Data Access Components Microsoft SQL Server Query Optimization SQL Stored Procedures SQL Server Integration Services VHSIC Hardware Description Language (VHDL) Data Ingestion

+7 more

Apache Spark Change Data Capture Microsoft Fabric Data Lakes Pyspark Star Schema Databricks

Job description

Act as the primary technical authority across data ingestion, lakehouse architecture, and semantic model architecture for the assessment.
Review ingestion pipeline architecture for design quality, standardization, scalability, and correctness; validate raw-layer landing patterns, change data capture implementation, and source-to-lake completeness; assess the equivalency and completeness of an SSIS-to-Fabric pipeline migration.
Lead the lift-and-shift assessment: evaluate the delivered Bronze/Silver/Gold medallion design against the client’’s documented target architecture; review Delta table optimization, partition strategy, schema evolution handling, OneLake configuration, and data quality gate implementation.
Review stored-procedure-to-PySpark 3.4.1 structured streaming micro-batch transformation with barrier mode execution enabled transformation equivalency and logic quality: code modularity, parameterization, edge case handling, and transformation-layer performance. Produce a map of where business logic resides across the platform and where it is duplicated.
Review semantic model design patterns: star schema, DirectLake vs. import mode, relationship integrity, calculated columns vs. measures, and the fitness of curated tables for semantic modeling.
validate AI-generated scan outputs for accuracy before they enter client deliverables

Skills & Tools

Expert-level Microsoft Fabric: Lakehouse, Delta Lake, Spark, Pipelines, OneLake.
Deep SQL Server: stored procedure analysis, database design patterns, query optimization.
Hands-on SSIS: package structure, transformation logic, and equivalency mapping to Fabric/PySpark 3.4.1 structured streaming micro-batch transformation with barrier mode execution enabled pipelines.
Hands-on Power BI Premium and Databricks.

Requirements

VHDL synthesis Experience: 15+ years Microsoft data platform; 4+ years hands-on lakehouse engineering (Microsoft Fabric, or Synapse/Databricks lakehouse with Fabric migration exposure); minimum 2 years hands-on Microsoft Fabric experience.