Remote Senior Data Consultant: Fabric & Synapse Migrations

Trility Consulting LLC; Montgomery (AL); Remote; USD 140,000 - 180,000; Full time

Benefits offered by this job

Paid time-off

Company holidays

Floating holidays

Job summary

Trility Consulting LLC is seeking a Senior Data Consultant to modernize an Azure Synapse data platform and migrate prioritized workloads to Microsoft Fabric. You will build scalable Pipelines, validate migrations, and establish CI/CD workflows while collaborating with client engineers and our team.

The role emphasizes Claude Code usage for AI-assisted development, lineage considerations, and establishing repeatable patterns for long-term platform maintenance.

Qualifications

• 5+ years of experience with Azure Data Services including Fabric, Synapse or Databricks.
• Hands-on Fabric production experience with lakehouses, pipelines and notebooks.
• Strong SQL skills for data transformation and validation.
• Experience building metadata-driven ingestion and CI/CD for data platforms.
• Experience using Claude Code for AI-assisted development.

Responsibilities

• Evaluate and refine Microsoft Fabric architecture and metadata structures.
• Design metadata-driven ingestion frameworks for onboarding new tables via configuration.
• Migrate workloads from Azure Synapse to Microsoft Fabric.
• Develop Fabric pipelines and Spark notebooks (PySpark, Spark SQL).
• Implement validation, data reconciliation, and CDC patterns.

Skills

Azure Data Services

Microsoft Fabric

Azure Data Factory

Databricks

Synapse

Spark

PySpark

Spark SQL

GitHub Actions

Azure DevOps

Claude Code

Purview

REST APIs

SQL/T-SQL

Tools

Power BI

Job description

Trility Consulting LLC is seeking a Senior Data Consultant to modernize an Azure Synapse data platform and migrate prioritized workloads to Microsoft Fabric. You will build scalable Pipelines, validate migrations, and establish CI/CD workflows while collaborating with client engineers and our team.

The role emphasizes Claude Code usage for AI-assisted development, lineage considerations, and establishing repeatable patterns for long-term platform maintenance.