Senior Power BI Developer

Kanini Software Solutions; Nashville, Northern (TN, KY); Hybrid; USD 120,000 - 160,000; Full time

Job summary

Kanini Software Solutions, Inc. seeks a Power BI Senior Developer to join the BI/Data Analytics team in Nashville. You will design semantic models on Microsoft Fabric/Snowflake, optimize DAX, and implement incremental refresh for large datasets.

Work involves collaborating with data engineering on Snowflake/dbt pipelines and managing deployments across DEV/PROD workspaces using Git-based workflows. Strong query tuning and REST API scripting are expected.

Qualifications

• 6+ years hands-on Power BI experience (Desktop, Service, Premium/Fabric).
• Strong proficiency in DAX and Power Query (M).
• Deep understanding of semantic model design: star schema, relationships, VertiPaq storage, tuning.
• Experience with incremental refresh, large fact tables, memory/capacity troubleshooting in Premium/Fabric.
• Working knowledge of Snowflake (SQL, views, warehouses) and ideally dbt for source transformations.
• Experience with Git-based Power BI development (PBIP/TMDL format), branching, PRs.
• Familiarity with PowerShell and Power BI REST APIs for refresh automation.

Responsibilities

• Design, build, and maintain Power BI semantic models using TMDL/ PBIP format.
• Develop and optimize DAX measures, calculated columns, hierarchies, relationships in large datasets.
• Implement incremental refresh policies to manage large historical data efficiently.
• Diagnose refresh failures, memory/capacity issues, and performance bottlenecks.
• Collaborate with data engineering on Snowflake/dbt pipelines feeding the model.

Skills

Power BI

DAX

Power Query

Semantic model

Incremental refresh

Snowflake

dbt

Git PBIP/TMDL

PowerShell

REST APIs

Perf tuning

Tools

PBIP/TMDL

DAX Studio

VertiPaq Analyzer

Tabular Editor

Job description

JobDescription — Power BI Senior Developer

Aboutthe Role

We'relooking for an experienced Power BI Developer to join our BI/DataAnalytics team, supporting a large-scale enterprise semantic model built on MicrosoftFabric and Snowflake. You'll work on a mission-critical reportingplatform serving sales, labor, attendance, and financial reconciliation acrossthe organization, with a strong focus on performance optimization, datamodeling best practices, and scalable report development.

KeyResponsibilities

• Design, build,and maintainPower BI semantic modelsusingTMDLandPBIP(Git-integrated) project format— no reliance on manual.pbix-only workflows.
  
• Develop andoptimizeDAX measures, calculated columns, hierarchies, andrelationships across large (multi-GB, 80M+ row) fact tables.
  
• Implement andmaintainincremental refresh policies(rollingwindow/incremental partitioning) to manage large historical datasetsefficiently.
  
• Diagnose andresolverefresh failures, memory/capacity issues, and performancebottlenecks(VertiPaq Analyzer, DAX Studio, Fabric CapacityMetrics).
  
• Design andapplysurrogate key strategiesto reduce model size andimprove query/relationship performance on high-cardinality columns.
  
• Build andmaintainPower BI reportsfollowing establisheddesign/SSA standards (report chrome, slicers, drill-through, bookmarks,conditional formatting).
  
• Collaboratewithdata engineeringteams onSnowflake/dbtpipelinesfeeding the semantic model; troubleshoot source-to-model datareconciliation issues.
  
• Managedeployments acrossDEV/PROD workspacesviadeploymentpipelinesandGit-based version control(branching,PRs, code review).
  
• UsePowerShell/ REST APIs(Enhanced Refresh API, XMLA endpoint) to automaterefresh operations, monitor refresh history, and script recovery/reloadprocedures.
  
• Performrootcause analysison data discrepancies, broken relationships,blank/missing values, and reporting anomalies; document findings clearlyfor stakeholders.
  
• ManageRow-LevelSecurity (RLS), workspace/app permissions, and capacity (SKU) planningfor Fabric/Premium.
  
• Partner withbusiness stakeholders to translate requirements into scalable model andreport designs; write clear documentation and user stories (Jira/Agile).
  

RequiredSkills & Experience

• 6+ years hands-onexperience withPower BI(Desktop, Service,Premium/Fabric capacities).
  
• Strongproficiency inDAXandPower Query (M),including complex measures, time intelligence, and native queryoptimization.
  
• Deepunderstanding ofsemantic model design: star schema,relationships, cardinality, VertiPaq storage engine, and performancetuning techniques.
  
• Experiencewithincremental refresh, large fact table management,andmemory/capacity troubleshootingin Premium/Fabricenvironments.
  
• Working knowledgeofSnowflake(SQL, views, warehouses) and ideallydbtforsource data transformations.
  
• ExperiencewithGit-based Power BI development(PBIP/TMDL format),branching strategies, and pull request workflows.
  
• FamiliaritywithPowerShellandPower BI REST APIsforrefresh automation and administration.
  
• Strong analyticaland debugging skills — ability to trace issues from report visuals throughDAX/relationships back to source data.
  

Niceto Have

• ExperiencewithMicrosoft Fabric(Lakehouse, Fabric CapacityMetrics, OneLake).
  
• Exposure toDAXStudio / Tabular Editor / VertiPaq Analyzer.
  
• FamiliaritywithJira/Agiledelivery processes.
  

Kanini Software Solutions, Inc. does not discriminate in employment matters on the basis of race, gender, religion, age, national origin, citizenship, veteran status, family status, disability status, or any other protected class. We support workplace diversity. If you have a disability, please let us know if there is anything we can do to improve the interview process for you; we’re happy to accommodate. Kanini Software Solutions, Inc., 25 Century Blvd., Ste. 602, Nashville, TN 37214.