Affirm
Mid
Build and harden dbt/Snowflake pipelines powering Affirm's Accounting reporting
This role sits in Financial Systems, owning dbt models and core datasets that feed Accounting reporting, reconciliations, and automation on Snowflake. The interview centers on operational ownership — reliability engineering for data pipelines, root-cause debugging of production data issues, and disciplined GitHub-based development practices — more than green-field modeling.
Step into this interview
Free · a live voice mock calibrated to this exact role
What this interview tests
- dbt modeling, testing, and documentation
- Snowflake performance and cost optimization
- Production data incident root-causing
- Pipeline reliability (alerting, runbooks, lineage/auditability)
- Git/PR-based development workflow
Common question themes
Walk me through a production data issue you root-caused through a dbt pipeline
How do you design tests and alerting to catch data quality issues before they hit reporting
Describe how you'd document lineage and changes on a finance-critical dataset for auditability
How have you optimized Snowflake cost or query performance on a growing dataset
Tell me about your GitHub-based review process for dbt model changes