Senior Data Consultant: Microsoft Fabric & Azure Lakehouse

Trility Consulting LLC; Central City (CO); Remote; USD 120,000 - 180,000; Full time

Benefits offered by this job

Paid time-off

Job summary

Trility Consulting LLC is seeking an experienced Senior Data Consultant to modernize an Azure Synapse platform and migrate workloads to Microsoft Fabric. You will work with client engineers to shape Fabric architecture, build scalable ingestion pipelines, and ensure data migration quality.

This role emphasizes AI-assisted development with Claude Code and a strong emphasis on CI/CD. Remote W2 position with flexible hours across the United States.

Qualifications

• 5+ years of experience with Azure Data Services including Fabric, Data Factory, Databricks, or Synapse.
• Hands-on Fabric experience in production environments, including lakehouses, pipelines, notebooks, medallion architecture, and capacity management.
• Experience designing metadata-driven ingestion frameworks and configuration-based onboarding.

Responsibilities

• Evaluate and refine Microsoft 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 data sources/workloads from Azure Synapse to Microsoft Fabric.
• Develop and orchestrate Fabric data pipelines and notebooks using PySpark and Spark SQL.
• Build data validation and reconciliation processes to verify migration accuracy.

Skills

Azure Data Services

Microsoft Fabric

Azure Synapse

Databricks

PySpark

Spark SQL

ETL/ELT pipelines

CI/CD

Claude Code

Tools

GitHub Actions

Azure DevOps

Claude Code

Microsoft Purview

Job description

Trility Consulting LLC is seeking an experienced Senior Data Consultant to modernize an Azure Synapse platform and migrate workloads to Microsoft Fabric. You will work with client engineers to shape Fabric architecture, build scalable ingestion pipelines, and ensure data migration quality.

This role emphasizes AI-assisted development with Claude Code and a strong emphasis on CI/CD. Remote W2 position with flexible hours across the United States.