Analytics and Reporting Lead
- Lead the analytics and reporting function and own the batch analytics platform behind client reporting.
- Run 25 ingestion pipelines (21 hourly, 121 tables, about 2,900 table loads a day) landing into BigQuery through Cloud Storage with a change-set merge and a 2-hour look-back window.
- Maintain 599 dbt models and 908 automated data tests; 233 models rebuild hourly, 124 daily, all transformation as SQL inside the warehouse, run from git through GitHub Actions.
- Added a daily completeness check that compares what each pipeline claims it built against what BigQuery actually changed, so a job that reports success while writing nothing is caught.
- Keep the platform fully on-demand - 3.5 TB scanned a day (about 105 TB a month) with no capacity reservations - and deliver client reports as staged files over SFTP or email with per-contract password archives.