Analytics Engineer II

Stack

Responsibilities

• ▹Build and maintain dbt models and core datasets supporting Accounting reporting and automation
• ▹Improve platform reliability through strong testing patterns, alerting and runbooks
• ▹Own and document data pipelines and lineage for auditability
• ▹Identify, troubleshoot and resolve production data issues, driving root-cause fixes
• ▹Optimize Snowflake and dbt performance and cost
• ▹Partner with engineering and business stakeholders to translate requirements into durable data assets
• ▹Contribute to the team's version control, code review and documentation practices (GitHub-based)

Requirements

• ▹3+ years of experience in analytics engineering, data engineering or a similar production data role
• ▹Strong SQL skills and hands-on dbt experience (modeling, testing, documentation)
• ▹Modern development workflow experience: Git and pull-request based collaboration (GitHub preferred)
• ▹Experience with cloud data warehouses (Snowflake preferred)
• ▹Strong sense of ownership, comfortable in ambiguous, fast-moving environments

Nice to have

• ▹Finance/accounting data familiarity (close concepts, reconciliations, ledger modeling)
• ▹Integration/automation platforms (Workato, Fivetran or similar)
• ▹Experience supporting reporting layers and BI tooling
• ▹Working knowledge of Python for data manipulation and automation
• ▹Familiarity with CI pipelines and quality gates
• ▹Interest in applying AI-assisted development responsibly

Soft skills

What we offer

• ▹Full health care coverage for employees and dependents
• ▹Flexible spending wallets for tech, food and lifestyle
• ▹Competitive vacation and holiday schedule
• ▹Employee stock purchase plan (ESPP)
• ▹Contract of employment, learning & development programs, parental benefits

About the company

Affirm is reinventing credit to make it more honest and friendly, giving consumers the flexibility to buy now and pay later without hidden fees or compounding interest. Financial Systems owns the data and reporting foundation for Accounting, building a single source of truth for financial information using dbt and Snowflake.