Lead Data Consultant – Microsoft Fabric

πŸ•’ October 26

⏰ Full Time

🟑 Mid-level

🟠 Senior

πŸ“Š Data Scientist

Where this job comes from

Posted on Trility Consulting's careers page β†—Trility Consulting's careers page, not through a job board

First seen by Remote Rocketship October 26

Still open on Trility Consulting's site. Checked 2 hours ago.

Apply Now
Logo of Trility Consulting

Trility Consulting

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

Apply Now

πŸ“Š Check your resume score for this job

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

Similar Jobs

πŸ•’ October 26

Veeam Software

1001 - 5000

πŸ’Ό Consulting

πŸ“¦ Logistics

☁️ SaaS

Senior Partner Manager growing Veeam’s Data & AI Security practice through strategic U.S. partners. Driving channel revenue, pipeline, executive alignment, and partner enablement.

πŸ•’ October 26

Tempus AI

1001 - 5000

πŸ₯ Healthcare

🧬 Biotechnology

πŸ€– Artificial Intelligence

Senior Data Scientist leading HEOR and real-world evidence studies for Tempus, whose AI platform delivers clinical insights. Analyzing large healthcare datasets with R and SQL.

πŸ•’ October 26

LMI

1001 - 5000

πŸ“¦ Logistics

πŸ₯ Healthcare

πŸŽ–οΈ Defense

Dataverse and data science lead advancing LMI Government Consulting’s DHS CBP analytics. Leading statistical modeling, data governance, machine learning, and mission-critical decision support.

πŸ•’ October 24

CDC Foundation

1001 - 5000

🀝 Non-profit

πŸ₯ Healthcare

🌍 Social Impact

Data Scientist advancing CDC Foundation public-health analytics, predictive modeling, and outbreak surveillance. Building dashboards and geospatial tools for Delaware public-health decision-making.

πŸ•’ October 24

Axle Informatics

501 - 1000

🧬 Biotechnology

πŸ₯ Healthcare

πŸ”¬ Science

Bioinformatics/Data Scientist analyzing organoid multi-omics data for Axle, a bioscience and information technology company. Developing computational pipelines and biomarkers for organoid quality assessment.

Developed byΒ Lior Neu-ner. I'd love to hear your feedback β€” Get in touch via DM or support@remoterocketship.com
Follow Remote Rocketship on LinkedInFollow Remote Rocketship on InstagramFollow Remote Rocketship on FacebookFollow Remote Rocketship on TikTok