Reporting Engineer - Hybrid​/Remote

Reporting Engineer - Hybrid / Remote Opportunity

* Hybrid for candidates in Nashville and surrounding areas.

* Remote option available for candidates outside of surrounding areas.

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…