The role involves designing, implementing, and optimizing data solutions within the Microsoft Fabric ecosystem, focusing on Power BI, data integration, and automation while collaborating with clients for platform adoption.
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 a Microsoft Fabric Consultant who brings a full-stack mindset to modern data platforms. This role is ideal for someone who is comfortable operating in Power BI and beyond — someone who understands how the entire data ecosystem comes together and can help clients fully leverage the capabilities of Microsoft Fabric.
You’ll work alongside a Power BI-focused consultant on the same engagement, helping to design, implement, and optimize the broader platform that supports reporting, data integration, automation, and governance. This is a hands-on consulting role where you’ll both build and guide — identifying opportunities to unlock more value from the tools the client has already invested in.
This is a remote position with 1099 and W2 options.
Key Responsibilities
- Design and implement scalable data solutions within the Microsoft Fabric ecosystem
- Strong experience building reports and dashboards in Power BI
- Stand up and configure Fabric services to support data ingestion, transformation, modeling, and reporting
- Develop and optimize semantic models that support both reporting and broader data consumption needs
- Establish and guide best practices for workspace organization, capacity management, and workload distribution
- Design and implement secure data access patterns, including integration between Snowflake and Fabric
- Evaluate and support Snowflake-to-Fabric connectivity, mirroring strategies, and performance optimization
- Identify opportunities to leverage Fabric capabilities such as data agents, automation tooling, and DevOps integration
- Build and support automation solutions, including replacements for legacy processes (e.g., Oracle BI agents, scheduled workflows)
- Partner with client teams to guide platform adoption and increase internal capability through collaborative sessions
- Contribute to the development of standards, reusable patterns, and migration playbooks for long-term sustainability
What You Bring
- Experience working across the Microsoft Fabric ecosystem beyond just Power BI
- Ability to stand up and configure Fabric services, including data integration and platform components
- Strong understanding of modern data architecture principles and how reporting fits into the broader ecosystem
- Experience integrating Snowflake with downstream tools like Fabric and optimizing data flow and performance
- Knowledge of security models, including cross-platform access patterns and governance considerations
- Experience with automation and orchestration tools within the Microsoft ecosystem (e.g., Power Automate or Fabric-native capabilities)
- Familiarity with DevOps concepts, including deployment pipelines and environment promotion strategies
- Ability to identify opportunities to better leverage existing platform investments and drive additional value
- Comfortable working in client-facing environments and guiding technical conversations
- Strong communication skills with the ability to translate complex concepts into practical solutions
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
Fintech • Legal Tech • Software • Financial Services • Cybersecurity • Data Privacy
The Associate Vendor Management Specialist oversees project management, data analysis, and conflict resolution, ensuring licensing compliance and maintaining relationships with jurisdictional offices.
Top Skills:
ExcelMS OfficeSalesforceSharepoint
eCommerce • Healthtech • Kids + Family • Retail • Social Media
The Director, Payer Strategy will lead Babylist Health's payer strategy, managing relationships and offering strategic guidance for growth in both Medicaid and commercial channels.
Top Skills:
AI
Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
The Software Engineer will enhance Lending products for Cash App, focusing on building complex systems, APIs, and collaborating with multiple teams to support economic empowerment through accessible credit.
Top Skills:
AuroraAWSDynamoDBGrpcGuiceHibernateHTTPJavaJettyJooqJSONJunitKafkaKotlinMySQLOkhttpProtocol BuffersRedisVitess
What you need to know about the Colorado Tech Scene
With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
