Staff Analytics Engineer, Subledger Platform

Posted 22 Days Ago
Easy Apply
Hiring Remotely in United States
Remote
191K-265K Annually
Senior level
Big Data • Fintech • Mobile • Payments • Financial Services
We create honest financial products that improve lives. Ready to make a difference?
The Role
The Staff Analytics Engineer will own the Financial Subledger Data Platform, build dbt models, implement data quality controls, and mentor a junior engineer, ensuring high operational reliability and cross-functional collaboration.
Summary Generated by Built In

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.

About the Finance team 

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 decision-making. From day-to-day 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.

We’re 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, accounting-ready outputs. This is a senior hands-on 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 cross-functional partnership across Accounting, Financial Reporting, Financial Systems, and upstream product engineering teams.

We want someone who can maintain and harden today’s 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 you’ll 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 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.
  • 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.
  • 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.
  • Drive production operational ownership: monitoring/alerting, incident response, root-cause 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, 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.
  • 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.
  • Nice to have:
    • 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 - O
Equity Grade - 12
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.
Base pay is part of a total compensation package that may include equity rewards, monthly stipends for health, wellness and tech spending, and benefits (including 100% subsidized medical coverage, dental and vision for you and your dependents).
USA base pay range (CA, WA, NY, NJ, CT) per year: $215,000 - $265,000
USA base pay range (all other U.S. states) per year: $191,000 - $241,000
#LI-Remote

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.

Skills Required

  • Extensive experience with production dbt projects
  • Strong SQL and data modeling skills
  • Experience operating data pipelines in a warehouse environment
  • Deep Snowflake technical expertise
  • Strong programming skills in Python

What the Team is Saying

Nupur
Jerry
Adam

Affirm Compensation & Benefits Highlights

  • Healthcare Strength Healthcare coverage includes $0 employee premiums for medical, dental, and vision across all tiers, alongside company‑paid life, AD&D, and disability coverage. Mental‑health access via Spring Health provides no‑cost sessions and guided care navigation for employees and eligible family members.
  • Leave & Time Off Breadth Time away spans Flexible Time Off for exempt staff, ~20 accrued vacation days for non‑exempt, 10 Health Days, up to 15 Life Happens days, bereavement up to 10 days, and scheduled company‑wide Away Days. These layers create frequent, structured opportunities to disconnect beyond standard PTO.
  • Parental & Family Support Paid parental leave provides 18 weeks for birth and non‑birth parents with return‑to‑work transition support. Family‑building benefits include Maven support and a one‑time $20,000 S.A.F.E. wallet for surrogacy, adoption, fertility, and egg freezing.

Affirm Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: San Francisco , CA
2,200 Employees
Year Founded: 2012

What We Do

At Affirm, we help people say yes to the things that matter with flexible, transparent ways to pay over time. No hidden fees, no compound interest, and no fine print—just a smarter way to spend.

Why Work With Us

Who is an Affirmer? /noun/ Someone who believes finance shouldn’t be complicated. We come from a diverse set of backgrounds and we’re driven by the desire to improve lives through honest financial products. We define success by challenging one another to bring our best ideas to every single project—and we have fun while doing it.

Gallery

Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery

Affirm Offices

Remote Workspace

Employees work remotely.

Affirm is a remote-first company! Our employees can work anywhere in the U.S. but if an office is more your style, we have office locations in San Francisco, Chicago, New York City, and Pittsburgh.

Typical time on-site:
HQSan Francisco, CA
Spain
United Kingdom
Chicago, IL
New York, NY
Toronto, ON
Warsaw, PL
Learn more

Similar Jobs

Affirm Logo Affirm

Compliance Lead, Network Growth

Big Data • Fintech • Mobile • Payments • Financial Services
Easy Apply
Remote
United States
2200 Employees
115K-170K Annually

Affirm Logo Affirm

Senior Director, Key & Enterprise Sales

Big Data • Fintech • Mobile • Payments • Financial Services
Easy Apply
Remote
United States
2200 Employees
382K-530K Annually

Affirm Logo Affirm

Senior Engineering Manager

Big Data • Fintech • Mobile • Payments • Financial Services
Easy Apply
Remote
United States
2200 Employees
232K-310K Annually

Affirm Logo Affirm

Compliance Lead, Fair Lending

Big Data • Fintech • Mobile • Payments • Financial Services
Easy Apply
Remote
United States
2200 Employees
115K-170K Annually

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account