Designs, builds, and optimizes Microsoft Fabric and Azure data platforms, including ingestion pipelines, Spark notebooks, medallion lakehouse architectures, ETL/ELT workflows, semantic models, and Direct Lake solutions. The consultant supports CI/CD, governance, lineage, security, monitoring, and operational best practices while collaborating with client engineers through paired development and knowledge sharing. This remote consulting role supports future client engagements and requires strong communication, SQL, cloud data engineering, and production Microsoft Fabric experience.
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.
Build Your Future with Trility Consulting
Trility Consulting is continually building relationships with experienced Microsoft Fabric consultants as we prepare for upcoming client engagements. While this is not an immediate opening, we are actively identifying senior-level professionals who are interested in future opportunities and can move quickly through our interview process when new projects are approved.
As a Senior Data Consultant, you'll partner with Trility consultants and client engineers to design, build, and optimize modern Microsoft Fabric solutions. Our consultants lead the implementation of production-ready data platforms, develop scalable ingestion pipelines and lakehouse architectures, and help clients successfully adopt Microsoft Fabric through our collaborative Coach-and-Contribute delivery model.
Successful consultants may work on projects involving Microsoft Fabric, Azure Data Services, modern analytics platforms, data modernization initiatives, and enterprise reporting solutions across a variety of industries.
This is a remote W2 or 1099 position. Project length, schedule, and employment type may vary based on client engagement and business needs.
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
- Build and maintain Microsoft Fabric data pipelines supporting REST APIs, SQL Server sources, and file-based ingestion processes
- Develop and orchestrate Spark notebooks within Microsoft Fabric
- Implement Bronze, Silver, and Gold lakehouse patterns within OneLake environments
- Develop ingestion processes that accommodate schema drift and evolving source systems
- Design reusable ingestion frameworks and scalable data engineering patterns that accelerate future solution delivery.
- Build, test, and optimize ETL/ELT processes for performance, scalability, and maintainability
- Support the implementation of semantic models, Direct Lake solutions, and downstream analytics requirements.
- Participate in Azure DevOps CI/CD processes, including Dev/Test/Prod promotion workflows
- Implement metadata, lineage, governance, and security best practices to support enterprise-scale Microsoft Fabric solutions.
- Collaborate closely with client engineers through paired development and knowledge-sharing activities
- Apply data engineering best practices related to testing, monitoring, documentation, 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
- Strong experience building and maintaining ETL/ELT pipelines
- Experience developing Spark notebooks and data transformation workflows
- Experience implementing medallion architecture patterns (Bronze, Silver, Gold)
- Strong SQL skills for data transformation, validation, and performance tuning
- Experience integrating data from REST APIs, relational databases, XML, CSV, and other structured or semi-structured data sources.
- Experience working with Azure DevOps CI/CD processes
- Familiarity with data governance, lineage, and metadata management concepts
- Experience working within lakehouse architectures and cloud-based analytics platforms
- Ability to collaborate effectively with technical teams and participate in client-facing discussions when needed
- Strong written and verbal communication skills
Preferred Experience
- Experience with Direct Lake implementations
- Experience integrating governance platforms such as Alation
- Experience supporting Power BI semantic models and analytics workloads
- Experience working within consulting or professional services environments
- Exposure to Azure OpenAI, Power Apps, or AI-assisted data workflows
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
.png)
Artificial Intelligence • Cloud • Payments • Software • Business Intelligence • Generative AI • Automation
Sell connectivity, data solutions, and AI-powered risk digitization software to insurance carriers and MGA clients across Canada. Responsibilities include developing strategic account plans, acquiring new logos, expanding existing accounts, managing executive relationships, negotiating renewals, forecasting sales, gathering market feedback, and meeting or exceeding quotas. The role uses a consultative solution-selling methodology and involves virtual, telephone, onsite, and industry-event engagements.
Top Skills:
Ai-Powered Risk Digitization PlatformsCrm SystemsExcelMicrosoft OutlookMicrosoft PowerpointMicrosoft WordSalesforceSlack
Automotive • Big Data • Information Technology • Robotics • Software • Transportation • Manufacturing
Build and deploy end-to-end software and analytics products for engineering teams. Responsibilities include developing Python services, TypeScript/React interfaces, relational data models, data pipelines, APIs, and Databricks jobs. The role also involves collaborating with data scientists and stakeholders, deploying production systems on Kubernetes and Azure, maintaining CI/CD and infrastructure-as-code workflows, monitoring services, and contributing to testing, code reviews, documentation, and user-friendly product design.
Top Skills:
AzureCi/CdDatabricksDelta LakeFastapiGitopsInfrastructure As CodeJavaScriptKubernetesNext.JsPostgresPysparkPythonReactReact Server ComponentsSQLSqlalchemyTypescript
Automotive • Big Data • Information Technology • Robotics • Software • Transportation • Manufacturing
Improves Global Talent processes, governance, onboarding, localization and translation workflows, information management, and technology-enabled solutions. Analyzes workflows, documents standards, coordinates stakeholders and vendors, monitors adoption and effectiveness, and leads moderate-scope improvements. The role also identifies opportunities for responsible AI and automation while maintaining appropriate human oversight, privacy, security, quality, and compliance.
Top Skills:
Artificial IntelligenceAutomationCollaboration ToolsDocumentation ToolsInformation-Management ToolsReporting ToolsWorkflow Tools
What you need to know about the Seattle Tech Scene
Home to tech titans like Microsoft and Amazon, Seattle punches far above its weight in innovation. But its surrounding mountains, sprinkled with world-famous hiking trails and climbing routes, make the city a destination for outdoorsy types as well. Established as a logging town before shifting to shipbuilding and logistics, the Emerald City is now known for its contributions to aerospace, software, biotech and cloud computing. And its status as a thriving tech ecosystem is attracting out-of-town companies looking to establish new tech and engineering hubs.
Key Facts About Seattle Tech
- Number of Tech Workers: 287,000; 13% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Amazon, Microsoft, Meta, Google
- Key Industries: Artificial intelligence, cloud computing, software, biotechnology, game development
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Madrona, Fuse, Tola, Maveron
- Research Centers and Universities: University of Washington, Seattle University, Seattle Pacific University, Allen Institute for Brain Science, Bill & Melinda Gates Foundation, Seattle Children’s Research Institute
