Remote Senior Data Consultant - Microsoft Fabric Lakehouse

Trility Consulting LLC; Columbia (SC); Remote; USD 120,000 - 170,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 workloads to Microsoft Fabric. The role is remote and US-based, with a focus on building scalable, metadata-driven ingestion pipelines and automated CI/CD workflows.

You will work hands-on with client engineers, guide architectural decisions, and help establish repeatable patterns for maintenance and evolution of the Fabric-based data stack across the engagement.

Qualifications

• 5+ years of experience working with Azure Data Services, including Fabric/Synapse/Databricks.
• Hands-on Fabric experience in production environments, including lakehouses and pipelines.
• Strong SQL skills for data transformation and validation, including T-SQL.
• Experience developing Spark notebooks and data transformation workflows using PySpark and Spark SQL.
• Experience integrating data from REST APIs, relational databases, and structured or semi-structured data sources.

Responsibilities

• Evaluate and refine the existing Microsoft Fabric architecture and ingestion patterns.
• Design metadata-driven ingestion frameworks with configuration-based onboarding.
• Migrate data sources from Azure Synapse to Microsoft Fabric and orchestrate Fabric pipelines.
• Develop PySpark notebooks and Spark SQL transformations for the Fabric lakehouse.
• Implement Git-based CI/CD and environment promotion for Fabric artifacts.

Skills

Azure Data Services

SQL

PySpark

Spark SQL

ETL/ELT

GitHub Actions

Azure DevOps

Fabric

Claude Code

Tools

Microsoft Fabric

Azure Synapse

Azure Data Factory

Databricks

Purview

Job description

Trility Consulting LLC is seeking a Senior Data Consultant to modernize an Azure Synapse data platform and migrate workloads to Microsoft Fabric. The role is remote and US-based, with a focus on building scalable, metadata-driven ingestion pipelines and automated CI/CD workflows.

You will work hands-on with client engineers, guide architectural decisions, and help establish repeatable patterns for maintenance and evolution of the Fabric-based data stack across the engagement.