Staff Analytics Engineer, Subledger Platform

Affirm Affirm · Fintech · Canada, United States · Remote · Accounting

Staff Analytics Engineer role focused on building and owning the Financial Subledger Data Platform using dbt and Snowflake. The role involves creating dbt models, implementing data quality and controls, and embedding AI-assisted reconciliation capabilities. It requires strong SQL, data modeling, Python, and Snowflake expertise, with a focus on production ownership and mentoring.

What you'd actually do

  1. Build and own dbt models for the financial subledger platform (staging → intermediate → canonical facts/balances/marts → semantic), including naming conventions, macros, and reusable patterns.
  2. Implement strong data quality and controls in dbt: tests (unit/relationship/assertions), freshness, anomaly checks, and automated reconciliations that support close and audit readiness.
  3. 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.
  4. 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.
  5. 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.

Skills

Required

  • dbt
  • Snowflake
  • SQL
  • data modeling
  • Python
  • data quality
  • controls
  • production ownership
  • monitoring
  • alerting
  • incident response

Nice to have

  • accounting concepts
  • SOX-friendly controls
  • AI/LLMs for data quality
  • AWS

What the JD emphasized

  • production dbt code
  • data quality and controls
  • AI-assisted reconciliation
  • production operational ownership
  • production dbt projects

Other signals

  • AI-assisted reconciliation
  • dbt models
  • data quality and controls