jobapplier

Power BI Engineer – MS Fabric

Sonata Software

This job is closed: the employer no longer lists it.

Skills

Required

  • BI
  • analytics
  • engineering / BI development / data warehousing
  • Power BI semantic models
  • SQL
  • T-SQL
  • Server
  • stored procedures
  • window functions
  • performance tuning
  • Dimensional modeling
  • star schema
  • Data warehouse design and development
  • Git-based

Preferred

  • Power BI
  • Mesh
  • Microsoft Fabric
  • Lakehouse
  • Direct Lake
  • Git

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

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

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

Preferred

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

Role details

Job Title- Power BI Engineer – MS Fabric Location- Walnut Creek, CA