Senior Power BI Developer

Senior Power BI / Microsoft Fabric Analytics Engineer
Location: Remote – India
Employment Type: Part-Time
Shift: US Night Shift – PST Timings
Experience: 5+ Years
Work Mode: 100% Remote
Job Summary
We are seeking an experienced Senior Power BI / Microsoft Fabric Analytics Engineer to build and maintain a commercial, customer-facing analytics product for a national healthcare membership association.
This platform replaces a traditional static report with a subscription-based analytics dashboard serving staff across more than 1,300 hospitals. The successful candidate will own the Power BI semantic model, DAX measures, report estate, dynamic row-level security, statistical suppression, benchmark comparisons, accessibility, and score reconciliation.
This is a customer-facing analytics product, not traditional internal BI reporting. Accuracy, privacy, accessibility, performance, and security are product-level acceptance criteria.
Key Responsibilities
Semantic Modeling & Power BI
Own a single Microsoft Fabric Gold-layer semantic model using Direct Lake.
Design and maintain scalable Power BI semantic models and relationships.
Develop complex and reusable DAX measures using appropriate filter context, CALCULATE, variables, and aggregation logic.
Ensure published scores are calculated correctly from raw responses at every aggregation level.
Optimize semantic model performance for concurrent customer-facing usage.
Maintain documented measures, calculation logic, definitions, and business rules.
Report Development
Build and maintain approximately 40 Power BI report pages across three subscription tiers.
Develop dashboards supporting:
Unit-level results
Multi-unit comparison
Organizational rollups
Year-over-year trends
Peer-group comparisons
National rankings
Scheduled reporting
Implement tier-based functionality through configuration rather than maintaining separate reports.
Build accessible and user-friendly customer-facing visuals and exports.
Dynamic Row-Level Security
Design and implement dynamic RLS using scope tables, rather than relying on hard-coded roles.
Support multiple access levels and administrator access.
Define access based on explicit organizational, facility, and unit scope.
Develop and maintain a comprehensive RLS test matrix.
Test attempted access outside a user's authorized scope.
Troubleshoot RLS behavior across Power BI Service and embedded scenarios.
Data Suppression & Privacy
Implement statistical/small-cell suppression at the data/semantic layer.
Ensure suppression rules are consistently applied to:
On-screen reports
Exports
Scheduled reports
Re-evaluate suppression after every filter combination.
Ensure results at critical response thresholds are appropriately suppressed.
Display approved explanations when a result is withheld.
Maintain configurable suppression messaging without requiring code changes.
Benchmarking & Historical Data
Build benchmark comparisons against immutable published snapshots.
Support multiple benchmark methodologies and comparison types.
Preserve historical results according to the methodology and snapshot applicable when they were originally published.
Ensure historical results are not silently recalculated when underlying data changes.
Maintain methodology versioning and benchmark metadata.
Score Reconciliation & Data Quality
Develop reconciliation processes proving that published scores can be reproduced from raw responses.
Reconcile Power BI results against the legacy report to two decimal places.
Validate results across:
Large units
Small units near suppression thresholds
High non-response populations
Multi-unit hospitals
Identify and prevent incorrect aggregation methods, including inappropriate averaging of lower-level scores.
Investigate discrepancies and document root causes.
Accessibility
Develop Power BI reports according to WCAG 2.2 AA acceptance requirements.
Implement:
Proper tab order
Alt text
Accessible tabular equivalents
Appropriate contrast
Non-color-dependent visual communication
Accessible exports
Ensure PDF exports have appropriate reading order and alt text.
Ensure CSV and Excel exports are structured for accessibility.
Work with version-controlled Power BI themes to maintain consistent accessibility and visual standards.
Microsoft Fabric & Deployment
Work extensively with:
Microsoft Fabric Lakehouse
Fabric Warehouse
Direct Lake semantic models
Power BI Service
Fabric deployment pipelines
Understand practical differences between Direct Lake, DirectQuery, and Import.
Identify and troubleshoot Direct Lake fallback scenarios and their performance impact.
Follow Git-based development practices.
Work through Azure DevOps sprint branches and controlled Dev/Test/Production promotion.
Follow formal deployment, UAT, defect management, and production sign-off processes.
Required Qualifications
5+ years of hands-on Power BI semantic modeling experience.
Strong and demonstrable DAX expertise.
Deep understanding of:
Filter context
Row context
CALCULATE
Variables
Measures
Relationships
Advanced aggregation
Production experience implementing dynamic row-level security using scope tables.
Experience creating and executing RLS test matrices.
Hands-on experience with Microsoft Fabric, including:
Lakehouse
Warehouse
Direct Lake
Power BI semantic models
Strong understanding of Direct Lake, DirectQuery, and Import architectures and performance implications.
Experience with Git-based Power BI/Fabric development and deployment.
Experience with Azure DevOps and deployment pipelines.
Strong understanding of statistical aggregation and weighted calculations.
Ability to validate calculations against source/legacy systems.
Practical experience implementing Power BI accessibility standards.
Experience working within formal QA, UAT, acceptance criteria, and production release processes.
Strong analytical and troubleshooting skills.
Preferred / Strong Plus
Experience building embedded Power BI solutions for external customers.
Experience with Power BI App-Owns-Data embedding.
Understanding of effective identity and embedded RLS behavior.
Experience with healthcare, surveys, assessments, benchmarking, or membership analytics.
Experience with small-cell suppression, disclosure control, or privacy thresholds.
Experience working with survey/assessment scoring methodologies.
Experience reconciling analytics products against legacy reports.
Experience supporting commercial SaaS or subscription-based analytics products.
Experience working with large organizational hierarchies and multi-tenant/customer-facing analytics.

Work arrangement
Yes