Reporting Engineer - Hybrid

Job DetailsDescriptionReporting Engineer - Hybrid OpportunityThis is a hybrid position based at our corporate office in Brentwood, TN, with on-site work required Monday through Wednesday.Role SummaryThis 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 EngineeringDesign and implement Power BI semantic models (Import, Direct Lake, DirectQuery, and Composite) aligned with star schema and dimensional modeling best practicesAuthor 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 definitionsImplement incremental refresh, aggregations, and hybrid tables to support large-scale datasets Performance & ScaleOptimize models through tuning of cardinality, relationships, encoding, partitioning, and aggregation strategies to meet report performance SLAsDesign solutions that scale across Power BI capacities (Fabric/F capacities, autoscale, and load management) using usage-driven optimization Governance, Security & ComplianceImplement and manage Row-Level Security (RLS) and Object-Level Security (OLS) aligned with least-privilege access and separation of dutiesEnforce HIPAA-compliant handling of PHI, including masking, minimization, and retention controls across development, test, and production environmentsIntegrate with Microsoft Purview for lineage, glossary, and classification; document and certify datasets and metricsDefine and operationalize KPIs and metric definitions within the semantic layer to ensure consistency across reporting products Data Sources & Platform IntegrationPartner 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 GatewayBuild parameterized Power BI Dataflows and Dataflows Gen2 (where applicable) to support reusable transformations aligned with medallion (bronze/silver/gold) datasetsSupport 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 & ObservabilityImplement 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 governanceEstablish standards for versioning, certification, and deprecation of datasets and reports; maintain clear and durable documentation Stakeholder EnablementTranslate 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 analyticsProvide enablement and guidance to analysts on DAX patterns, semantic modeling techniques, and performance anti-patternsRequired Qualifications3–6 years of experience in BI or reporting engineering, with at least 3 years focused on Power BI at scaleAdvanced proficiency in:DAX, Power Query (M), Power BI Desktop and ServiceTabular Editor and DAX StudioDimensional modeling patterns, including star schema, role-playing dimensions, calculation groups, and aggregationsPower BI security, including RLS/OLS, workspace and app permissions, tenant settings, and data classificationDemonstrated experience delivering reporting solutions on healthcare data such as EHR encounters, claims, authorizations, registries, and quality measuresStrong SQL skills and experience with one or more data platforms: Microsoft Fabric, Azure Synapse, Azure SQL, Databricks/Delta Lake, or SnowflakeSolid understanding of BI DevOps practices, including Git, deployment pipelines, code review, artifact promotion, and testable analytics patternsPreferred QualificationsExperience with Microsoft Fabric, including Direct Lake, OneLake shortcuts, and semantic model governancePower BI tenant and capacity administration with an emphasis on performance and cost management at enterprise scaleFamiliarity with Microsoft Purview lineage, glossary, and sensitivity labelingExposure 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 fundamentalsBenefitsComprehensive health, dental, and vision insuranceHealth Savings Account with an employer contributionLife Insurance PTO401(k) retirement plan with a company matchAnd 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 Indeed.com or LinkedIn, please know that pay bands are auto assigned and may not reflect the true pay band within the organization.No Recruiters Please