Remote Senior Data Consultant: Azure Fabric & Lakehouse

Trility Consulting; United States; Remote; USD 120,000 - 180,000; Full time

Benefits offered by this job

Remote work in US

Paid time off

Comprehensive benefits

401(k) plan

Learning opportunities

Job summary

Trility Consulting LLC is seeking an experienced Senior Data Consultant to support a client engagement focused on modernizing an Azure Synapse data platform and migrating workloads to Microsoft Fabric. You will partner with client engineers, design metadata-driven ingestion patterns, and build scalable data pipelines across a modern lakehouse environment.

Remote W2 role with US-only residency; you will implement CI/CD workflows, leverage Claude Code for AI-assisted development, and ensure data

Qualifications

• 5+ years with Azure Data Services including Fabric, ADF, Databricks, or Synapse.
• Production Microsoft Fabric experience with lakehouses, pipelines, notebooks, medallion architecture, workspaces, and capacity management.
• Proven ability to build reusable data ingestion frameworks.
• Experience PySpark/Spark SQL data transformations.
• Strong SQL for data transformation, validation, and performance tuning.

Responsibilities

• Evaluate and refine the existing Fabric architecture, including metadata structures and reusable ingestion patterns.
• Design a metadata-driven ingestion framework for configuration-based onboarding of new tables/sources.
• Migrate prioritized data sources from Azure Synapse to Microsoft Fabric.
• Develop and orchestrate Fabric 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 Git-based CI/CD and automated environment promotion for Fabric artifacts.
• Leverage Claude Code to define implementation specifications and review AI-generated code.
• Evaluate data dictionary, metadata, and lineage requirements including catalogs like Purview.
• Collaborate with client engineers to establish engineering standards and knowledge sharing.
• Apply data engineering best practices for performance, testing, monitoring, and security.

Skills

Azure Data

Microsoft Fabric

ETL/ELT pipelines

PySpark

SQL

CI/CD

Data Governance

REST APIs

Data Validation

Azure Synapse

Claude Code

Team collaboration

Tools

GitHub Actions

Azure DevOps

Azure Data Factory

Databricks

Job description

Trility Consulting LLC is seeking an experienced Senior Data Consultant to support a client engagement focused on modernizing an Azure Synapse data platform and migrating workloads to Microsoft Fabric. You will partner with client engineers, design metadata-driven ingestion patterns, and build scalable data pipelines across a modern lakehouse environment.

Remote W2 role with US-only residency; you will implement CI/CD workflows, leverage Claude Code for AI-assisted development, and ensure data