Consulting BI Architect

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

Benefits offered by this job

Comprehensive benefits

401(k) plan with match

Tuition assistance

Employee discounts

Job summary

HCA Healthcare, Inc. is seeking a Consulting Data Architect to lead the architecture, governance, and performance of enterprise HR analytical data models.

The role focuses on lakehouse gold layer and Power BI semantic models, delivering scalable, secure analytical structures for reporting and self-service analytics. The candidate will drive architectural standards, review designs, and resolve complex modeling and performance challenges while guiding modernization of reporting solutions and

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering or related field.
• 8+ years in BI, analytical data architecture, or data modeling.
• Experience designing enterprise Power BI semantic models with dimensional structures.
• Experience with source control, CI/CD and automated deployment.
• Strong SQL skills and data-model performance optimization.

Responsibilities

• Own architectural design and technical standards for HR analytical data models across lakehouse gold layer and Power BI models.
• Define patterns for distributing logic, calculations, and security between data layer and models.
• Lead architectural reviews and guide performance optimization of gold-layer structures and queries.
• Provide hands-on leadership during modernization and migration of enterprise reporting to governed gold-layer data products.
• Mentor team members in dimensional modeling, semantic-model design, and best practices.

Skills

Relational modeling

Dimensional modeling

SQL

DAX

Security controls

Education

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

Tools

Power BI

PBIP

TMDL

Git

Azure DevOps

Job description

Do you want to join an organization that invests in you as a Consulting Data Architect? At HCA Healthcare, you come first. HCA Healthcare has committed up to $300 million in programs to support our incredible team members over the course of three years.

Job Summary and Qualifications

Job Summary

The Consulting BI Architect is responsible for the architecture, design, governance, and performance of enterprise HR analytical data models, including the Lakehouse gold layer and Power BI semantic models. This position establishes and maintains scalable, secure, and reusable analytical data structures that support consistent business definitions, governed metrics, and enterprise reporting.

The role serves as a technical authority for analytical data modeling, partnering with data architecture, engineering, business intelligence, and analytics teams to establish architectural standards, review technical designs, and resolve complex modeling and performance challenges. This position provides technical leadership across enterprise analytical solutions, ensuring architectural consistency, scalability, security, engineering discipline, controlled deployment, and long-term maintainability.

The role also provides hands-on analytical modeling leadership during the modernization and migration of enterprise reporting solutions to governed gold-layer data products. Success requires deep investigation of business metrics, validation of analytical consistency, and independent resolution of complex data and modeling issues.

What you will do:

Quality

• 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 between the analytical data layer and Power BI semantic models, balancing performance, governance, reusability, and maintainability.
• Establish and enforce dimensional modeling, relationship design, business-rule implementation, and reusable metric standards.
• Demonstrate advanced analytical problem-solving capabilities, including the ability to deconstruct complex business metrics, trace calculations to underlying source data, identify inconsistencies in business logic, and independently investigate and resolve data discrepancies across enterprise analytical environments.
• Ensure analytical data structures are scalable, maintainable, secure, and optimized for enterprise reporting and self-service analytics.
• Establish and enforce version control, automated testing, and deployment standards for analytical data models and Power BI semantic models, ensuring changes are traceable, validated, and consistently promoted across environments.
• Lead technical design reviews to identify architectural weaknesses, performance risks, inconsistencies, and opportunities for standardization.
• Establish performance expectations and guide optimization of gold-layer structures, semantic models, DAX calculations, and analytical queries.
• Define and review analytical security architecture, including row-level security, data access patterns, and appropriate handling of sensitive workforce information.
• Partner with data analysts and engineering teams to resolve architectural or performance issues identified during validation, UAT, and production operations.

Service

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

People

• Provide technical leadership and architectural guidance to data architects, BI developers, and other analytical development resources.
• Review and challenge technical designs produced by experienced developers to ensure alignment with established standards.
• Collaborate with data management, engineering, analytics, and business stakeholders to resolve cross-functional technical challenges.
• Mentor technical resources in dimensional modeling, semantic-model design, performance optimization, and architectural best practices.
• Communicate complex technical concepts and architectural decisions clearly to technical and nontechnical stakeholders.

Growth

• Advance enterprise analytical architecture through improved modeling standards, reusable data structures, and governed semantic models.
• Evaluate emerging capabilities in Google Cloud, BigQuery, Power BI, Microsoft Fabric, and related analytical technologies to improve enterprise analytical architecture, integration, performance, and scalability.
• Identify opportunities to improve model performance, development efficiency, architectural consistency, and long-term maintainability.

Professional Practice

• Exercise independent technical judgment in evaluating complex analytical data designs and architectural tradeoffs.
• Demonstrate deep expertise in relational and dimensional modeling, SQL, and enterprise semantic-model architecture.
• Apply structured problem-solving techniques to diagnose data-model defects, inefficient queries, and performance bottlenecks.
• Establish and maintain technical governance practices, including design reviews, architecture documentation, and adherence to modeling standards.
• Work effectively across multidisciplinary technical teams, providing architectural direction and maintaining accountability for technical quality.
• Balance immediate delivery needs with long-term architectural sustainability, security, and performance.

What qualifications you will need:

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related field, or an equivalent combination of education and relevant experience. Required
• 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 infrastructure or deployment automation tools supporting governed analytical development preferred.

Certifications

• Google Cloud Professional Data Engineer or Professional Cloud Architect certification.
• Microsoft Certified: Power BI Data Analyst Associate (PL-300) preferred
• Microsoft Certified: Fabric Analytics Engineer Associate (DP-600) preferred
• Relevant training or certifications in BigQuery, cloud data architecture, or enterprise data modeling preferred

Benefits

HCA Healthcare, offers a total rewards package that supports the health, life, career and retirement of our colleagues. The available plans and programs include:

• Comprehensive benefitsfor medical, prescription drug, dental, vision, behavioral health and telemedicine services
• Wellbeing support,including free counseling and referral services
• Time away from workprograms for paid time off, paid family leave, long- and short-term disability coverage and leaves of absence
• Savings and retirement resources, including a 401(k) Plan with a 100% match on 3% to 9% of pay (based on years of service), Employee Stock Purchase Plan, flexible spending accounts, preferred banking partnerships, retirement readiness tools, rollover support and financial wellbeing counseling
• Education supportthrough tuition assistance, student loan assistance, certification support, dependent scholarships and a partnership with Galen College of Nursing
• Additional benefitsfor fertility and family building, adoption assistance, life insurance, supplemental health protection plans, auto and home insurance, legal counseling, identity theft protection and consumer discounts

Learn more about Employee Benefits

Note: Eligibility for benefits may vary by location.

Human Resources Group empowers our people to grow and give purpose to the HCA Healthcare culture. We deliver our Human Resource model in three sectors: HR Business Partners, HR Shared Operations and HR Centers of Excellence. HR Business Partner teams are critical to the success of our HR delivery model. We drive performance to achieve successful results to better care for our patients, communities and each other.

HCA Healthcare has been recognized as one of the World's Most Ethical Companies® by the Ethisphere Institute more than ten times. In recent years, HCA Healthcare spent an estimated $3.7 billion in cost for the delivery of charitable care, uninsured discounts, and other uncompensated expenses.

"Good people beget good people."- Dr. Thomas Frist, Sr.
HCA Healthcare Co-Founder

We are a family 270,000 dedicated professionals! Our Talent Acquisition team is reviewing applications for our Consulting Data Architect opening. Qualified candidates will be contacted for interviews.

We are an equal opportunity employer. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.