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.