Remote Senior Data Consultant: Azure Synapse to Fabric

Trility Consulting LLC; Austin (TX); Remote; USD 140,000 - 190,000; Full time

Benefits offered by this job

Remote W2 position

Flexible work hours

Paid time off

Company holidays

Floating holidays

Job summary

Trility Consulting LLC is seeking a Senior Data Consultant to modernize an Azure Synapse-based data platform and migrate workloads to Microsoft Fabric. The role is remote (W2) with flexible hours, supporting clients across the United States.

You will design metadata-driven ingestion, build reusable data pipelines, and establish automated CI/CD for Fabric artifacts while collaborating with client engineers and Trility consultants to ensure migration accuracy and operational excellence.

Qualifications

• 5+ years of experience with Azure data services and data platforms.
• Experience migrating data workloads from Azure Synapse to Fabric in production.
• Strong SQL skills and data transformation/validation capabilities.

Responsibilities

• Evaluate and refine Microsoft Fabric architecture and metadata structures.
• Design a metadata-driven ingestion framework with config-based onboarding.
• Migrate prioritized data sources from Azure Synapse to Fabric and build pipelines.
• Develop and orchestrate Fabric data pipelines and Spark notebooks (PySpark, Spark SQL).
• Implement Git-based CI/CD and automated environment promotion for Fabric artifacts.
• Leverage Claude Code to define specs and review AI-generated code for quality.
• Evaluate data catalog/metadata governance options (e.g., Purview).

Skills

Azure Data Services

Microsoft Fabric

Azure Synapse

Databricks

PySpark / Spark SQL

Data Pipelines

CI/CD for data platforms

Claude Code

Tools

GitHub Actions

Azure DevOps

Spark Notebooks

PySpark

Job description

Trility Consulting LLC is seeking a Senior Data Consultant to modernize an Azure Synapse-based data platform and migrate workloads to Microsoft Fabric. The role is remote (W2) with flexible hours, supporting clients across the United States.

You will design metadata-driven ingestion, build reusable data pipelines, and establish automated CI/CD for Fabric artifacts while collaborating with client engineers and Trility consultants to ensure migration accuracy and operational excellence.