Note: The job is a remote job and is open to candidates in USA. Trility Consulting is a remote-first company that values a strong work culture and collaboration across distributed teams. They are seeking a Senior Data Consultant with expertise in Microsoft Fabric to build and scale modern data solutions, including implementing data ingestion pipelines and developing lakehouse solutions.
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
Skills
- 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
- 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
Benefits
- 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
Company Overview