Director of Business Intelligence & Analytics

Acuity Eye Group•Santa Ana, CA

About The Position

The Director of Business Intelligence & Analytics is a hands-on, technically proficient leader who transforms raw clinical, operational, and financial data into actionable insights while leading the organization’s analytics strategy. The role directly accesses, manipulates, validates, and models data from multiple source systems and works closely with clinical leadership, operations, finance, revenue cycle, and IT to support data accuracy, transparency, and meaningful decision-making. The Director works with data from EHR, practice management, ASC, billing, financial, external benchmark, registry, and payer systems. The role develops analytic datasets, semantic layers, data models, dashboards, physician performance reports, and operational scorecards, while maintaining traceability from reported metrics back to source data. It also supports data ingestion, ETL processes, and data warehouse design in partnership with IT and vendors, and provides rapid analysis for clinical operations, physician compensation, payer negotiations, and growth initiatives. This position balances strategic leadership with hands-on analytical execution, establishes standards for data definitions, metric logic, and documentation, and mentors analysts and engineers in working with raw data and source systems.

Requirements

7–10+ years in business intelligence, analytics, or data engineering roles.
Demonstrated experience personally working with raw healthcare data, not solely managing analysts.
Healthcare experience required.
Advanced SQL skills, including complex queries, joins, CTEs, and window functions.
Experience working directly with source system databases and data warehouses.
Strong understanding of healthcare data models, including encounters, procedures, charges, payments, adjustments, and scheduling.
Experience with BI tools such as Power BI or Looker.
Advanced Excel and data validation skills.

Nice To Haves

Multi-site physician practice or specialty practice experience is strongly preferred.
Familiarity with ophthalmology or surgical specialty data.
Experience validating vendor-delivered data feeds and reports.

Responsibilities

Work directly with raw data extracts and source system tables from EHR, practice management, ASC, billing, and financial systems.
Write and optimize SQL queries to extract, join, and validate data across disparate systems.
Perform data profiling, reconciliation, and root-cause analysis to resolve discrepancies and ensure trust in reporting.
Build and maintain analytic datasets, semantic layers, and data models for dashboards and ad hoc analysis.
Develop custom analyses using raw data to answer complex, non-standard business questions.
Manage and understand data structures across EHR and PM platforms, revenue cycle and billing systems, and external benchmark, registry, and payer data.
Partner with IT and vendors on data ingestion, ETL processes, and data warehouse design, and independently validate outputs.
Translate raw data into executive dashboards, physician performance reports, and operational scorecards.
Ensure traceability from dashboard metrics back to source data.
Provide rapid, ad hoc analyses supporting clinical operations, physician compensation, payer negotiations, and growth initiatives.
Establish standards for data definitions, metric logic, and documentation.
Mentor analysts and engineers in best practices for working with raw data and source systems.
Balance strategic leadership with hands-on analytical execution, especially for high-impact initiatives.