Power BI Engineer – MS Fabric

Sonata Software•San Antonio, TX

6h•Onsite

About The Position

Sonata Software is seeking a Power BI Engineer with expertise in MS Fabric to join their team. This role involves designing, building, and maintaining Power BI semantic models and reports, ensuring performance, security, and adherence to best practices. The engineer will work directly with business stakeholders to translate requirements into functional BI solutions and manage the promotion of changes through development pipelines.

Requirements

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

Nice To Haves

SQL Mesh - 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)

Responsibilities

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