Designs and refines Microsoft Fabric architectures, builds metadata-driven ingestion frameworks, migrates Azure Synapse workloads, and develops PySpark and Spark SQL pipelines. The role includes data validation, reconciliation, CDC strategies, medallion architecture, Git-based CI/CD, governance and lineage assessment, and AI-assisted development with Claude Code. The consultant collaborates directly with client engineers through paired development, code reviews, architecture decisions, and knowledge sharing.
Who We Are
At Trility Consulting®, we’ve built a strong, remote-work culture where people thrive, grow, and support each other – earning us Great Place to Work® Certification. Headquartered in Central Iowa, we embrace flexible schedules and collaboration across geographically distributed teams serving clients from all corners of the United States and globally.
We seek team members with the grit necessary to forge paths where none previously existed, to get back up when circumstances knock them down, to adapt to the changing needs of the client even when it is uncomfortable, and to deliver on our commitments. Candidates must respect and value people, recognize that over-communication is barely good enough, thrive on solving complex problems, have a passion for building teams, and know that delivering what a client actually values is more important than their own predispositions. They understand value proposition, love delivering value, and take pride in learning the expansive and ever-changing business of clients. Candidates are self-motivated and relentlessly working to become more today than they were yesterday.
Trility Consulting is seeking an experienced Senior Data Consultant to support a client engagement focused on modernizing an existing Azure Synapse data platform and migrating prioritized workloads to Microsoft Fabric.
In this role, you'll partner with Trility consultants and client engineers to pressure-test and refine the Fabric architecture, build reusable, metadata-driven ingestion frameworks, and migrate data workloads into a modern lakehouse environment. You'll develop scalable data pipelines, implement validation processes to ensure migration accuracy, and establish automated CI/CD workflows that support reliable deployment from development through production.
This engagement follows Trility's collaborative Coach-and-Contribute delivery model. You'll work hands-on alongside client engineers, contribute to architectural decisions, and help establish repeatable patterns that enable the team to maintain and extend the platform independently. Experience using Claude Code as part of an AI-assisted development workflow is essential to this engagement.
This is a remote W2 or 1099 position.
At this time, Trility is only able to hire W2 employees who reside in the following states: Alabama, Colorado, Delaware, Florida, Georgia, Iowa, Kansas, Kentucky, Louisiana, Minnesota, Missouri, Montana, Nebraska, Nevada, North Carolina, Ohio, South Carolina, Tennessee, Texas, Virginia, and Wisconsin.
Your Responsibilities
- Evaluate and refine the existing Microsoft Fabric architecture, including metadata structures, table-level event triggering, and reusable ingestion patterns
- Design and implement a metadata-driven ingestion framework that allows new tables and sources to be onboarded through configuration rather than custom development
- Migrate prioritized data sources and workloads from Azure Synapse into Microsoft Fabric
- Develop and orchestrate Fabric data pipelines and Spark notebooks using PySpark and Spark SQL
- Analyze existing Azure Synapse pipelines, including complex and nested workflows, to understand dependencies and translate existing processing logic into Fabric solutions
- Build data validation and reconciliation processes to verify migration accuracy, including duplicate detection, key alignment, and record-level comparisons between Synapse and Fabric
- Analyze source-specific loading requirements and recommend appropriate full-load, incremental, or change data capture (CDC) patterns
- Implement Git-based CI/CD and automated environment promotion for Fabric artifacts, including pipelines and notebooks, using GitHub Actions, Azure DevOps, or similar tooling
- Leverage Claude Code to define implementation specifications, accelerate development, and review AI-generated code for quality, correctness, and maintainability
- Evaluate data dictionary, metadata, and lineage requirements, including potential catalog solutions such as Microsoft Purview
- Collaborate with client engineers through paired development, code reviews, and knowledge-sharing sessions to establish sustainable engineering standards
- Apply data engineering best practices related to performance, testing, monitoring, documentation, security, and operational support
What You Bring
- 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 a metadata-driven ingestion framework, including configuration-based onboarding and extensible processing patterns
- Experience developing Spark notebooks and data transformation workflows using PySpark and Spark SQL
- Strong SQL skills for data transformation, validation, and performance tuning, including the ability to read and understand existing T-SQL logic
- Experience working with Azure Synapse, including analyzing existing pipelines and understanding complex data processing dependencies
- Experience implementing medallion architecture patterns (Bronze, Silver, Gold)
- Experience designing and implementing Git-based CI/CD workflows for data platform artifacts using GitHub Actions, Azure DevOps, or similar tooling
- Hands-on experience using Claude Code for AI-assisted software development, including directing code generation, working across multiple files, and critically reviewing generated code
- Experience validating data migrations and ensuring data quality, accuracy, and consistency across source and target systems
- 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 collaborate effectively with technical teams, challenge existing approaches constructively, and participate in client-facing technical discussions
- Strong written and verbal communication skills
Preferred Experience
- Experience migrating data platforms or workloads from Azure Synapse to Microsoft Fabric
- Experience working with Oracle and DB2 data sources
- Experience implementing incremental ingestion, change data capture (CDC), and source-specific loading strategies
- Experience developing data reconciliation and validation frameworks for large-scale migrations
- Experience evaluating Microsoft Purview or other data catalog and lineage solutions
- Experience working within consulting or professional services environments
How We Put You First
Trility’s culture is built upon the journey, character, and work ethic of our team members. We are a team of honorable and professional lifelong learners who work together to solve problems proactively.
• 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
Job Requirements
• Must reside within the United States
• Must be authorized to work in the United States without sponsorship now or in the future
• Must be able to pass a background check
Similar Jobs
Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Handles inbound calls and warm leads, consults customers on insurance needs, recommends appropriate Property and Casualty coverage, and converts prospects into policyholders. The role includes paid licensing and training, customer communication, sales closing, and adherence to remote-work requirements. Employees must work four weekdays and one weekend day, maintain a dedicated home workspace, and remain in their resident state for at least one year due to licensing restrictions.
Top Skills:
Cable InternetDsl InternetFiber InternetPcWired High-Speed Internet
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
Provides strategic technical consulting to enterprise customers using Atlassian Cloud, AI, and related solutions. Responsibilities include solving business challenges, developing prescriptive technical guidance, supporting cloud migrations, designing AI proof-of-concept solutions, promoting service expansion, advocating for customer needs, and collaborating across internal teams. The role requires customer-facing expertise, strong knowledge of Atlassian ecosystems and SaaS architectures, and up to 30% domestic and international travel.
Top Skills:
Ai AgentsAtlassian CloudCloud MigrationConfluenceFocusGuardHybrid SaasJira Service ManagementJira SoftwareLarge Language ModelsOn-Premises DeploymentsPrompt EngineeringRovoSaas Architectures
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
Designs and maintains SaaS integrations, middleware, APIs, webhooks, automation scripts, and data pipelines. Optimizes enterprise software usage, supports AI integrations, troubleshoots complex technical issues, manages vendors and SLAs, tracks licensing and budgets, and translates business needs into technical requirements.
Top Skills:
Anthropic ApisAPIsAtlassian JsmAutomation WorkflowsCursor ApisData PipelinesMiddlewareOpenai ApisSaaSWebhooks
What you need to know about the Los Angeles Tech Scene
Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.
Key Facts About Los Angeles Tech
- Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
- Key Industries: Artificial intelligence, adtech, media, software, game development
- Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
- Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering
