About the role
We have Google Ads data, Meta data, GA4, call tracking and a dozen different client CRMs, and most of it never gets joined up. You will own reporting infrastructure across the portfolio and, more importantly, be the person who notices the thing nobody asked about.
What you will actually do
- Build and maintain Looker Studio dashboards clients actually open
- Join ad platform data to CRM outcomes so we report on patients, not leads
- Write SQL against BigQuery for anything the UI cannot answer
- Build cohort and LTV analysis by treatment type and clinic
- Flag accounts drifting the wrong way before the account manager notices
- Kill metrics that nobody uses, which is most of them
What we need from you
- SQL you write daily, not SQL you once did a course in
- Looker Studio or Power BI to a real standard
- GA4 including the BigQuery export schema
- You can tell the difference between a real signal and noise in a small sample
- You explain findings in a sentence before you show the chart
Nice to have
- Python for analysis
- Google Ads API or Meta API
- dbt or similar
- Healthcare or subscription-business analytics
How this application works
Upload your CV, then answer 6 questions written specifically for this role. They are not personality questions. They are the kind of problems you would be handling here in week one.
There is no time limit and you can take as long as you want. We would rather read four considered answers than twelve rushed ones. Applications without answers are not reviewed.