Reporting Engineer

Reporting Engineer - Hybrid Opportunity

This is a hybrid position based at our corporate office in Brentwood, TN, with on-site work required Monday through Wednesday.

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

1) Modeling & Report Engineering

• Design and implement Power BI semantic models (Import, Direct Lake, Direct Query, 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

2) 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

3) 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

4) 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)

5) Release Engineering & Observability

• Implement CI/CD practices for Power BI, including Git-enabled work spaces, 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

6) 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 Dev Ops practices, including Git, deployment pipelines, code review, artifact promotion, and testable analytics patterns

Preferred Qualifications

• Experience with Microsoft Fabric, including Direct Lake, One Lake shortcuts, and semantic model governance
• Power BI tenant and capacity administration with an emphasis on performance and cost management at enterprise scale
• Familiarity with…