Remote Senior Data Consultant for Microsoft Fabric

Trility Consulting LLC; Tennessee; Remote; USD 140,000 - 190,000; Full time

Benefits offered by this job

Remote work

Flexible hours

Paid time off

401(k) plan

Learning opportunities

Job summary

Trility Consulting LLC seeks an experienced Senior Data Consultant to modernize an Azure Synapse data platform and migrate workloads to Microsoft Fabric.

You will partner with client engineers and Trility consultants to refine Fabric architecture, build reusable ingestion frameworks, and migrate data workloads into a modern lakehouse environment.

This remote W2 role supports clients nationwide with flexible hours and opportunities for learning and advancement.

Qualifications

• Five+ years with Azure Data Services and Fabric in production.
• Proven ability to design metadata‑driven ingestion and scalable pipelines.
• Experience in data migration, validation, and governance concepts.

Responsibilities

• Evaluate and refine Fabric architecture including metadata structures and ingestion patterns.
• Design a metadata‑driven ingestion framework for configuration‑based onboarding.
• Migrate data sources from Azure Synapse to Microsoft Fabric.
• Develop Fabric pipelines and Spark notebooks using PySpark and Spark SQL.
• Translate existing processing logic to Fabric while ensuring accuracy.
• Build data validation and reconciliation; implement CDC patterns as needed.
• Implement Git‑based CI/CD for Fabric artifacts and notebooks.
• Utilize Claude Code to define specs, accelerate development, and review AI‑generated code.
• Assess data dictionary, metadata, and lineage requirements; explore Purview.
• Collaborate with client engineers; establish sustainable engineering standards.
• Apply best practices for performance, testing, security, and operations.

Skills

Azure Data Services

Microsoft Fabric

ETL/ELT pipelines

PySpark & Spark SQL

GitHub Actions / DevOps

Claude Code

Data migration validation

SQL / T-SQL

REST APIs integration

Data governance / Purview

Tools

Azure Data Factory

Databricks

Synapse

Microsoft Purview

CI/CD tooling

Claude Code

Job description

Trility Consulting LLC seeks an experienced Senior Data Consultant to modernize an Azure Synapse data platform and migrate workloads to Microsoft Fabric.

You will partner with client engineers and Trility consultants to refine Fabric architecture, build reusable ingestion frameworks, and migrate data workloads into a modern lakehouse environment.

This remote W2 role supports clients nationwide with flexible hours and opportunities for learning and advancement.