Hiring: BI Technical Lead/Architect Company: Joint Commission Location: Oakbrook Terrace, IL Job Posted Time: 2026-09-03 11:18:34 Target Skills & Keywords : Azure, Data Lake, Data Pipeline, Data Warehouse, ETL, Git, HIPAA, Root Cause Analysis, SQL, SQL Server About the job 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. Required Skills: •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. Qualifications: •Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent professional experience. •Expert level Microsoft SQL Server T SQL, including complex queries, stored procedures, and performance optimization. •Applied hands-on capability in Microsoft Fabric (Lakehouse, Warehouse, Direct Lake, OneLake) and judgment on when to apply Import, Direct Query, or Direct Lake modes. •Excellent written and verbal communication, with the ability to produce technical and business documentation others can act on independently. Interested candidates, please apply directly through the job posting on company's career page or try via AI auto apply on this platform. Don't miss this opportunity to join a forward-thinking team!