Affirm is a financial services company that is on a mission to provide its customers with “honest financial products that improve lives.” As an employer, Affirm maintains a rem
Staff Analytics Engineer, Subledger Platform
Location
California + 4 moreAll locations: California | Connecticut | New Jersey | New York | Washington
Posted
29 days ago
Salary
$191K - $265K / year
Seniority
Lead
Job Description
Staff Analytics Engineer, Subledger Platform
Affirm
• 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.
Job 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
Related Guides
Related Categories
Related Job Pages
More Analytics Engineer Jobs
Analytics - Databricks Engineer Senior
UnityPoint HealthUnityPoint Health is a healthcare system whose coordinated approach to medical care serves patients across metropolitan and rural communities in Iowa and Illinois. Founded in 1995
UnityPoint Health | Des Moines Consolidated Serv 1601 SE Gateway Dr, Grimes, IA Job Description: - Remote: Yes - Area of Interest: Business Professionals - FTE/Hours per pay period: 1.0 - Department: Supply Chain Analytics - Shift: Monday-Friday, Days - Job ID: 181247 Overview Location: Remote/work from home with strong preference for candidates residing within the UPH geographies of Iowa, Illinois, & Wisconsin This position does not offer Visa sponsorship. Candidates must have permanent work authorization in the United States. UnityPoint Health is transforming into a highly reliable, data‑informed organization — and our Analytics team is at the center of that mission. We partner across clinical, operational, and financial areas to drive meaningful, measurable improvement through data and analytics. We’re seeking a Senior Analytics/Databricks Engineer to lead the development of data‑driven products that power decision‑making across the system. In this senior role, you’ll guide the full analytics lifecycle while collaborating with IT ETL teams, analytics business partners, and end‑users to deliver impactful solutions. Why UnityPoint Health? At UnityPoint Health, you matter. We’re proud to be recognized as a Top Place to Work in Healthcare by Becker's Healthcare several years in a row for our commitment to our team members. Our competitive Total Rewards program offers benefits options focused on your needs and priorities, no matter what life stage you’re in. Here are just a few: - Expect paid time off, parental leave, 401K matching and an employee recognition program. - Dental, health and vision insurance, paid holidays, short and long-term disability and more. We even offer pet insurance for your four-legged family members. - Early access to earned wages with Daily Pay, tuition reimbursement to help further your career and adoption assistance to help you grow your family. With a collective goal to champion a culture of belonging where everyone feels valued and respected, we honor the ways people are unique and embrace what brings us together. And, we believe equipping you with support and development opportunities is a vital part of delivering an exceptional employment experience. Join our team of experts and make a difference with UnityPoint Health. Responsibilities - Lead the design, development, and maintenance of complex data models, analytics products, and production‑quality code - Transform and prepare data from multiple sources to ensure it is accurate, contextualized, and ready for analysis - Scope analytics work, manage development lifecycles, and provide clear, routine status updates - Independently lead projects and cross‑functional teams, ensuring strong performance, timely issue resolution, and effective resource use - Mentor analytics team members, deliver training, and support the growth of data literacy across the organization - Build dashboards, reports, and visualizations that communicate insights clearly and support data‑informed decision‑making - Support deployment of analytics solutions through documentation, user training, and leadership in implementation and enhancement processes - Partner with stakeholders to understand business needs, translate them into analytics solutions, and advance strategic, data‑driven outcomes Qualifications Education: - Required: - Bachelor’s Degree in Engineering, Operations Research, Business, Business Analytics, Healthcare Administration, Mathematics, Statistics, Data Science, Actuarial Science or related field - Equivalent experience of at least 7 years working in an analytics or healthcare operations setting that includes demonstrated results driving improvements using data and analytics methodologies and techniques may be substituted for education requirement - Preferred: - Master’s of Science in Engineering, Operations Research, Business, Business Analytics, Healthcare Administration, Mathematics, Statistics, Data Science, Actuarial Science or other related field - PhD in Engineering, Operations Research, Business, Business Analytics, Healthcare Administration, Mathematics, Statistics, Data Science, Actuarial Science or other related field Experience: - Relevant work experience is required - Databricks experience is preferred
• You will be the hands-on owner of our analytics and data ecosystem, transforming complex data into actionable insights that drive strategic decision-making. • In this role, you will manage, build, maintain, and ingest data from various source systems (such as HRIS, ATS, and Identity). • We are looking for an ambidextrous engineer who is highly proficient in using Claude Code and other GenAI tools to rapidly build both the middle data layer (canonical models, semantic layers) and the app layer. • Through this hybrid approach, you will surface insights and create beautiful UI visuals that translate complex data into clear, compelling narratives for end users.
Analytics Engineer
AmbevWe're not just about beer. Come in and find out how we're going #BeyondLabels. Adults only. Drink in moderation.
• Data modeling (facts, dimensions, metrics) and maintenance of pipelines/transformations using SQL and the team’s tools (e.g., dbt, Spark, or Databricks). • Contribute to quality tests and the documentation of metrics and business rules. • Assist in delivering tables/views for analytical consumption, ensuring best practices (naming, descriptions, consistency). • Work alongside Data Engineering, BI/Analysts, and Data Science (on well-defined tasks). • Participate in governance initiatives (lineage, catalog, access) and in gradual improvements to data reliability.
• Participate in transforming traditional BI into an AI-augmented BI model. • Maintain and evolve data modeling and dashboards in Looker (LookML), ensuring operational continuity. • Build GenBI layers for automatic insight generation and conversational analytics. • Develop data products with applied AI, such as automated summaries and intelligent alerts. • Automate workflows, queries, and documentation using tools like Claude Code, Cursor, or similar. • Mentor the technical team, establishing new standards and analytics best practices. • Translate business challenges into high-impact analytical solutions for stakeholders and clients.




