Senior Data Consultant — Microsoft Fabric & Azure Lakehouse

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

Benefits offered by this job

Paid time-off

Company holidays

401(k) plan

Learning opportunities

Comprehensive benefits

Job summary

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 data pipelines, validate migrations, and implement automated deployment pipelines.

In this remote W2 role, you will join a distributed team across the United States, contributing to architectural decisions and defining repeatable patterns.

Qualifications

• 5+ years of experience with Azure Data Services, including Fabric, Synapse, or Data Factory.
• Hands-on Fabric production experience with lakehouses, pipelines, notebooks and capacity management.
• Strong SQL skills for data transformation, validation, and performance tuning.

Responsibilities

• Evaluate and refine Fabric architecture including metadata structures and reusable ingestion patterns.
• Design a metadata-driven ingestion framework enabling configuration-based onboarding.
• Migrate data sources/workloads from Azure Synapse to Microsoft Fabric.
• Develop Fabric data pipelines and Spark notebooks using PySpark and Spark SQL.
• Lead CI/CD workflows for Fabric artifacts using GitHub Actions or Azure DevOps.
• Use Claude Code to define specs, accelerate development, and review AI-generated code.

Skills

Azure Data Services

Microsoft Fabric

Azure Synapse

Azure Data Factory

Databricks

PySpark

Spark SQL

SQL

CI/CD

Claude Code

GitHub Actions

Azure DevOps

Metadata-driven ingestion

Data governance

REST APIs

Data pipelines

Data validation

Collaboration

Communication

Tools

Claude Code

GitHub Actions

Azure DevOps

Microsoft Purview

Job description

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 data pipelines, validate migrations, and implement automated deployment pipelines.

In this remote W2 role, you will join a distributed team across the United States, contributing to architectural decisions and defining repeatable patterns.