Consulting Business Intelligence Architect

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

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 benefits for medical, prescription drug, dental, vision, behavioral health and telemedicine services

• Wellbeing support, including free counseling and referral services

• Time away from work programs 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 support through tuition assistance, student loan assistance, certification support, dependent scholarships and a partnership with Galen College of Nursing

• Additional benefits for 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 (https://careers.hcahealthcare.com/pages/employee-benefits-and-rewards)

Note: Eligibility for benefits may vary by location.

Human Resources Group empowers our people to grow