Staff Analytics Engineer, Subledger Platform

4 hours, 26 minutes ago
Full-time
Lead
Data Science and Analytics
Affirm

Affirm

Affirm offers a transparent buy now, pay later service founded in 2012 by Max Levchin. No late fees or surprises, just a responsible way to pay over time for your favorite brands.

Diversified Financial Services
1K-5K
Founded 2012

Description

  • Build and own dbt models for the financial subledger platform, including staging, intermediate, canonical facts/balances, marts, and semantic layers.
  • Implement data quality controls in dbt, including tests, freshness checks, anomaly detection, and automated reconciliations.
  • Embed AI-assisted reconciliation capabilities to automate variance triage, suggest root causes, and generate reviewable narratives and evidence.
  • Own subledger data products with traceability from source events through transformations to reporting outputs.
  • Partner with Accounting and Financial Reporting to translate business requirements into clear model specifications and durable dbt assets.
  • Drive production operational ownership, including monitoring, alerting, incident response, root-cause fixes, and release hygiene.
  • Collaborate with upstream engineering teams to define inputs and improve source data quality through contracts and change management.
  • Coach and develop one Analytics Engineer through code review, pairing, scoped ownership, and technical direction.

Requirements

  • Deep hands-on analytics engineering experience building and maintaining production dbt projects, including models, tests, macros, documentation, and CI.
  • Strong SQL and data modeling skills, with experience building canonical datasets for finance reporting, reconciliations, or other correctness-critical outcomes.
  • Experience operating data pipelines in a warehouse environment, with Snowflake preferred.
  • Strong programming skills in Python preferred for data tooling and automation.
  • Deep Snowflake expertise, including architecture patterns, query optimization, RBAC, masking policies, monitoring, cost management, and reliability.
  • Strong ownership mindset and ability to lead ambiguous work through influence across Finance, Accounting, and Engineering stakeholders.
  • Experience with accounting concepts such as subledgers, journal entries, posting logic, balance rollforwards, tie-outs, and close processes, preferred.
  • Experience designing SOX-friendly controls and producing repeatable evidence from data pipelines, preferred.
  • Experience applying AI/LLMs to data quality or reconciliation workflows with governance and human-in-the-loop review, preferred.
  • AWS experience, including S3, IAM, data platform primitives, and cloud architecture concepts, preferred.

Benefits

  • Remote-first work environment with flexibility to work almost anywhere in the country of employment.
  • Base pay range of CAN $170,000 to $220,000 per year.
  • Monthly stipends for health, wellness, and tech spending.
  • 100% subsidized medical coverage, plus dental and vision coverage for you and your dependents.
  • Health care coverage with all premiums covered for all levels of coverage for you and your dependents.
  • Flexible Spending Wallets for technology, food, lifestyle needs, and family-forming expenses.
  • Competitive vacation and holiday schedules.
  • Employee Stock Purchase Plan (ESPP) allowing you to buy Affirm shares at a discount.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Contract: Lead Analytics Engineer - Data Team

Newsela 251-1K Diversified Consumer Services

Newsela is hiring a Mexico- or Argentina-based contractor to lead analytics engineering for its data team, focusing on building trustworthy data models, analytics, and stakeholder-facing insights for K–12 education products.

Apache Airflow AWS CI/CD Dagster dbt GCP Git Python SQL Tableau Terraform
2 hours, 11 minutes ago

Analytics Engineer

realtor.com 1K-5K Internet Software & Services

Realtor.com is hiring an Analytics Engineer to own the data layer for a new HR Performance and Goal Management product supporting about 1,500 employees across review cycles.

Agile Apache Airflow dbt Git Looker Python SFTP Snowflake SQL Tableau
2 hours, 41 minutes ago

Analytics Engineer II

Puck 1-10 Internet Software & Services

Earnest is hiring an Analytics Engineer II to build reliable data models and datasets that help Product, Risk, and Analytics teams make faster, better decisions.

Apache Airflow dbt Looker Snowflake SQL Tableau
3 hours, 26 minutes ago

Analytics Engineer

Stripe 5K-10K Diversified Financial Services

Stripe’s Global Payments Performance team is hiring a data and tooling-focused role to build analytics assets that help experts deliver payment optimization insights to merchants.

Git Python SQL
3 hours, 41 minutes ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers