Reporting Engineer

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

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.

• 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

• 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

• 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

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

• 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

• 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

• 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,…