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.
What You Will Do & The Experience You Will Need
Trility Consulting is actively seeking a Senior Azure Data Consultant with hands-on Microsoft Fabric and Power BI experience to help modernize enterprise analytics platforms. In this role, you will partner with Trility consultants and client engineers to build scalable Microsoft Fabric data solutions while migrating legacy Tableau reporting into governed Power BI semantic models. You'll contribute across the full analytics lifecycle—from data ingestion and transformation through semantic modeling, DAX development, and executive reporting—helping clients establish a modern, maintainable analytics platform.
You'll play a key role in modernizing enterprise reporting by migrating legacy Tableau dashboards into Microsoft Power BI, helping establish reusable semantic models, and delivering governed analytics that support executive decision-making across the organization.
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
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
Build, test, and optimize ETL/ELT processes for performance, scalability, and maintainability
Design and develop reusable semantic models that support consistent enterprise reporting across multiple business domains
Migrate existing Tableau reports and dashboards into Microsoft Power BI while validating business logic and report accuracy
Develop and optimize DAX measures, calculations, and business logic to support executive and operational reporting
Optimize Power BI report performance, usability, and maintainability using Microsoft Fabric best practices
Participate in Azure DevOps CI/CD processes
Partner with business stakeholders to validate reporting requirements and ensure successful report modernization
Collaborate closely with client engineers through paired development and knowledge-sharing activities
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)
Experience working within lakehouse architectures and cloud-based analytics platforms
Experience integrating data from APIs, relational databases, and file-based sources
Strong experience developing Power BI reports, dashboards, and semantic models in production environments
Experience migrating or modernizing analytics platforms such as Tableau, SSRS, or similar BI tools into Power BI
Experience gathering reporting requirements and translating business needs into scalable Power BI and semantic model solutions
Experience designing semantic models that support reusable enterprise reporting
Strong DAX development skills, including measures, calculated columns, a