Senior Data Architect: Fabric & Synapse Migration (Remote)

Trility Consulting LLC; Kentucky; A distancia; USD 120.000 - 180.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Paid time-off

Company holidays

Floating holidays

Descripción de la vacante

Trility Consulting LLC is seeking an experienced Senior Data Consultant to modernize an Azure Synapse data platform and migrate workloads to Microsoft Fabric. You will work with client engineers to design scalable ingestion patterns and validate migrations.

This remote W2 role requires hands-on expertise with Fabric, Spark, PySpark, and Claude Code to guide AI-assisted development. You’ll build CI/CD pipelines, ensure data quality, and document patterns for repeatable deployment across

Formación

• 5+ years with Azure data services and Fabric.
• Hands-on Fabric production experience.
• Experience designing metadata-driven ingestion frameworks.
• Spark notebooks and PySpark data transformations.
• Git-based CI/CD for data platforms.
• AI-assisted development with Claude Code.
• Data migration validation and CDC patterns.

Responsabilidades

• Evaluate and refine the existing Fabric architecture, including metadata structures and reusable ingestion patterns.
• Design and implement a metadata-driven ingestion framework for onboarding new tables/sources via configuration.
• Migrate prioritized data sources from Azure Synapse into Microsoft Fabric.
• Develop and orchestrate Fabric data pipelines and Spark notebooks using PySpark and Spark SQL.
• Analyze existing Synapse pipelines to understand dependencies and translate logic into Fabric solutions.
• Build data validation and reconciliation processes to verify migration accuracy.
• Implement incremental ingestion and change data capture (CDC) strategies.
• Establish Git-based CI/CD and environment promotion for Fabric artifacts and notebooks.
• Leverage Claude Code to define specs, accelerate development, and review AI-generated code.
• Evaluate data dictionary, lineage, and catalog options (e.g., Purview).
• Apply data governance, performance, testing, security, and operational best practices.

Conocimientos

Azure Data Services

Microsoft Fabric

ETL/ELT pipelines

Spark PySpark

SQL

AI-assisted development

Claude Code

GitHub Actions

Herramientas

Azure DevOps

Purview

REST APIs

Oracle/DB2 sources

Descripción del empleo

Trility Consulting LLC is seeking an experienced Senior Data Consultant to modernize an Azure Synapse data platform and migrate workloads to Microsoft Fabric. You will work with client engineers to design scalable ingestion patterns and validate migrations.

This remote W2 role requires hands-on expertise with Fabric, Spark, PySpark, and Claude Code to guide AI-assisted development. You’ll build CI/CD pipelines, ensure data quality, and document patterns for repeatable deployment across