Develop and optimize enterprise Power BI semantic models and reports using Microsoft Fabric and Snowflake. Responsibilities include DAX and Power Query development, incremental refresh, large-scale data modeling, performance and capacity troubleshooting, RLS administration, Git-based deployments, refresh automation with PowerShell and REST APIs, and source-to-model reconciliation. The role partners with data engineering and business stakeholders to deliver scalable reporting solutions and document root-cause findings.
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.
Similar Jobs
Insurance • Consulting
Develop enterprise Power BI solutions from discovery through adoption. Responsibilities include semantic modeling, advanced DAX and Power Query development, dashboard UX/UI design, governance, performance optimization, stakeholder workshops, client presentations, usability testing, adoption tracking, proposal support, and mentoring junior team members.
Top Skills:
AlteryxAzure DevopsAzure SynapseDatabricksDataikuDaxDax StudioGitJSONPower AppsPower AutomatePower BIPower Bi EmbeddedPower Bi ServicePower Query (M)SnowflakeSQLSQL ServerTabular Editor
Big Data • Information Technology • Software • Analytics • Energy
Leads strategic business development and enterprise software sales for electric utility and AEC customers. Develops account strategies, identifies and closes opportunities, builds executive relationships, manages complex negotiations, forms strategic partnerships, and collaborates with marketing, product, and customer success teams. The role focuses on substation design, utility planning, AI-enabled engineering workflows, digital twins, and infrastructure modernization, with 30–50% travel across North America.
Top Skills:
Artificial IntelligenceDigital TwinEnterprise SoftwareGisSalesforce CRM
.png)
Artificial Intelligence • Cloud • Payments • Software • Business Intelligence • Generative AI • Automation
Define and govern enterprise-scale data architecture across batch, streaming, warehouse, lakehouse, transactional, and AI use cases. Establish standards for data quality, lineage, access, cataloging, governance, observability, and SLAs. Architect AI-enabled workflows, resolve complex architecture issues, influence roadmaps, and mentor engineers through hands-on technical leadership. The role requires 15+ years of software, data engineering, or architecture experience and expertise in large-scale data platforms and modeling.
Top Skills:
AIBatch ProcessingBigQueryData CatalogsData WarehousesDbtFeature StoresGCPLakehousesOlapOltpStreaming ArchitecturesVector Stores
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
