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.
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, and performance optimization
- Familiarity with Power BI security models, including Row-Level Security (RLS)
- Strong SQL skills for data transformation, report validation, analytics development, and performance tuning
- Experience working with Azure DevOps CI/CD processes
- Ability to collaborate effectively with technical teams and participate in client-facing discussions when needed
Preferred Experience
- Experience migrating Tableau reports and dashboards to Microsoft Power BI
- Experience implementing Direct Lake semantic models within Microsoft Fabric
- Experience supporting Power BI semantic models, executive dashboards, and KPI reporting
- Experience integrating governance platforms such as Alation
- Experience working within consulting or professional services environments
- Exposure to Azure OpenAI, Power Apps, Power BI Copilot, or other AI-assisted analytics and data workflows
Similar Jobs
What We Do
Trility Consulting® is a fast-growing business and technology consulting firm that helps mid-market to enterprise-sized companies define, design, and deliver custom solutions that solve high-consequence problems for their businesses. Using an outcome-based delivery approach, our teams build modern solutions for clients and bring their people along the journey to ensure a reduced cost of ownership long after the engagement is done. Our key practice areas include Software Design & Development, Cloud Engineering, DevOps Expertise, and Artificial Intelligence & Data. What is essential to helping clients achieve outcomes is our holistic and contextual approach to ensure desired outcomes are achieved. Trility recently was recognized for a second time as an Inc. 5000 Fastest-Growing Private Company in America. Learn more at https://trility.io.
