7-10+ years in business intelligence, analytics, or data engineering roles
Hands-on experience with raw healthcare data required
Experience in multi-site physician practice or specialty practice strongly preferred
Advanced SQL skills with the ability to write complex queries
Strong understanding of healthcare data models
Familiarity with BI tools such as Power BI or Looker
Advanced Excel and data validation skills
Responsibilities
Work directly with raw data extracts from various healthcare systems
Write and optimize SQL queries for data extraction and validation
Perform data profiling and root-cause analysis to ensure reporting accuracy
Build and maintain datasets, semantic layers, and data models for analysis
Develop custom analyses to address complex business questions
Collaborate with IT and vendors on data ingestion and warehouse design
Translate raw data into dashboards and performance reports
Benefits
Opportunity to mentor analysts and engineers
Balance of strategic leadership and hands-on execution
Collaboration with multiple departments for comprehensive analytics
Direct impact on clinical operations and financial performance
Involvement in high-impact initiatives leading to organizational growth
Full Job Description
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
Requirements
Experience
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; multi-site physician practice or specialty practice strongly preferred
