Senior Data Consultant (Microsoft Fabric/Azure)

Team: Technology

Location: United States

Commitment: FTE or 1099

Workplace Type: remote

What You Will Do & The Experience You Will Need

Build Your Future with Trility Consulting

Trility Consulting is continually building relationships with experienced Microsoft Fabric consultants as we prepare for upcoming client engagements. While this is not an immediate opening, we are actively identifying senior-level professionals who are interested in future opportunities and can move quickly through our interview process when new projects are approved.

As a Senior Data Consultant, youll partner with Trility consultants and client engineers to design, build, and optimize modern Microsoft Fabric solutions. Our consultants lead the implementation of production-ready data platforms, develop scalable ingestion pipelines and lakehouse architectures, and help clients successfully adopt Microsoft Fabric through our collaborative Coach-and-Contribute delivery model.

Successful consultants may work on projects involving Microsoft Fabric, Azure Data Services, modern analytics platforms, data modernization initiatives, and enterprise reporting solutions across a variety of industries.

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.

Note: This is a proactive opening for future hiring needs. While this position is not currently active, we are accepting applications and reviewing talent in preparation for upcoming project opportunities. Qualified candidates will be contacted when interviews begin.

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

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

Preferred Experience

• 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