Lead Data Consultant – Microsoft Fabric

Trility Consulting

. Support a client engagement modernizing an Azure Synapse data platform and migrating prioritized workloads to Microsoft Fabric .

Posted 10/26/2026full-timeRemote • United StatesSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates extensive experience in modernizing data platforms using Microsoft Fabric and Azure Data Services, with a strong focus on building and maintaining ETL/ELT pipelines and metadata-driven ingestion frameworks. Proficient in data validation, migration accuracy, and implementing CI/CD workflows for data solutions.

Highest-signal resume keywords

Microsoft FabricAzure Data ServicesETL/ELT Pipeline DevelopmentPySpark and Spark SQLGit-based CI/CD Workflows

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Azure SynapseData TransformationMetadata-driven Ingestion FrameworksSQLData Migration ValidationIncremental IngestionCDC Loading PatternsData GovernanceMedallion ArchitectureClaude Code

Soft Skills

Strong Written CommunicationStrong Verbal CommunicationClient-facing Technical Discussions

Tools & Technologies

Azure Data FactoryDatabricksGitHub ActionsAzure DevOpsMicrosoft Purview

Industry Keywords

Data CatalogData LineageMetadata ManagementProduction EnvironmentsConsulting Services

Tech Stack

Tools & technologies

AzureETLOraclePySparkSparkSQL

About the role

Key responsibilities & impact

Support a client engagement modernizing an Azure Synapse data platform and migrating prioritized workloads to Microsoft Fabric
Evaluate and refine Microsoft Fabric architecture, metadata structures, event triggering, and reusable ingestion patterns
Design and implement metadata-driven ingestion frameworks with configuration-based onboarding
Migrate data sources and workloads from Azure Synapse into Microsoft Fabric
Develop and orchestrate Fabric pipelines and Spark notebooks using PySpark and Spark SQL
Analyze existing Synapse pipelines and translate processing logic into Fabric solutions
Build validation and reconciliation processes for migration accuracy, including duplicate detection, key alignment, and record comparisons
Recommend full-load, incremental, or CDC loading patterns
Implement Git-based CI/CD and automated environment promotion for Fabric artifacts
Use Claude Code to define specifications, accelerate development, and review AI-generated code
Evaluate data dictionary, metadata, lineage, and catalog requirements
Collaborate with client engineers through paired development, code reviews, and knowledge-sharing sessions
Apply best practices for performance, testing, monitoring, documentation, security, and operational support

Requirements

What you’ll need

Must reside within the United States
W2 employees must reside in Alabama, Colorado, Delaware, Florida, Georgia, Iowa, Kansas, Kentucky, Louisiana, Minnesota, Missouri, Montana, Nebraska, Nevada, North Carolina, Ohio, South Carolina, Tennessee, Texas, Virginia, or Wisconsin
Must be authorized to work in the United States without sponsorship now or in the future
Must be able to pass a background check
5+ years of experience working with Azure Data Services, including Microsoft Fabric, Azure Data Factory, Databricks, or Synapse
Hands-on Microsoft Fabric experience in production environments, including lakehouses, pipelines, notebooks, medallion architecture, workspaces, and capacity management
Strong experience building and maintaining production ETL/ELT pipelines and reusable data ingestion frameworks
Demonstrated experience designing and implementing metadata-driven ingestion frameworks
Experience developing Spark notebooks and data transformation workflows using PySpark and Spark SQL
Strong SQL skills for data transformation, validation, and performance tuning, including T-SQL
Experience working with Azure Synapse and complex data processing dependencies
Experience implementing Bronze, Silver, and Gold medallion architecture patterns
Experience designing and implementing Git-based CI/CD workflows using GitHub Actions, Azure DevOps, or similar tooling
Hands-on experience using Claude Code for AI-assisted software development
Experience validating data migrations and ensuring data quality, accuracy, and consistency
Experience integrating data from REST APIs, relational databases, and structured or semi-structured data sources
Familiarity with data governance, lineage, metadata management, and data catalog concepts
Ability to participate in client-facing technical discussions
Strong written and verbal communication skills
Preferred: experience migrating Azure Synapse workloads to Microsoft Fabric; Oracle and DB2; incremental ingestion and CDC; migration reconciliation frameworks; Microsoft Purview; consulting or professional services

Benefits

Comp & perks

Work remotely anywhere in the United States with flexible work hours
Paid time-off, company holidays, and floating holidays
Comprehensive benefits with contributions toward premiums
401(k) plan
Sponsored and supported learning opportunities
W2 or 1099 engagement options