Senior Data Consultant (Microsoft Fabric/Azure)

Trility Consulting

3d•Remote

About The Position

Trility Consulting is actively seeking experienced Senior Data Consultants with expertise in Microsoft Fabric and Azure for future client engagements. This role involves partnering with internal consultants and client engineers to design, build, and optimize modern Microsoft Fabric solutions. Consultants will lead the implementation of production-ready data platforms, develop scalable ingestion pipelines and lakehouse architectures, and facilitate client adoption of Microsoft Fabric through a collaborative Coach-and-Contribute delivery model. Successful candidates may work on projects involving Microsoft Fabric, Azure Data Services, modern analytics platforms, data modernization initiatives, and enterprise reporting solutions across various industries. This is a remote position, with project length, schedule, and employment type varying based on client needs. Trility is currently only able to hire W2 employees residing in specific US states.

Requirements

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
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

Nice To Haves

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

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