Senior Full Stack Analytics Developer at Manulife developing analytics solutions and innovative data visualization tools. Collaborating with diverse teams to improve investment decision - making processes.
About the role
- Staff Analytics Engineer at Affirm responsible for building and owning a Financial Subledger Data Platform. Ensuring data integrity and collaborating across Finance and Engineering teams.
Responsibilities
- 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.
Requirements
- 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.
Benefits
- 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
Job title
Job type
Experience level
Salary
Degree requirement
Tech skills
Location requirements
Report this job
Found something wrong with the page? Please let us know by submitting a report below.
Data & Analytics Engineer Co - op/Internship with BCI supporting implementation of Data & Analytics projects. Creating reports and driving data literacy while working with a dynamic team.
Analytics Engineer Intern at Canadian Fintech Ratehub. Supporting BI platform migration and data validation as part of a newly created Data Team.
Analytics Engineer designing and implementing data platforms at Pebl. Contributing to data ecosystems and improving engineering practices with AWS services.
Adobe Analytics Engineer supporting digital data collection and marketing technology integrations at Northern. Collaborating with a talented team to enhance digital experiences and ensure privacy compliance.
Senior Analytics Engineer at Tempo, building and maintaining data foundations for GTM and corporate reporting. Collaborating on datasets, reports, and improving data model usability.
Analytics Engineer at Tucows utilizing advanced analytics expertise to extract insights from raw data. Collaborating across teams to drive data - driven decision - making and optimize data processes.
Senior Analytics Developer building analytical foundation from scratch for People Analytics at Wealthsimple. Designing data pipelines and ensuring data governance practices are in place.
Senior Analytics Engineer building complex data models and insights at Coconut Software. Mentoring team members and supporting data - driven business strategies with advanced analytics.
Senior Analytics Engineer role at Fullscript focused on enabling self - serve analytics. Collaborating across teams to design solutions that improve data accessibility and usage.