Analytics Engineer: Power BI with Fabric Semantic Modeling

Amtex Enterprises Inc; Walnut Creek (CA); Hybrid; USD 120,000 - 180,000; Full time

Job summary

Amtex Enterprises Inc. in Walnut Creek, CA, seeks an Analytics Engineer specializing in Microsoft Fabric and Power BI to own semantic models, measures, and reporting across the analytics stack.

This is a code-first, production-focused role with emphasis on data transformation, security, and stakeholder collaboration. You will transform data with SQL/dbt-style modeling, implement security, and work with stakeholders to turn ambiguous requests into defined requirements.

Qualifications

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

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

DAX

SQL

Dimensional modeling

Git version control

Stakeholder collaboration

Tools

T-SQL

SQL Server

CTE/Window functions

Direct Lake

Lakehouse

OneLake

Job description

Amtex Enterprises Inc. in Walnut Creek, CA, seeks an Analytics Engineer specializing in Microsoft Fabric and Power BI to own semantic models, measures, and reporting across the analytics stack.

This is a code-first, production-focused role with emphasis on data transformation, security, and stakeholder collaboration. You will transform data with SQL/dbt-style modeling, implement security, and work with stakeholders to turn ambiguous requests into defined requirements.