Remote Senior Data Consultant: Fabric & Synapse Migration

Trility Consulting LLC; Alabama; Remote; USD 120,000 - 180,000; Full time

Benefits offered by this job

Paid time‑off

Company holidays

Floating holidays

Job summary

Trility Consulting LLC is seeking an experienced Senior Data Consultant to modernize an Azure Synapse data platform and migrate prioritized workloads to Microsoft Fabric. You will architect metadata-driven ingestion, build scalable data pipelines, and establish automated CI/CD workflows to support deployment from development through production.

You will partner with client engineers and our consultants, leveraging Claude Code for AI-assisted development, and ensure data quality and lineage

Qualifications

• 5+ years of experience with Azure data services (Fabric, Synapse, ADF, Databricks).
• Hands‑on Fabric production experience in lakehouses, pipelines, notebooks, medallion architecture and capacity management.
• Strong SQL skills for data transformation and performance tuning.

Responsibilities

• Evaluate and refine the Microsoft Fabric architecture and ingestion patterns.
• Design a metadata‑driven ingestion framework configurable for new tables and sources.
• Migrate data sources from Azure Synapse to Microsoft Fabric.
• Develop data pipelines and Spark notebooks using PySpark and Spark SQL.
• Validate data migrations with reconciliation and duplicate detection.
• Implement Git‑based CI/CD and environment promotion for Fabric artifacts.

Skills

Strong SQL skills

Data pipeline development

Metadata-driven ingestion design

Git-based CI/CD experience

AI-assisted development (Claude Code)

Tools

Azure Data Factory

Azure Synapse

Microsoft Fabric

Databricks

Spark (PySpark, Spark SQL)

GitHub Actions

Azure DevOps

Claude Code

Purview

Job description

Trility Consulting LLC is seeking an experienced Senior Data Consultant to modernize an Azure Synapse data platform and migrate prioritized workloads to Microsoft Fabric. You will architect metadata-driven ingestion, build scalable data pipelines, and establish automated CI/CD workflows to support deployment from development through production.

You will partner with client engineers and our consultants, leveraging Claude Code for AI-assisted development, and ensure data quality and lineage