Build Scalable Healthcare Analytics Dashboards with Looker Studio and BigQuery

We're a healthcare business looking to build automated dashboards in Looker Studio. Our data currently lives in Google Sheets, but the spreadsheets have become slow and hard to manage.

We want to:
- Pull data automatically from multiple sources via API keys (Rethink, Rippling, Google Ads)
- Store and process data in BigQuery
- Build dashboards for key metrics like clinician and site performance, billable vs admin time, retention, and ad spend
- Allow limited data overrides when needed
- Experience with Looker Studio, BigQuery, and healthcare analytics is preferred.
- Must be available in CST timezone.
- Responsive communication (quick replies during project hours)