Senior Power BI Developer

This is a remote position.

Job Description — Power BI Senior Developer

About the Role

We're looking for an experienced

Power BI Developer

to join our BI/Data Analytics team, supporting a large-scale enterprise semantic model built on

Microsoft Fabric

and

Snowflake

. You'll work on a mission-critical reporting platform serving sales, labor, attendance, and financial reconciliation across the organization, with a strong focus on performance optimization, data modeling best practices, and scalable report development.

Key Responsibilities

- Design, build, and maintain

Power BI semantic models

using

TMDL

and

PBIP (Git-integrated) project format

— no reliance on manual .pbix-only workflows.

- Develop and optimize

DAX measures

, calculated columns, hierarchies, and relationships across large (multi-GB, 80M+ row) fact tables.

- Implement and maintain

incremental refresh policies

(rolling window/incremental partitioning) to manage large historical datasets efficiently.

- Diagnose and resolve

refresh failures, memory/capacity issues, and performance bottlenecks

(VertiPaq Analyzer, DAX Studio, Fabric Capacity Metrics).

- Design and apply

surrogate key strategies

to reduce model size and improve query/relationship performance on high-cardinality columns.

- Build and maintain

Power BI reports

following established design/SSA standards (report chrome, slicers, drill-through, bookmarks, conditional formatting).

- Collaborate with

data engineering

teams on

Snowflake/dbt

pipelines feeding the semantic model; troubleshoot source-to-model data reconciliation issues.

- Manage deployments across

DEV/PROD workspaces

via

deployment pipelines

and

Git-based version control

(branching, PRs, code review).

- Use

PowerShell / REST APIs

(Enhanced Refresh API, XMLA endpoint) to automate refresh operations, monitor refresh history, and script recovery/reload procedures.

- Perform

root cause analysis

on data discrepancies, broken relationships, blank/missing values, and reporting anomalies; document findings clearly for stakeholders.

- Manage

Row-Level Security (RLS)

, workspace/app permissions, and capacity (SKU) planning for Fabric/Premium.

- Partner with business stakeholders to translate requirements into scalable model and report designs; write clear documentation and user stories (Jira/Agile).

Required Skills & Experience

-

6+ years

hands-on experience with

Power BI

(Desktop, Service, Premium/Fabric capacities).

- Strong proficiency in

DAX

and

Power Query (M)

, including complex measures, time intelligence, and native query optimization.

- Deep understanding of

semantic model design

: star schema, relationships, cardinality, VertiPaq storage engine, and performance tuning techniques.

- Experience with

incremental refresh

, large fact table management, and

memory/capacity troubleshooting

in Premium/Fabric environments.

- Working knowledge of

Snowflake

(SQL, views, warehouses) and ideally

dbt

for source data transformations.

- Experience with

Git-based Power BI development

(PBIP/TMDL format), branching strategies, and pull request workflows.

- Familiarity with

PowerShell

and

Power BI REST APIs

for refresh automation and administration.

- Strong analytical and debugging skills — ability to trace issues from report visuals through DAX/relationships back to source data.

- Excellent communication

Nice to Have

- Experience with

Microsoft Fabric

(Lakehouse, Fabric Capacity Metrics,).

- Exposure to

DAX Studio / Tabular Editor / VertiPaq Analyzer

.

- Familiarity with

Jira/Agile** delivery processes.

• Experience with

 

Microsoft Fabric

 (Lakehouse, Fabric Capacity Metrics,).

• Exposure to

 

DAX Studio / Tabular Editor / VertiPaq Analyzer

.

• Familiarity with

 

Jira/Agile

 delivery processes.