Analytics Engineer II

<div class="content-intro"><p>At Affirm, we exist for the moments that matter—giving people a clear, predictable way to pay over time, with no hidden fees, no surprises, and no tradeoffs on what matters most.</p></div><p>Financial Systems owns the data and reporting foundation for Accounting, and the operational reliability of the pipelines that power reporting, reconciliations, and automation. We are building a single source of truth for financial information using dbt and Snowflake to enable scalable BI and process automation across the org.</p> <p>We are hiring an Analytics Engineer focused on <strong>maintaining and optimizing our finance data platform</strong>, improving <strong>reliability, efficiency, and performance</strong> of our pipelines and core datasets. This role is ideal for someone who enjoys operational ownership, building strong foundations, and making data systems easier and safer to run at scale.</p> <h3>What You’ll Do</h3> <ul> <li>Build and maintain dbt models and core datasets that support Accounting reporting and downstream automation use cases.</li> <li>Improve platform <strong>reliability</strong> through strong testing patterns, alerting, and runbooks.</li> <li>Own and document data pipelines and lineage, ensuring changes are understandable and auditable.</li> <li>Identify, troubleshoot, and resolve production data issues, and drive root-cause fixes.</li> <li>Optimize performance and cost in Snowflake and dbt to support scaling needs.</li> <li>Partner with engineering and business stakeholders to translate requirements into durable, well-tested data assets.</li> <li>Contribute to the team’s best practices in version control, code review, documentation, and release hygiene (GitHub-based workflows).</li> </ul> <h3>What We Look For</h3> <ul> <li>3+ years of experience in analytics engineering, data engineering, or similar roles working with production data systems.</li> <li>Strong SQL skills and hands-on experience building in dbt (modeling, testing, documentation).</li> <li>Experience operating in a modern development workflow: <ul> <li>Git and pull-request based collaboration (GitHub preferred).</li> <li>Familiarity with standard IDEs and collaborative debugging practices.</li> </ul> </li> <li>Experience working with cloud data warehouses (Snowflake preferred).</li> <li>A strong sense of ownership and comfort working in ambiguous, fast-moving environments.</li> </ul> <h3>Nice to Have</h3> <ul> <li>Finance/accounting data familiarity (e.g., close concepts, reconciliations, ledger-style modeling).</li> <li>Experience with integration/automation platforms (Workato, Fivetr