> Markdown version of [/jobs/ext/4518162-consulting-bi-architect](https://www.wearedevelopers.com/jobs/ext/4518162-consulting-bi-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Consulting BI Architect - **Company:** HCA Healthcare Inc. - **Location:** Nashville, TN, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Query Performance, Data Analysis, Business Logic, Architectural Patterns, Automation of Tests, Microsoft Azure, Business Intelligence Development, BigQuery, Cloud Computing, Cyber Security, Information Systems, Continuous Integration, Data Architecture, Information Engineering, Data Security, Data Structures, Data Warehousing, Dimensional Modeling, Github, Industry Standard Architecture, Performance Tuning, Release Management, Power BI, SQL Databases, Enterprise Data Management, Google Cloud, Sql Optimization, Git, Microsoft Fabric, Information Technology, Deployment Automation, Data Analytics, Data Management, Software Version Control - **Published:** November 1, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=90be772ba6aa8622 ## About the Role * 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 ## Description 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.