Reporting Engineer - Hybrid / Remote

Role Summary

This role is responsible for designing, delivering, and operating secure, compliant, and high-performing healthcare reporting solutions at enterprise scale. The Reporting Engineer develops and optimizes Power BI semantic models, authors production-quality DAX, enforces robust security controls, and implements disciplined CI/CD practices for analytics delivery. The role partners closely with data engineering to integrate curated datasets (claims, EHR, FHIR) into a governed semantic layer that supports clinical, operational, and financial decision-making.

Key Responsibilities

• Modeling & Report Engineering

• Design and implement Power BI semantic models (Import, Direct Lake, DirectQuery, and Composite) aligned with star schema and dimensional modeling best practices
• Author robust DAX, including calculated columns, measures, and calculation groups, with careful management of filter context, row context, and time intelligence (e.g., role-playing dates)
• Build enterprise-grade dashboards and reports in Power BI Service with emphasis on usability, accessibility, and consistent KPI definitions
• Implement incremental refresh, aggregations, and hybrid tables to support large-scale datasets

• Performance & Scale

• Optimize models through tuning of cardinality, relationships, encoding, partitioning, and aggregation strategies to meet report performance SLAs
• Design solutions that scale across Power BI capacities (Fabric/F capacities, autoscale, and load management) using usage-driven optimization

• Governance, Security & Compliance

• Implement and manage Row-Level Security (RLS) and Object-Level Security (OLS) aligned with least-privilege access and separation of duties
• Enforce HIPAA-compliant handling of PHI, including masking, minimization, and retention controls across development, test, and production environments
• Integrate with Microsoft Purview for lineage, glossary, and classification; document and certify datasets and metrics
• Define and operationalize KPIs and metric definitions within the semantic layer to ensure consistency across reporting products

• Data Sources & Platform Integration

• Partner with data engineering to source data from Azure Fabric and Lakehouse platforms, Azure Synapse, Azure SQL, Databricks/Delta Lake, Snowflake, and on-premises SQL via On-Premises Data Gateway
• Build parameterized Power BI Dataflows and Dataflows Gen2 (where applicable) to support reusable transformations aligned with medallion (bronze/silver/gold) datasets
• Support integration of healthcare data standards including FHIR R4, HL7 v2, and X12 (837/835) into the semantic model for payer and provider analytics use cases (e.g., denials, length of stay, readmissions, quality measures)

• Release Engineering & Observability

• Implement CI/CD practices for Power BI, including Git-enabled workspaces, deployment pipelines, pull request-based reviews, Tabular Editor scripting, and automated best practice analysis (BPA)
• Monitor refresh SLAs, gateway health, query performance, capacity utilization, and usage analytics; drive proactive performance tuning and cost governance
• Establish standards for versioning, certification, and deprecation of datasets and reports; maintain clear and durable documentation

• Stakeholder Enablement

• Translate clinical, operational, and financial metrics into well-defined technical measures in collaboration with subject matter experts (Finance, Quality, Care Management, Revenue Cycle)
• Develop reusable report templates, themes, and field parameter patterns to accelerate governed self-service analytics
• Provide enablement and guidance to analysts on DAX patterns, semantic modeling techniques, and performance anti-patterns

Required Qualifications

• 3–6 years of experience in BI or reporting engineering, with at least 3 years focused on Power BI at scale
• Advanced proficiency in: DAX, Power Query (M), Power BI Desktop and Service, Tabular Editor and DAX Studio, dimensional modeling patterns, including star schema, role-playing dimensions, calculation groups, and aggregations, Power BI security, including RLS/OLS, workspace and app permissions, tenant settings, and data classification
• Demonstrated experience delivering reporting solutions on healthcare data such as EHR encounters, claims, authorizations, registries, and quality measures
• Strong SQL skills and experience with one or more data platforms: Microsoft Fabric, Azure Synapse, Azure SQL, Databricks/Delta Lake, or Snowflake
• Solid understanding of BI DevOps practices, including Git, deployment pipelines, code review, artifact promotion, and testable analytics patterns

Preferred Qualifications

• Experience with Microsoft Fabric, including Direct Lake, OneLake shortcuts, and semantic model governance
• Power BI tenant and capacity administration with an emphasis on performance and cost management at enterprise scale
• Familiarity with Microsoft Purview lineage, glossary, and sensitivity labeling
• Exposure to additional BI or semantic-layer tools (e.g., Tableau, Looker, Sigma, dbt metrics)
• Relevant certifications, such as PL-300, DP-500, DP-203, or platform-specific certifications (Databricks, Snowflake)
• Knowledge of healthcare data frameworks and programs, including FHIR R4, HL7 v2, X12, HEDIS, STARS, and HIPAA Security and Privacy Rule fundamentals

Benefits

• Comprehensive health, dental, and vision insurance
• Health Savings Account with an employer contribution
• Life Insurance
• PTO
• 401(k) retirement plan with a company match

ENVIRONMENTAL/WORKING CONDITIONS

Normal busy office environment with much telephone work. Possible long hours as needed.