Role: Power BI Developer
Location: 100% Remote
Core Responsibilities
Enterprise BI Architecture
• Architect enterprise semantic models using:
o Power BI Premium / Fabric Capacity
o Composite models
o DirectQuery, Import, Hybrid models
• Design star schemas and dimensional data models.
• Implement enterprise dataset governance and certified datasets.
• Define tenant-wide governance (workspace strategy, access controls).
Data Platform & Integration
• Design integration with:
o Dataverse
o Azure SQL
o Azure Databricks
o Microsoft Fabric
• Build and optimize ETL pipelines using Dataflows.
• Implement data partitioning, incremental refresh, and performance optimization.
Advanced Analytics & Modeling
• Develop advanced DAX calculations
• Implement row-level security (RLS) and object-level security (OLS).
• Conduct performance tuning using:
o DAX Studio
o Performance Analyzer
o Tabular Editor
• Develop calculation groups and advanced semantic layer enhancements.
Security & Compliance
• Design secure data access models using:
o Service accounts
o Service principals
o Managed identities
• Implement data classification and sensitivity labels.
• Ensure compliance with financial regulatory standards.
• Establish least-privilege access patterns.
Performance Engineering
• Optimize dataset refresh performance.
• Implement query folding strategies.
• Design scalable architecture for large data volumes (multi-billion row datasets).
• Optimize memory utilization in Premium capacities.
• Conduct load testing and concurrency planning.
Collaboration & Business Alignment
• Partner with finance, M&A, capital markets teams to define KPIs and reporting standards.
• Translate business logic into robust semantic layer design.
• Mentor BI developers and establish modeling standards.
• Document architecture and operational runbooks.
Required Qualifications
• 7+ years in BI/analytics architecture.
• 5+ years of deep Power BI development experience.
• Advanced DAX expertise.
• Strong SQL proficiency and performance optimization experience.
• Experience with Azure data platform (ADF, Synapse, Databricks).
• Experience with Microsoft Fabric and Lakehouse architecture.
• Experience implementing enterprise BI governance frameworks.
• Strong understanding of data warehousing principles.
• Financial services domain experience (investment banking, M&A, capital markets preferred).
• Excellent verbal and written communication skills.
Desired Certifications
• PL-300: Power BI Data Analyst
• Fabric Analytics Engineer Associate
• Fabric Data Engineer Associate
• Azure Data Engineer Associate (DP-203)