BI Technical Lead/Architect

Joint Commission; Kentucky; On-site; USD 121,000 - 161,000; Full time

Job summary

Joint Commission is seeking a hands-on BI Architect to design, build, and govern core BI solutions while upholding architectural integrity across the enterprise BI environment. You own the end-to-end BI architecture, develop and maintain the multi-year platform roadmap, and mentor two offshore consultants while partnering with Data Engineering and Data Architecture.

In addition to shaping solution design, you will drive modeling standards, governance patterns, and complex implementations,

Qualifications

• Bachelor's degree or equivalent professional experience.
• 8+ years building relational dimensional data models using Kimball methodology.
• 5+ years Power BI development including semantic modeling and DAX optimization.
• 5+ years with Power BI Datasets and SSAS Tabular including RLS/OiL.
• 5+ years with Enterprise Data Warehouse and ETL.
• Expert level T-SQL in SQL Server.
• Experience with Microsoft Fabric and data lake to Synapse pipelines.
• Experience with deployment pipelines, Git, and workspace lifecycle management.

Responsibilities

• Develop and maintain the multi-year BI platform roadmap and governance.
• Translate requirements into physical data environments for EDW with Kimball modeling.
• Lead design of Tabular semantic models in Power BI Premium and Fabric with DAX optimization.
• Enforce BI development standards and governance across models, naming, DAX, reports, and performance.
• Manage Power BI and Fabric capacities, gateways, and performance across environments.
• Ensure platform compliance and audit readiness with HIPAA and security standards.
• Author deployment plans with rollback, validation, dependency mapping, and gates; drive postmortems.
• Enable self-service analytics and data literacy with reusable assets and standards.
• Direct two offshore consultants, assign work, review code/design, ensure standards.
• Collaborate with stakeholders to gather requirements and build business cases.

Skills

Kimball dimensional modeling

Power BI development

DAX optimization

SQL performance tuning

Leadership and mentoring

ETL design and workloads

Data governance and standards

Azure data pipelines

Fabric/Lakehouse concepts

Communication

Education

Bachelor's degree in Computer Science/Information Systems or related

Tools

Power BI Desktop

Tabular Editor

DAX Studio

Azure Synapse

SSAS Tabular

Git

Microsoft Fabric

Job description

This is a hands-on architectural role, responsible for designing, building, and governing core BI solutions while ensuring architectural integrity across the enterprise BI environment. The role owns the end-to-end BI architecture, develops and maintains the multi-year BI platform roadmap, partners closely with Data Engineering and Data Architecture, and serves as the lead technical mentor for BI Developers and Analysts. In addition to strategic responsibilities, the architect actively contributes to solution design, modeling standards, governance patterns, and complex implementations, and provides day to day technical direction for two offshore development consultants.

Responsibilities

• Develop and maintain the multi-year BI platform roadmap, including tool evaluation, platform evolution, and alignment with enterprise data strategy.
• Translate business requirements into physical data environments that support the Enterprise Data Warehouse, including fact and dimension design using Kimball methodology.
• Lead the design of Tabular semantic models in Power BI Premium and Microsoft Fabric, including DAX, Row Level Security, and performance optimization.
• Define and enforce BI development standards and governance across data models, naming conventions, DAX patterns, report design, and performance thresholds.
• Manage Power BI and Fabric capacities, including resource allocation, on premises gateway administration, and performance monitoring across Dev, Test, and Production environments.
• Own platform compliance and audit readiness, including regular review of Power BI Activity Logs, usage metrics, and user behavior against HIPAA and enterprise security standards.
• Author deployment plans with rollback procedures, validation criteria, dependency mapping, and approval gates. Lead postmortems and drive root cause analysis to closure.
• Enable self-service analytics and foster a culture of data literacy across the organization through documented standards, reusable assets, and stakeholder enablement.
• Direct the technical work of two offshore consultants, including assigning work, reviewing code and designs, and ensuring deliverables meet platform standards.
• Partner with business stakeholders to gather requirements, estimate effort, build business cases for platform investments, and communicate tradeoffs in terms non-technical audiences can act on.

Requirements

• Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent professional experience.
• 8+ years building relational dimensional data models using Kimball methodology.
• 5+ years of hands-on Power BI development, including semantic model design, advanced DAX, and performance tuning with DAX Studio or Tabular Editor.
• 5+ years with Power BI Datasets and SSAS Tabular, including Row Level Security and Object Level Security.
• 5+ years working with an Enterprise Data Warehouse and writing ETL.
• Expert level Microsoft SQL Server T SQL, including complex queries, stored procedures, and performance optimization.
• Hands on experience with Microsoft Fabric (Lakehouse, Warehouse, Direct Lake, OneLake) and judgment on when to apply Import, Direct Query, or Direct Lake modes.
• Experience with Power BI deployment pipelines, Git source control, and workspace lifecycle management across Dev, Test, and Production.
• Experience with Azure data pipelines moving data from Data Lake to Synapse. SSIS experience for data extraction.
• Excellent written and verbal communication, with the ability to produce technical and business documentation others can act on independently.

Competencies

• Collaborating - Working cooperatively with others to help a team or work group achieve its goals. Communication - Conveying information and ideas clearly and concisely to individuals or groups in an engaging manner that helps them understand and retain the message; listening actively to others.
• Customer Focus - Ensuring that the customer perspective is a driving force behind business decisions and activities; crafting and implementing service practices that meet customers' and own organization’s needs.
• Earning Trust - Gaining others’ confidence by acting with integrity and following through on commitments while disclosing own positions; treating others and their ideas with respect and supporting them in the face of challenges.
• Initiating Action - Taking prompt action to accomplish work goals; taking action to achieve results beyond what is required; being proactive.
• Quality Orientation - Accomplishing tasks by considering all areas involved, no matter how detailed; showing concern for all aspects of the job; accurately checking processes and tasks; being watchful over a period of time.
• Technical / Professional Knowledge & Skills - Having achieved a satisfactory level of technical and professional skill or knowledge in position-related areas; keeping up with current developments and trends in areas of expertise.
• Work Standards - Setting high standards of performance for self and others; assuming responsibility and accountability for successfully completing assignments or tasks; self-imposing standards of excellence rather than having standards imposed.

This job description is intended to describe the general nature and level of work performed by an employee assigned to this position. The description is not an exhaustive list of all duties, responsibilities, knowledge, skills, and abilities, and working conditions associated with this position. All requirements are subject to possible modification and reasonably accommodate individuals with disabilities.

Joint Commission offers a comprehensive benefits package. For an overview of our benefits package, please visit our Joint Commission Career Page

This job description is intended to describe the general nature and level of work performed by an employee assigned to this position. The description is not an exhaustive list of all duties, responsibilities, knowledge, skills and abilities, and working conditions associated with this position. All requirements are subject to possible modification due to business needs and/or reasonable accommodations for individuals with disabilities.

MIN

$121,000.00

MAX

$161,000.00

We are an Equal Opportunity Employer. All qualified applicants will receive consideration without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or any other status protected by law.