Affirm - Staff Analytics Engineer, Subledger Platform

• Build and own dbt models for the financial subledger platform (staging → intermediate → canonical facts/balances/marts → semantic), including naming conventions, macros, and reusable patterns. • Build and own dbt models • Implement strong data quality and controls in dbt: tests (unit/relationship/assertions), freshness, anomaly checks, and automated reconciliations that support close and audit readiness. • data quality and controls • Embed AI-assisted reconciliation capabilities into the platform (within appropriate security/controls guardrails): automate variance triage, suggest likely root causes, and generate human-reviewable reconciliation narratives and evidence artifacts. • AI-assisted reconciliation • Own end-to-end subledger data products (e.g., event/fact layers, balance rollforwards, reconciliation outputs) with traceability from source events through transformations to reporting outputs. • subledger data products • Partner with Accounting/Financial Reporting to translate requirements into clear model specifications (definitions, posting logic assumptions, tie-out rules) and ship them as durable dbt assets. • clear model specifications • Drive production operational ownership: monitoring/alerting, incident response, root-cause fixes, and release hygiene for the pipelines and models you own. • production operational ownership • Collaborate with upstream engineering teams to define inputs and improve source data quality via contracts and change management. • Coach and develop one Analytics Engineer (Poland) via code review, pairing, scoped ownership, and clear technical direction. • What we look for • Deep, hands-on analytics engineering experience: you have built and maintained production dbt projects (models, tests, macros, documentation, CI) and can own them end-to-end. • production dbt projects • Strong SQL and data modeling skills; experience building canonical datasets that support finance reporting, reconciliations, or other correctness-critical outcomes. • Experience operating data pipelines in a warehouse environment (Snowflake preferred): performance tuning, cost awareness, and reliability practices. • Strong programming skills (Python preferred) for building data tooling and automation (e.g., control checks, reconciliation workflows, utilities, CLIs, and integrations). • Deep Snowflake technical expertise: architecture patterns (micro-partitioning/clustering, query optimization), security/governance (RBAC, masking policies), and operational excellence (monitoring, cost management, reliability). • Strong ownership mindset and ability to lead ambiguous work through influence across Finance, Accounting, and Engineering stakeholders. • Experience with accounting concepts (subledgers, journal entries/posting logic, balance rollforwards, tie-outs, close processes). • Experience designing SOX-friendly controls and producing repeatable evidence from data pipelines. • Experience applying AI/LLMs to data quality or reconciliation workflows (e.g., anomaly explanation, automated investigation summaries), with strong governance and human-in-the-loop review. • AWS experience (nice to have): S3/IAM, data platform primitives, and cloud architecture concepts that support secure, reliable data products. • Base Pay Grade - OEquity Grade - 6 • Base Pay Grade • Equity Grade • Employees new to Affirm typically come in at the start of the pay range. Affirm focuses on providing a simple and transparent pay structure which is based on a variety of factors, including location, experience and job-related skills. • Employees new to Affirm typically come in at the start of the pay range. • Base pay is part of a total compensation package that may include monthly stipends for health, wellness and tech spending, and benefits (including 100% subsidized medical coverage, dental and vision for you and your dependents). In addition, the employees may be eligible for equity rewards offered by Affirm Holdings, Inc. (parent company). • CAN base pay range per year: $170,000 - $220,000 • Affirm is proud to be a remote-first company! The majority of our roles are remote and you can work almost anywhere within the country of employment. Affirmers in proximal roles have the flexibility to work remotely, but will occasionally be required to work out of their assigned Affirm office. A limited number of roles remain office-based due to the nature of their job responsibilities. • We’re extremely proud to offer competitive benefits that are anchored to our core value of people come first. Some key highlights of our benefits package include: • Health care coverage - Affirm covers all premiums for all levels of coverage for you and your dependents • Flexible Spending Wallets - generous stipends for spending on Technology, Food, various Lifestyle needs, and family forming expenses • Time off - competitive vacation and holiday schedules allowing you to take time off to rest and recharge • ESPP - An employee stock purchase plan enabling you to buy shares of Affirm at a discount • We believe It’s On Us to provide an inclusive interview experience for all, including people with disabilities. We are happy to provide reasonable accommodations to candidates in need of individualized support during the hiring process. • [For U.S. positions that could be performed in Los Angeles or San Francisco] Pursuant to the San Francisco Fair Chance Ordinance and Los Angeles Fair Chance Initiative for Hiring Ordinance, Affirm will consider for employment qualified applicants with arrest and conviction records. • By clicking "Submit Application," you acknowledge that you have read Affirm's Global Candidate Privacy Notice and hereby freely and unambiguously give informed consent to the collection, processing, use, and storage of your personal information as described therein.