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

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

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

• 36 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
• And more!

ENVIRONMENTAL/WORKING CONDITIONS: Normal busy office environment with much telephone work. Possible long hours as needed. The description is intended to provide only basic guidelines for meeting job requirements. Responsibilities knowledge skills abilities and working conditions may change as needs evolve.

*If you are viewing this role on a job board such as or LinkedIn please know that pay bands are auto assigned and may not reflect the true pay band within the organization.

*No Recruiters Please

Required Experience:

IC