Senior Power BI Architect: Scalable Models & Fast Reports

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

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.