Remote Senior Data Consultant - Microsoft Fabric & Lakehouse

Trility Consulting LLC; Columbus (OH); A distancia; USD 140.000 - 200.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Remote work

Flexible hours

Paid time off

401(k) plan

Learning opportunities

Company holidays

Descripción de la vacante

Trility Consulting LLC is seeking an experienced Senior Data Consultant to modernize an Azure Fabric data platform and migrate workloads from Azure Synapse. You will partner with client engineers to pressure-test Fabric, build scalable ingestion patterns, and establish automated CI/CD workflows.

This remote W2 position requires residing in the United States. The role emphasizes hands-on data engineering, metadata governance, and cross-functional collaboration to deliver reliable, scalable

Formación

• 5+ years of experience with Azure Data Services including Fabric, Synapse, and Databricks.
• Hands-on Fabric experience in production environments with lakehouses and medallion architecture.
• Experience designing metadata-driven ingestion and scalable data pipelines.

Responsabilidades

• Evaluate and refine the Fabric architecture, metadata structures, and reusable ingestion patterns.
• Design a metadata-driven ingestion framework enabling configuration-based onboarding.
• Migrate sources from Azure Synapse to Microsoft Fabric and build Fabric pipelines.
• Develop PySpark and Spark SQL transformations and orchestrate notebooks.
• Analyze existing Synapse pipelines to understand dependencies and translate logic.
• Create data validation and reconciliation to ensure migration accuracy.
• Define full-load, incremental, or CDC loading strategies per source.
• Implement Git-based CI/CD and environment promotion for Fabric artifacts.
• Leverage Claude Code to guide implementation and review generated code.
• Assess data governance, lineage, and catalog needs (e.g., Purview).
• Collaborate with client engineers through paired development and reviews.
• Apply best practices for performance, testing, monitoring, security, and ops.

Conocimientos

Azure Data Services

Microsoft Fabric

Azure Synapse

Databricks

ETL/ELT pipelines

PySpark

Spark SQL

GitHub Actions

Claude Code

T-SQL

Herramientas

GitHub Actions

Azure DevOps

Claude Code

PySpark

Descripción del empleo

Trility Consulting LLC is seeking an experienced Senior Data Consultant to modernize an Azure Fabric data platform and migrate workloads from Azure Synapse. You will partner with client engineers to pressure-test Fabric, build scalable ingestion patterns, and establish automated CI/CD workflows.

This remote W2 position requires residing in the United States. The role emphasizes hands-on data engineering, metadata governance, and cross-functional collaboration to deliver reliable, scalable