Senior Power BI Developer

Job Description 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, OneLake). Exposure to DAX Studio / Tabular Editor / VertiPaq Analyzer . Familiarity with Jira/Agile delivery processes.