Skip to Main Content

Job Title


Staff Analytics Engineer, Subledger Platform


Company : Affirm


Location : Windsor,


Created : 2026-05-04


Job Type : Full Time


Job Description

About The Finance Team Affirm is reinventing credit to make it more honest and friendly, giving consumers the flexibility to buy now and pay later without any hidden fees or compounding interest. The Finance team ensures affirm remains financially sound and strategically positioned for growth. Our team manages financial planning, accounting, pricing, vendor management, tax, investor relations, and corporate development. We deliver timely insights, accurate reporting, and careful analysis to support decisionmaking. From daytoday financial operations to major investments, we enable sustainable, informed growth by maintaining strong fiscal discipline. About The Team 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 and scaling a single source of truth for financial information using dbt and Snowflake to enable scalable BI, close workflows, controls, and automation across the org. Were looking for a Staff Analytics Engineer to build and own our Financial Subledger Data Platform the canonical set of dbt models, governed datasets, and control frameworks that transform operational/ledger events into trusted, explainable, accountingready outputs. This is a senior handson role: you will write and ship production dbt code yourself (models, tests, docs), set standards for the platform, and directly manage and mentor one Analytics Engineer as a player/coach. This role operates with high autonomy and significant crossfunctional partnership across Accounting, Financial Reporting, Financial Systems, and upstream product engineering teams. We want someone who can maintain and harden todays platform while also giving us flexibility to adopt new technologies (e.g., evolving warehouse patterns, new table formats, catalog/governance tooling, orchestration approaches) as our subledger and control needs scale. What youll do Build and own dbt models for the financial subledger platform (staging intermediate canonical facts/balances/marts semantic), including naming conventions, macros, and reusable patterns. Implement strong data quality and controls in dbt: tests (unit/relationship/assertions), freshness, anomaly checks, and automated reconciliations that support close and audit readiness. Embed AIassisted reconciliation capabilities into the platform (within appropriate security/controls guardrails): automate variance triage, suggest likely root causes, and generate humanreviewable reconciliation narratives and evidence artifacts. Own endtoend subledger data products (e.g., event/fact layers, balance rollforwards, reconciliation outputs) with traceability from source events through transformations to reporting outputs. Partner with Accounting/Financial Reporting to translate requirements into clear model specifications (definitions, posting logic assumptions, tieout rules) and ship them as durable dbt assets. Drive production operational ownership: monitoring/alerting, incident response, rootcause fixes, and release hygiene for the pipelines and models you own. 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, handson analytics engineering experience: you have built and maintained production dbt projects (models, tests, macros, documentation, CI) and can own them endtoend. Strong SQL and data modeling skills; experience building canonical datasets that support finance reporting, reconciliations, or other correctnesscritical 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 (micropartitioning/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. Nice to have: Experience with accounting concepts (subledgers, journal entries/posting logic, balance rollforwards, tieouts, close processes). Experience designing SOXfriendly 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 humanintheloop review. AWS experience (nice to have): S3/IAM, data platform primitives, and cloud architecture concepts that support secure, reliable data products. Benefits 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 Remote Work Affirm is proud to be a remotefirst company! The majority of our roles are remote and you can work almost anywhere within the country of employment. Affirmer roles with proximal responsibilities 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 officebased due to the nature of their job responsibilities. EEO Statement We believe Its 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. #J-18808-Ljbffr