Senior Data Architect: Microsoft Fabric & Synapse Migration

Trility Consulting; Virginia; Remote; USD 130,000 - 180,000; Full time

Benefits offered by this job

Paid time-off

Company holidays

Job summary

Trility Consulting is seeking an experienced Senior Data Consultant to modernize an Azure Synapse data platform and migrate workloads to Microsoft Fabric. You will partner with client engineers to design scalable ingestion frameworks and build data pipelines in a lakehouse environment.

You will implement CI/CD for Fabric artifacts, leverage Claude Code for AI-assisted development, and validate data migrations with robust testing and governance considerations.

Qualifications

• 5+ years of experience with Azure Data Services including Fabric, ADF, Databricks or Synapse.
• Hands-on Fabric experience in production environments with lakehouses and pipelines.
• Proven ETL/ELT pipeline craftsmanship and reusable ingestion frameworks.
• Ability to design a metadata-driven ingestion framework with config-based onboarding.
• Spark notebooks and data transformation using PySpark and Spark SQL.
• Strong SQL skills including T-SQL for data transformation and validation.
• Experience with Azure Synapse and understanding complex data dependencies.
• Experience building Git-based CI/CD workflows for data artifacts with GitHub Actions/Azure DevOps.
• Hands-on use of Claude Code for AI-assisted development and code review.
• Experience validating data migrations, ensuring quality, accuracy, and consistency.
• Data integration from REST APIs, relational databases, and structured/semi-structured data.
• Familiarity with governance, lineage, metadata management, and catalog concepts.
• Experience migrating data platforms from Azure Synapse to Fabric.
• Experience with Oracle and DB2 sources.
• Incremental ingestion, CDC, and source-specific loading strategies.
• Data reconciliation and validation frameworks for large migrations.
• Evaluating Purview or similar data catalog solutions.

Responsibilities

• Evaluate and refine the Fabric architecture, including metadata structures and reusable ingestion patterns.
• Design a metadata-driven ingestion framework allowing onboarding via configuration.
• Migrate prioritized sources from Azure Synapse to Microsoft Fabric.
• Develop and orchestrate Fabric data pipelines and Spark notebooks (PySpark, Spark SQL).
• Analyze Synapse pipelines to translate logic into Fabric solutions.
• Build data validation and reconciliation processes for migration accuracy.
• Develop loading strategies: full-load, incremental, or CDC per source.
• Implement Git-based CI/CD and environment promotion for Fabric artifacts.
• Leverage Claude Code to define specs, accelerate development, and review AI-generated code.
• Assess data dictionary, metadata, and lineage needs; explore Purview.
• Apply best practices for performance, testing, monitoring, security, and operations.

Skills

Azure Data Services

Microsoft Fabric

Azure Synapse

Azure Data Factory

Databricks

ETL/ELT pipelines

Spark notebooks

PySpark

Spark SQL

SQL

Data migration

CI/CD for data platforms

GitHub Actions

Azure DevOps

Claude Code

Data governance & catalog

CDC / incremental load

REST APIs integration

Oracle / DB2 experience

Tools

Claude Code

GitHub Actions

Azure DevOps

Microsoft Purview

Spark notebooks

Job description

Trility Consulting is seeking an experienced Senior Data Consultant to modernize an Azure Synapse data platform and migrate workloads to Microsoft Fabric. You will partner with client engineers to design scalable ingestion frameworks and build data pipelines in a lakehouse environment.

You will implement CI/CD for Fabric artifacts, leverage Claude Code for AI-assisted development, and validate data migrations with robust testing and governance considerations.