Enterprise BI Architect: Power BI Gold Layer Leader

HCA Healthcare, Inc.; Nashville (TN); On-site; USD 150,000 - 190,000; Full time

Benefits offered by this job

Comprehensive benefits

401(k) match and retirement resources

Education support and tuition

Job summary

HCA Healthcare, Inc. is seeking a Consulting BI Architect to lead architecture, design, and governance of enterprise HR analytical data models, including the Lakehouse gold layer and Power BI semantic models.

You will ensure scalable, secure data structures and govern metrics across reporting platforms. You will partner with data architecture, engineering, BI, and analytics teams to set standards, review designs, resolve complex modeling issues, and drive long-term maintainability of analytical

Qualifications

• 8+ years of experience in business intelligence, analytical data architecture, data modeling, or related technical disciplines required.
• Significant hands-on experience designing and supporting complex, production-scale relational and dimensional data models required.
• Demonstrated experience designing and architecting complex enterprise Power BI semantic models, including dimensional structures, advanced DAX, reusable measures, security, and performance optimization required.
• Demonstrated ownership of enterprise analytical architecture, including significant data-model design decisions, technical tradeoffs, performance optimization, and ongoing production support required.
• Experience architecting Power BI semantic models over cloud-based analytical data platforms, including evaluating connectivity approaches, data refresh strategies, query performance, and source-system dependencies required.
• Advanced SQL skills, including query development, optimization, and investigation of complex data structures required.
• Demonstrated experience with source control, CI/CD, and automated deployment practices in enterprise BI or analytical data environments, including technical review, release management, and production change control required.
• Experience diagnosing and resolving analytical performance problems involving data models, queries, and semantic-layer calculations required.
• Experience establishing technical standards, reviewing architectural designs, and guiding other experienced technical professionals required.
• Experience working with enterprise data platforms and collaborating across data engineering, analytics, and business teams required.
• Experience with Git, Azure DevOps, GitHub Actions, Power BI Project (PBIP), Tabular Model Definition Language (TMDL) and tools preferred

Responsibilities

• Translate complex analytical requirements into logical and dimensional data-model designs, technical specifications, and implementation guidance.
• Provide hands-on analytical modeling leadership during the modernization and migration of enterprise reporting solutions to governed gold-layer data products, including assessment of legacy data structures, translation of existing business logic, metric reconciliation, and validation of analytical consistency throughout the transition.
• Partner with enterprise data architecture and engineering teams to ensure gold-layer implementations align with approved analytical architecture.
• Design and govern enterprise Power BI semantic models supporting shared business definitions, reusable measures, and consistent reporting.
• Provide technical guidance on model relationships, calculation logic, data granularity, aggregation strategies, and performance optimization.
• Evaluate architectural tradeoffs and recommend solutions balancing performance, maintainability, security, and analytical flexibility.
• Partner with engineering and BI development teams to implement and improve CI/CD pipelines, source-controlled development workflows, and repeatable deployment processes for enterprise analytical solutions.

Education

Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related field

Job description

HCA Healthcare, Inc. is seeking a Consulting BI Architect to lead architecture, design, and governance of enterprise HR analytical data models, including the Lakehouse gold layer and Power BI semantic models.

You will ensure scalable, secure data structures and govern metrics across reporting platforms. You will partner with data architecture, engineering, BI, and analytics teams to set standards, review designs, resolve complex modeling issues, and drive long-term maintainability of analytical