Consulting BI Architect

HCA Healthcare•Nashville, TN

About The Position

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. The role establishes and maintains scalable, secure, and reusable analytical data structures that support consistent business definitions, governed metrics, and enterprise reporting. It serves as a technical authority for analytical data modeling, partnering with data architecture, engineering, business intelligence, and analytics teams to set architectural standards, review designs, and resolve complex modeling and performance challenges. The position provides technical leadership across enterprise analytical solutions, promoting architectural consistency, scalability, security, engineering discipline, controlled deployment, and long-term maintainability. It also provides hands-on modeling leadership during modernization and migration of enterprise reporting to governed gold-layer data products, including investigation of business metrics, validation of analytical consistency, and resolution of complex data and modeling issues.

Requirements

Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related field, or an equivalent combination of education and relevant experience.
8+ years of experience in business intelligence, analytical data architecture, data modeling, or related technical disciplines.
Significant hands-on experience designing and supporting complex, production-scale relational and dimensional data models.
Experience designing and architecting complex enterprise Power BI semantic models, including dimensional structures, advanced DAX, reusable measures, security, and performance optimization.
Experience owning enterprise analytical architecture, including significant data-model design decisions, technical tradeoffs, performance optimization, and ongoing production support.
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.
Advanced SQL skills, including query development, optimization, and investigation of complex data structures.
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.
Experience diagnosing and resolving analytical performance problems involving data models, queries, and semantic-layer calculations.
Experience establishing technical standards, reviewing architectural designs, and guiding other experienced technical professionals.
Experience working with enterprise data platforms and collaborating across data engineering, analytics, and business teams.
Deep expertise in relational and dimensional modeling, SQL, and enterprise semantic-model architecture.

Nice To Haves

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

Responsibilities

Own architectural design and technical standards for HR analytical data models across the lakehouse gold layer and enterprise Power BI semantic models.
Establish patterns for distributing business logic, calculations, aggregations, and security controls between the analytical data layer and Power BI semantic models.
Establish and enforce dimensional modeling, relationship design, business-rule implementation, and reusable metric standards.
Investigate complex business metrics, trace calculations to source data, identify inconsistencies in business logic, 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 and Power BI semantic models.
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 handling of sensitive workforce information.
Partner with data analysts and engineering teams to resolve architectural or performance issues found during validation, UAT, and production operations.
Translate analytical requirements into logical and dimensional model designs, technical specifications, and implementation guidance.
Lead analytical modeling during reporting modernization and migration, including assessment of legacy structures, translation of business logic, metric reconciliation, and analytical consistency validation.
Partner with enterprise data architecture and engineering teams to align gold-layer implementations with approved 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 improve CI/CD pipelines, source-controlled workflows, and repeatable deployment processes.
Provide technical leadership and architectural guidance to data architects, BI developers, and other analytical development resources.
Review and challenge technical designs 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 technical concepts and architectural decisions clearly to technical and nontechnical stakeholders.
Evaluate emerging Google Cloud, BigQuery, Power BI, Microsoft Fabric, and related capabilities to improve enterprise analytical architecture, integration, performance, and scalability.
Identify opportunities to improve model performance, development efficiency, architectural consistency, and maintainability.
Exercise independent technical judgment in evaluating analytical data designs and architectural tradeoffs.
Apply structured problem-solving 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.
Balance immediate delivery needs with long-term architectural sustainability, security, and performance.

Benefits

Comprehensive medical, prescription drug, dental, vision, behavioral health, and telemedicine plans.
Wellbeing support, including free counseling and referral services.
Paid time off, paid family leave, long- and short-term disability coverage, and leaves of absence.
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.
Tuition assistance, student loan assistance, certification support, dependent scholarships, and a partnership with Galen College of Nursing.
Fertility and family-building benefits and adoption assistance.
Life insurance and supplemental health protection plans.
Auto and home insurance, legal counseling, identity theft protection, and consumer discounts.