Jobs.ca
Jobs.ca
Language
Affirm logo

Staff Analytics Engineer

Affirm20 days ago
Remote
Canada
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
1001-5000

At Affirm, we’re using today’s technology to bring significant disruptive innovation to the financial industry. We focus on improving the lives of consumers by delivering simple, honest and transparent financial products.

We have roles across a variety of teams, including engineering, product, finance, operations, revenue, marketing, people and more.

A note to applicants: Fake job and recruiting scams are on the rise. Affirm will never ask you to pay any upfront fees or send you any checks to purchase equipment during any part of the recruiting process. Affirm only uses legitimate company email address domains (either “@affirm.com” or "@us.greenhouse-mail.io”) to communicate with candidates via email.

We have roles across a variety of teams, including engineering, product, finance, operations, revenue, marketing, people and more.

Affirm is also proud to be a remote-first company! Attracting great people starts by finding talent in different places. That's why we built remote work into the DNA of how we do business—but if an office space is more your style, we have offices in Chicago, New York City, Pittsburgh, San Francisco, and Toronto.

Not to mention we have comprehensive and award-winning benefits that were made for you.

Interested in learning more? Check out our careers page and apply today!

Visit affirm.com/careers for more information.

A note to applicants: Fake job and recruiting scams are on the rise. Affirm will never ask you to pay any upfront fees or send you any checks to purchase equipment during any part of the recruiting process. Affirm only uses legitimate company email address domains (either “@affirm.com” or "@us.greenhouse-mail.io”) to communicate with candidates via email.

Similar Jobs