Senior Data Consultant: Microsoft Fabric & Azure—Remote

Trility Consulting LLC; Guin (AL); Remote; USD 120,000 - 155,000; Full time

Benefits offered by this job

Paid time-off

Floating holidays

Company 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 partner with Trility consultants and client engineers to validate Fabric architecture, build metadata-driven ingestion, and migrate data workloads into a modern lakehouse environment.

You’ll work hands-on with client engineers, influence architectural decisions, and help establish repeatable patterns for ongoing maintenance and

Qualifications

• 5+ years of experience with Azure Data Services, including Fabric, ADF, Databricks or Synapse
• Hands-on Fabric experience in production environments (lakehouses, pipelines, notebooks)
• Strong experience building/maintaining production ETL/ELT pipelines
• Design/implement metadata-driven ingestion frameworks with config-based onboarding
• Experience developing Spark notebooks and data transformations with PySpark & Spark SQL
• Strong SQL skills for data transformation, validation, and performance tuning
• Experience with Git-based CI/CD for data artifacts (GitHub Actions, Azure DevOps)
• Hands-on Claude Code for AI-assisted software development and code review
• Experience validating data migrations and ensuring data quality across systems
• Experience integrating data from REST APIs and databases; familiar with data governance and catalog concepts
• Experience migrating data platforms from Synapse to Fabric; Oracle and DB2 experience

Responsibilities

• Evaluate and refine the Fabric architecture, including metadata structures and reusable ingestion patterns
• Design a metadata-driven ingestion framework allowing config-based onboarding of new tables/sources
• Migrate prioritized data sources from Azure Synapse to Fabric
• Develop and orchestrate Fabric data pipelines and Spark notebooks (PySpark, Spark SQL)
• Analyze existing Synapse pipelines to understand dependencies and translate logic to Fabric
• Build data validation and reconciliation processes to verify migration accuracy
• Analyze loading requirements and recommend full-load, incremental, or CDC patterns
• Implement Git-based CI/CD and environment promotion for Fabric artifacts via GitHub Actions or Azure DevOps
• Use Claude Code to define specs, speed up development, review AI-generated code
• Evaluate metadata, lineage, and catalog needs (e.g., Purview)
• Apply data engineering best practices for performance, testing, monitoring, security, and ops

Skills

Azure Data Services

Microsoft Fabric

ETL Pipelines

PySpark

Spark SQL

SQL

GitHub Actions

Azure DevOps

Claude Code

Data Migrations

Data Quality

Tools

Databricks

Azure Data Factory

Azure Synapse

Purview

REST APIs

Oracle

DB2

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 partner with Trility consultants and client engineers to validate Fabric architecture, build metadata-driven ingestion, and migrate data workloads into a modern lakehouse environment.

You’ll work hands-on with client engineers, influence architectural decisions, and help establish repeatable patterns for ongoing maintenance and