Remote Senior Data Consultant - Fabric & Synapse Platform

Trility Consulting LLC; Iowa Center (IA); Remote; USD 120,000 - 180,000; Full time

Benefits offered by this job

Remote work

Paid time off

401(k) plan

Learning opportunities

Job summary

Trility Consulting LLC is seeking an experienced Senior Data Consultant to modernize an Azure Synapse platform and migrate workloads to Microsoft Fabric. The role collaborates with client engineers to build scalable data pipelines, metadata-driven ingestion, and AI-assisted development using Claude Code, while ensuring data quality and governance in a remote W2 engagement.

You will design Fabric architectures, implement ingestion patterns, and establish repeatable patterns for ongoing platform

Qualifications

• 5+ years of experience with Azure Data Services (including Microsoft Fabric, Azure Data Factory, Databricks or Synapse)
• Strong SQL and data transformation skills
• Experience building ETL/ELT pipelines and data ingestion frameworks
• Experience with Git-based CI/CD workflows (GitHub Actions/Azure DevOps)
• Familiarity with data governance, lineage, metadata management and data catalog concepts

Responsibilities

• Evaluate and refine Microsoft Fabric architecture and metadata structures
• Design a metadata-driven ingestion framework configurable via onboarding
• Migrate data workloads from Azure Synapse to Microsoft Fabric
• Develop Fabric data pipelines and Spark notebooks using PySpark and Spark SQL
• Implement data validation, reconciliation, and performance monitoring for migrations
• Establish CI/CD workflows for Fabric artifacts and notebooks using GitHub Actions or Azure DevOps
• Leverage Claude Code to guide AI-assisted development and review generated code
• Collaborate with client engineers and maintain sustainable engineering standards
• Provide guidance on data dictionary, metadata, and lineage requirements
• Support security, testing, and operational support best practices

Job description

Trility Consulting LLC is seeking an experienced Senior Data Consultant to modernize an Azure Synapse platform and migrate workloads to Microsoft Fabric. The role collaborates with client engineers to build scalable data pipelines, metadata-driven ingestion, and AI-assisted development using Claude Code, while ensuring data quality and governance in a remote W2 engagement.

You will design Fabric architectures, implement ingestion patterns, and establish repeatable patterns for ongoing platform