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.
走进这场面试
免费 · 一场按这个岗位校准的真语音模拟
这场面试考什么
- 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
常见提问方向
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
相关面试
Affirm
Staff
Staff Product Manager, App Platform & Experience
Affirm
Manager
Manager, Machine Learning Engineering (Repayment & Recovery)
Affirm
Senior
Group Product Management Manager
Coinbase
Mid
Analytics Engineer, Compliance Data
Coinbase
Mid
Analytics Engineer, GFCO Analytics
Dropbox
Staff