> Markdown version of [/jobs/ext/3361365-analytics-engineer-microsoft-fabric-consultant](https://www.wearedevelopers.com/jobs/ext/3361365-analytics-engineer-microsoft-fabric-consultant). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Analytics Engineer (Microsoft Fabric Consultant

- **Company:** ZENSARK, INC.
- **Location:** California City, CA, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Data Analysis, Business Intelligence Development, Data Warehousing, Digital Assets, Dimensional Modeling, Microsoft SQL Server, Performance Tuning, Scrum Methodology, Regression Testing, Power BI, Standard Sql, SQL Stored Procedures, SQL Databases, Transact-SQL, Delivery Pipeline, Git, Powerquery, Build Management, Microsoft Fabric, Star Schema, Semantic Modeling, Software Version Control
- **Published:** September 30, 2026
- **Apply:** https://www.dice.com/job-detail/3deded6b-2d44-46b3-ac30-c0943ba29a45

## About the Role

* 5+ years in analytics engineering, BI development, or data warehousing
 * Production ownership of Power BI semantic models - not reports built on a model someone else owns
 * Strong DAX: measures vs. calculated columns, filter context, time intelligence
 * Strong SQL: T-SQL, SQL Server, stored procedures, window functions, CTEs, performance tuning
 * Dimensional modeling and star schema
 * Data warehouse design and development experience
 * Row-level security in production
 * Git-based version control for BI and data assets, with dev/test/prod promotion
 * Power Query (M)
 * Direct experience running requirements conversations and business demos

Preferred

 * dbt or SQLMesh- transformation as code, with testing and lineage
 * DP-600 Certification- Fabric Analytics Engineer Associate (semantic modeling, Lakehouse, DAX)
 * Hands-on Microsoft Fabric: Lakehouse, Warehouse, OneLake, Direct Lake, deployment pipelines
 * Transactional-system reporting background (order-to-cash, operations, logistics, or comparable)
 * Agile/Scrum delivery

## Description

Owns the part of the analytics stack: the semantic model, the business measures, and the reports built on them. Modeling, defining measures once, and turning them into reporting people trust.

This is a code-first role. Transformation logic is SQL and dbt-style modeling against the warehouse, not visual pipeline tooling.

What you'll own

 * Design and build semantic models: structure, relationships, grain, cardinality, business measures, and consumer-facing naming
 * Write and own business measure DAX in the model, including time intelligence and the filter-context work
 * Build and maintain SQL-based transformation logic from source through to reporting-ready tables
 * Own model performance and refresh behavior across Direct Lake and Import modes, including Delta layout and fallback conditions
 * Build Power BI reports and dashboards against your own models; own visualization choices and report performance
 * Implement row-level and object-level security to the approved design
 * Validate source-to-target and regression test when shared models change
 * Promote changes through Git and deployment pipelines across dev/test/prod
 * Document measure definitions, refresh timing, and known limitations; demo working increments to the business
 * Work directly with business stakeholders to turn ambiguous asks into defined requirements


## Related Videos

- [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents)
- [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag)
- [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94)
- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [Git for Code Reviews](https://www.wearedevelopers.com/videos/429-git-for-code-reviews)
- [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)
- [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again)
- [Graph and AI Trends 2026: Why Is AI Running but Not Yet Delivering?](https://www.wearedevelopers.com/magazine/680-graph-and-ai-trends-2026-why-is-ai-running-but-not-yet-delivering)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Dev Digest 120 - Apple and peers](https://www.wearedevelopers.com/magazine/455-dev-digest-120-apple-and-peers)