Lead Data Consultant – Microsoft Fabric

🔥 0 minutes ago

🏈 Alabama, Colorado, +17 more states – Remote

🏈 Alabama – Remote ⛰️ Colorado – Remote 🐊 Florida – Remote 🌾 Iowa – Remote 🌪️ Kansas – Remote 🐎 Kentucky – Remote ⚜️ Louisiana – Remote 🦬 Montana – Remote 🌾 Nebraska – Remote 🎰 Nevada – Remote 🌲 North Carolina – Remote 🏈 Ohio – Remote ❄️ Minnesota – Remote 🏰 Missouri – Remote 🌴 South Carolina – Remote 🎸 Tennessee – Remote 🤠 Texas – Remote ⚔️ Virginia – Remote 🧀 Wisconsin – Remote

⏰ Full Time

🟠 Senior

📊 Data Scientist

👻 Ghost score 11%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Trility Consulting

WebsiteLinkedInAll Job Openings

51 - 200 employees

💼 Consulting

📦 Logistics

📣 Marketing

Consulting • Logistics • Marketing

Trility Consulting is a business-driven technology consulting firm focused on AI & Data, software design and development, cloud engineering, and DevOps. Known for its values of trust, partnership, and excellence, Trility offers a collaborative approach to tackle important business challenges with clarity and confidence. The company emphasizes continuous delivery and security by design, employing a proven, scalable methodology to achieve modern solutions. Recognized as Technology Company of the Year in Iowa, Trility is owned by its senior executives, ensuring investment and outcome-driven project management. With a focus on predictability, repeatability, and auditability, Trility serves clients across various industries, offering both full-stack solutions and strategic consulting expertise.

📋 Description

• 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

• 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

• 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