Senior BI Architect: Ambulatory Analytics Leader

UCLA Outpatient Clinics; Los Angeles, Northern (CA, KY); Hybrid; USD 109,000 - 242,000; Full time

Job summary

The Ambulatory Operations Business Intelligence Developer at UCLA Outpatient Clinics leads the design, development, and optimization of clinical informatics analytics to support ambulatory operations, improve efficiency, and drive data-driven decisions.

You will mentor analysts, implement reports using Tableau, SQL, CDW/Clarity, and Data Marts, monitor performance, validate data integrity, and deliver dashboards for senior leadership.

Qualifications

• Senior technical expert leading design and optimization of clinical informatics systems.
• Mentors junior analysts and collaborates with clinical, technical, and business teams.

Responsibilities

• Lead development and optimization of complex SQL queries, views, and stored procedures.
• Design and test reports and dashboards using Tableau, CDW/Clarity, and data sources.
• Monitor performance and optimize reports; ensure data integrity and system reliability.
• Provide advanced technical support and troubleshooting for clinical informatics systems.
• Collaborate with stakeholders to plan, develop, implement, and analyze complex BI solutions.
• Deliver monthly Tableau dashboards focusing on KPI metrics and operational trends.

Skills

Mentoring

Stakeholder collaboration

Advanced analytics

Quality assurance

Tools

SQL

Tableau

CDW/Clarity

Data Marts

Job description

The Ambulatory Operations Business Intelligence Developer at UCLA Outpatient Clinics leads the design, development, and optimization of clinical informatics analytics to support ambulatory operations, improve efficiency, and drive data-driven decisions.

You will mentor analysts, implement reports using Tableau, SQL, CDW/Clarity, and Data Marts, monitor performance, validate data integrity, and deliver dashboards for senior leadership.