itjobs.ca Logo
Affirm logo

Staff Analytics Engineer

Affirm19 days ago
Remote
CA$124,945 - CA$161,693/yearly
Staff

Top Benefits

Remote-first compensation structure
Health benefits plan
Mental health programs

About the role

Who you are

  • 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
  • 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

What the job involves

  • 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
  • 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

Benefits

  • Compensation: We have a simple, flexible, and transparent remote-first compensation structure so you can make the best decisions for yourself and your family
  • Spending Wallets: Access tech, food, lifestyle, and family planning wallets for your expenses
  • Supportive Communities: Get involved with our employee resource groups and community groups
  • Remote-first Workforce: If your role is remote, you can set up shop anywhere in your home country
  • Generous Time Off: Take the time you need when life happens
  • Health Benefits: Get a plan that fits your needs
  • Mental Healthcare: Take care of your mind with great mental health programs
  • Parental Leave: Birth and non-birth parents get 18 weeks’ paid leave. Plus, a 4-week return-to-work transition program, at full base pay
  • Away Days: We offer 20 company-wide paid days off—which help our teams collectively pause to recharge
  • Learning & Development: Engage in exciting learning programs to level up your growth

About Affirm

Financial Services