Power BI Engineer – MS Fabric

Sonata Software North America Inc.; San Antonio (TX); On-site; USD 130,000 - 170,000; Full time

Job summary

Sonata Software is seeking a Power BI Engineer in Walnut Creek, CA to design semantic models, author DAX, and create SQL transformations for reporting-ready data.

Qualifications

• 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

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

Skills

Power BI semantic models

DAX

SQL / T-SQL

Dimensional modeling

Data warehousing

Row-level security

Git-based workflow

Requirements gathering & demos

Direct Lake / Import modes knowledge

Performance tuning

Tools

Power BI

Microsoft Fabric

SQL Server

Git

Power Query

Job description

Location- Walnut Creek, CA

• 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

Job Title- Power BI Engineer – MS Fabric

Location- Walnut Creek, CA

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

Qualifications & Required Skills

• 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

Preferred Skills

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

About Sonata Software

Sonata Software is an AI-first modernization engineering company that helps enterprises transform legacy systems into intelligent, scalable business platforms. Powered by its Platformation™ framework and Harmoni.AI platform, Sonata delivers AI-led modernization across cloud, data, AI, Dynamics, test automation, and managed services. Headquartered in Bengaluru, India, Sonata has more than $1.2 billion in revenue and 6,400+ AI engineers supporting global delivery across regions including the US, UK, India, Malaysia, Mexico, Australia, DACH, and the Nordics. With deep partnerships across Microsoft, AWS, Salesforce, and Snowflake, Sonata helps Fortune 500 enterprises accelerate innovation, improve efficiency, and drive sustainable growth.

For more information, please visit www.sonata-software.com

Sonata Software is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity, age, religion, disability, sexual orientation, veteran status, marital status, or any other characteristics protected by law