What you'll do
- Model the business in dbt on BigQuery. Own a ~100-model project (staging → intermediate → marts) built on Kimball dimensional modeling: SCD Type 2 dimensions, fact tables with explicit grain, and aggregate tables for reporting. Recent work includes applicant milestone tracking, loan-process stage modeling, and ad-click-level attribution.
- Own metrics people rely on. Executive KPIs, conversion funnels, cohort analytics, and marketing attribution across Google Ads, Meta Ads, and UTM/click-ID data.
- Run the pipelines. Airflow 3 orchestration with Slack alerting, data-quality tests, freshness monitoring, and backfills. Ingestion is CDC from our production Postgres via Debezium + Kafka Connect on GKE (with Airbyte and Fivetran alongside).
- Serve the data. A dedicated dbt serving layer exposed through Hasura GraphQL powers internal ops tools in the product itself; Metabase serves dashboards and self-serve queries.
- Turn messy operational reality into tables people trust. Much of the work is business-logic modeling: screening outcomes, payment and fee states, deferral lineage, guarantor chains. You'll dig into the source system, talk to the people who run the process, and encode the truth.
- Keep quality and cost in check. dbt tests, per-model documentation, BigQuery partitioning/clustering, and bytes-scanned discipline.
- Document for humans and AI. Every model is documented, and the docs auto-sync to a companion repo built so both teammates and AI agents can query the warehouse correctly. We work AI-assisted, with coding standards written into the repos.
What success looks like in the first six months
- You run the platform day to day – pipelines, tests, and monitoring — and stakeholders don't feel a handoff.
- You've shipped new marts or metrics for at least two teams, from stakeholder conversation to documented, tested tables.
- Data quality and freshness are visibly better: fewer surprises, faster answers.
Ready to join us?
We are building a company designed to expand access to life-changing opportunities around the world.
If you are excited about building systems, solving complex problems, and shaping how a company makes decisions, we would love to meet you.
Note: Artificial intelligence may be used in the screening or assessment of applicants.
If your experience does not match every requirement but you believe you can thrive in this role, we encourage you to apply.