Remote Senior Data Consultant, Microsoft Fabric

Trility Consulting LLC; Colorado; Remote; USD 130,000 - 170,000; Full time

Benefits offered by this job

Paid time-off

Floating holidays

Job summary

Trility Consulting LLC in the United States is seeking a Senior Data Consultant to modernize an Azure Synapse data platform, migrate workloads to Microsoft Fabric, and build scalable, metadata-driven ingestion and CI/CD processes.

You will work with client engineers and Trility teams, implement PySpark notebooks, Spark SQL, and data validation, using Claude Code for AI-assisted development, and ensure migration accuracy across sources.

Qualifications

• 5+ years of experience with Azure Data Services including Fabric, Data Factory, Databricks, or Synapse.
• Hands-on Fabric production experience in lakehouses, pipelines, medallion architecture and capacity management.
• Strong SQL and T-SQL skills for data transformation, validation, and performance tuning.
• Experience designing and implementing Git-based CI/CD workflows (GitHub Actions, Azure DevOps).
• Experience using Claude Code for AI-assisted software development and code review.

Responsibilities

• Evaluate and refine Microsoft Fabric architecture and metadata structures.
• Design a metadata-driven ingestion framework for config-based onboarding of new tables/sources.
• Migrate prioritized data sources from Azure Synapse to Microsoft Fabric.
• Develop Fabric data pipelines and Spark notebooks using PySpark and Spark SQL.
• Analyze existing Synapse pipelines to map dependencies to Fabric solutions.
• Build data validation and reconciliation processes to verify migration accuracy.
• Determine appropriate full-load, incremental, or CDC patterns per source.
• Implement Git-based CI/CD and environment promotion for Fabric artifacts.
• Utilize Claude Code to define implementation specs and review generated code.
• Evaluate data dictionary, metadata, and lineage requirements; assess catalog options like Purview.
• Apply best practices in performance, testing, monitoring, security, and operations.

Skills

Azure Data Services

Microsoft Fabric

Azure Data Factory

Databricks

Spark notebooks

PySpark

Spark SQL

GitHub Actions

Azure DevOps

Claude Code

SQL

ETL/ELT pipelines

Tools

Claude Code

Microsoft Purview

Azure DevOps

Job description

Trility Consulting LLC in the United States is seeking a Senior Data Consultant to modernize an Azure Synapse data platform, migrate workloads to Microsoft Fabric, and build scalable, metadata-driven ingestion and CI/CD processes.

You will work with client engineers and Trility teams, implement PySpark notebooks, Spark SQL, and data validation, using Claude Code for AI-assisted development, and ensure migration accuracy across sources.