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.
Skills Required
- 6+ years of hands-on experience with Power BI Desktop, Power BI Service, and Premium or Fabric capacities
- Strong proficiency with DAX and Power Query M, including complex measures, time intelligence, and native query optimization
- Deep understanding of semantic model design, including star schemas, relationships, cardinality, VertiPaq, and performance tuning
- Experience with incremental refresh, large fact table management, and memory or capacity troubleshooting in Premium or Fabric environments
- Working knowledge of Snowflake, including SQL, views, and warehouses
- Experience with Git-based Power BI development using PBIP and TMDL, branching strategies, and pull request workflows
- Familiarity with PowerShell and Power BI REST APIs for refresh automation and administration
- Strong analytical and debugging skills tracing issues from report visuals through DAX and relationships to source data
- Excellent communication skills
- Experience with Microsoft Fabric, including Lakehouse, Fabric Capacity Metrics, or OneLake
- Exposure to DAX Studio, Tabular Editor, or VertiPaq Analyzer
- Familiarity with Jira and Agile delivery processes
What We Do
KANINI is a digital transformation enabler, providing cutting-edge software services and solutions that help enterprises drive innovation and business growth. We create impeccable customer experiences through thoughtfully designed digital solutions that help improve our customer’s efficiency, scale, and revenues. We specialize in Product Engineering, Data Analytics & AI, and ServiceNow consultation and implementation. We focus on empowering Banking & Financial Services, Healthcare, Manufacturing, and a few other industries to leverage new-age technologies and solutions by implementing agile development practices and a global delivery framework. We build technology that puts humans first - in line with our core operating principle that technology is for people, not the other way around. The result is happier clients, partners, and employees. We do all this by balancing our customers’ needs with our people’s aspirations, always putting humans first. It means: * We prioritize each individual’s personal goals. * We value relationships more than profits. * We treat our clients as partners. Our people come to work because it makes them happy. They smile more often. They love getting better at what they do. And our offices become a second home. Even as they spend more time away from it. If you think all this is just as important to you, bring us your Energy, Intellect and Integrity. We’ll show you a happier way to work
