Senior BI Architect — Lakehouse & Power BI

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

Benefits offered by this job

Comprehensive benefits

Education support

Time away from work

Job summary

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

You will provide technical leadership across enterprise analytical solutions, ensuring architectural consistency, security, and long-term maintainability while modernizing reporting solutions and validating analytic metrics.

Qualifications

• Bachelor degree required and 8+ years BI/analytic data architecture experience.
• Experience designing enterprise Power BI semantic models including dimensional structures, reusable measures, security, and performance.
• Experience with source control, CI/CD, and automated deployment in enterprise BI environments.
• Advanced SQL skills and data modeling expertise.

Responsibilities

• Own architectural design and technical standards for HR analytical data models across the lakehouse gold layer and enterprise Power BI semantic models.
• Establish architectural patterns for distributing business logic, calculations, aggregations, and security controls.
• Establish and enforce dimensional modeling, relationship design, and reusable metric standards.
• Demonstrate advanced analytical problem-solving to resolve data discrepancies and performance issues.
• Lead reviews to identify architectural weaknesses and standardization opportunities.
• Guide optimization of gold-layer structures, semantic models, and DAX calculations.

Skills

Power BI semantic models

Dimensional modeling

SQL

CI/CD pipelines

Data governance

Education

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

Tools

Git

Azure DevOps

GitHub Actions

PBIP

Tabular Model Definition Language

Job description

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

You will provide technical leadership across enterprise analytical solutions, ensuring architectural consistency, security, and long-term maintainability while modernizing reporting solutions and validating analytic metrics.