Lead design and build of Microsoft Fabric data solutions and Power BI semantic models. Migrate Tableau reports to governed Power BI, develop Spark notebooks, implement medallion lakehouse patterns, optimize ETL/ELT and DAX, and support CI/CD and stakeholder validation.
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 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, 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
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
Cloud • Enterprise Web • Information Technology • Software • Business Intelligence • Consulting • App development
The Senior Azure Data Consultant will build and maintain data pipelines, develop lakehouse solutions, optimize ETL processes, and support analytics capabilities in a Microsoft Fabric environment.
Top Skills:
Azure Data FactoryAzure DevopsDatabricksMicrosoft FabricPower BI
Aerospace • Hardware • Information Technology • Security • Software • Cybersecurity • Defense
Lead supplier quality for PWB/PCB suppliers: audit, evaluate, and improve manufacturing and inspection processes. Drive root-cause analysis, failure investigations, FAI/PPAP, source inspections, supplier scorecards, and continuous improvement to ensure first-time quality for aerospace and defense programs.
Top Skills:
ApqpAs9100As9102Asme Y14.5Black BeltControl PlanFaiGreen BeltIpc-6012Ipc-6013Ipc-6018Ipc-A-600Ipc-A-610Ipc-Tm-650Lean Six SigmaMil-Prf-31032Mil-Prf-38534Mil-Std-883PfmeaPpapSource Inspection
Aerospace • Hardware • Information Technology • Security • Software • Cybersecurity • Defense
Lead supplier quality for Printed Wiring Boards: audit suppliers, perform source and first-article inspections, drive root-cause analysis and corrective actions, implement process improvements, and ensure compliance with PWB and aerospace standards to deliver first-time quality.
Top Skills:
ApqpAs9100As9102Asme Y14.5Asme Y15.1Black BeltControl PlanFirst Article InspectionGreen BeltIpc-6012Ipc-6013Ipc-6018Ipc-A-600Ipc-A-610Ipc-Tm-650Lean Six SigmaMil-Prf-31032Mil-Prf-38534Mil-Prf-55110Mil-Std-883PfmeaPpapSource Inspection
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
