Director of Business Intelligence & Analytics
Share
Job Location:
Santa Ana, CA - USA
Monthly Salary:
Not Disclosed
Posted on:
Yesterday
Vacancies:
1 Vacancy
Job Summary
Position Summary
The Director of Business Intelligence & Analytics is a hands-on technically proficient leader responsible for transforming raw clinical operational and financial data into actionable insights. This role requires the ability to directly access manipulate validate and model data from multiple source systems while also leading the analytics strategy for the organization. The Director works closely with clinical leadership operations finance revenue cycle and IT to ensure data accuracy transparency and meaningful decision support.
Core Responsibilities
- Directly work 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 data discrepancies and ensure trust in reporting
- Build and maintain analytic datasets semantic layers and data models to support dashboards and ad hoc analysis
- Develop custom analyses using raw data to answer complex non-standard business questions
- Manage and understand data structures from systems such as:
- EHR and PM platforms
- Revenue cycle and billing systems
- External benchmarks registries and payer data
- Partner with IT and vendors on data ingestion ETL processes and data warehouse design with the ability to 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 to support 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
Experience
- 710 years in business intelligence analytics or data engineering roles
- Demonstrated experience personally working with raw healthcare data not solely managing analysts
- Healthcare experience required; multi-site physician practice or specialty practice strongly preferred
Technical Skills (Required)
- Advanced SQL (writing complex queries joins CTEs window functions)
- Experience working directly with source system databases and data warehouses
- Strong understanding of healthcare data models (encounters procedures charges payments adjustments scheduling)
- Experience with BI tools (Power BI Looker etc.)
- Advanced Excel and data validation skills
Preferred
- Familiarity with ophthalmology or surgical specialty data
- Experience validating vendor-delivered data feeds and reports
Required Experience:
Director
Key Skills
- Business Intelligence
- Cognos
- SQL
- Power BI
- QlikView
- Data Visualization
- ssrs
- Tableau
- SSIS
- Data Modeling
- Data Warehouse
- Data Analysis Skills
About Company
Our industry-leading team of doctors and staff are committed to providing best-in-class eye care services and comprehensive treatment to the people in our communities.
