Staff Analytics Engineer, Subledger Platform

AffirmAffirm·Remote(Remote Canada)
Data & Analytics
Excel

WFA Digital Insight

As the demand for skilled analytics engineers continues to grow, with a 25% increase in remote job postings in 2026, Affirm is seeking a talented Staff Analytics Engineer to build and own their Financial Subledger Data Platform. This role is particularly interesting in the current market, where companies are looking for experts who can navigate complex financial systems and implement scalable BI solutions. With the rise of remote work, professionals with expertise in dbt, Snowflake, and data governance are in high demand. Before applying, candidates should be aware of the company's commitment to innovation and customer satisfaction, and be prepared to showcase their skills in data modeling, testing, and collaboration.

Job Description

About the Role

The Staff Analytics Engineer will play a crucial role in Affirm's Finance team, building and owning the Financial Subledger Data Platform. This platform is the foundation for the company's financial reporting, accounting, and decision-making processes. As a senior hands-on role, the ideal candidate will have experience in designing, developing, and maintaining large-scale data systems, with a strong focus on data quality, governance, and scalability. The Finance team at Affirm is responsible for ensuring the company's financial soundness and strategic growth. The team manages financial planning, accounting, pricing, vendor management, tax, investor relations, and corporate development. As a Staff Analytics Engineer, you will work closely with the Accounting and Financial Reporting teams to translate requirements into clear model specifications and ship them as durable dbt assets. The company is looking for someone who can maintain and harden today's platform while also giving them the flexibility to adopt new technologies as their subledger and control needs scale.

What You Will Do

  • Build and own dbt models for the financial subledger platform, 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, automating variance triage, suggesting likely root causes, and generating human-reviewable reconciliation narratives and evidence artifacts.
  • Own end-to-end subledger data products with traceability from source events through transformations to reporting outputs.
  • Partner with Accounting/Financial Reporting to translate requirements into clear model specifications 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 via code review, pairing, scoped ownership, and clear technical direction.
  • Maintain and harden today's platform while also giving the company the flexibility to adopt new technologies as their subledger and control needs scale.

What We Are Looking For

  • Deep, hands-on analytics engineering experience, with a focus on building and maintaining production dbt projects.
  • Experience with dbt, Snowflake, and data governance.
  • Strong data modeling skills, with the ability to design and develop large-scale data systems.
  • Excellent collaboration and communication skills, with the ability to work with cross-functional teams.
  • Experience with data quality and controls, including testing, anomaly detection, and automated reconciliations.
  • Strong problem-solving skills, with the ability to analyze complex problems and develop creative solutions.
  • Experience with AI-assisted reconciliation and data products.
  • Strong operational ownership skills, with the ability to drive monitoring, incident response, and root-cause fixes.

Nice to Have

  • Experience with Excel and data visualization tools.
  • Knowledge of financial accounting and reporting principles.
  • Experience with cloud-based data platforms and technologies.
  • Certification in data engineering or a related field.
  • Experience with agile development methodologies and version control systems.

Benefits and Perks

  • Competitive salary and benefits package.
  • Opportunity to work with a talented and experienced team.
  • Flexible working hours and remote work options.
  • Professional development and growth opportunities.
  • Access to the latest technologies and tools.
  • Comprehensive health and wellness programs.
  • Generous parental leave and family benefits.
  • Employee recognition and reward programs.

How to Stand Out

  • Tip: Make sure to highlight your experience with dbt, Snowflake, and data governance in your application, as these are key skills for the role.
  • Tip: Be prepared to provide examples of your data modeling skills, including your ability to design and develop large-scale data systems.
  • Tip: Show a strong understanding of data quality and controls, including testing, anomaly detection, and automated reconciliations.
  • Tip: Demonstrate your ability to work collaboratively with cross-functional teams, including Accounting and Financial Reporting.
  • Tip: Be prepared to discuss your experience with AI-assisted reconciliation and data products, and how you can apply these skills to the role.
  • Tip: Highlight your problem-solving skills, including your ability to analyze complex problems and develop creative solutions.
  • Tip: Make sure to research the company culture and values, and be prepared to discuss how you can contribute to the team's success.

This is a remote position listed on WFA Digital, the platform for professionals who work from anywhere. Browse more remote jobs across all categories.