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.
- Solid 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.

📌 Senior Power BI Developer (India)
🏢 Ravh-IT
📍 India