Analytics Lead, Full Stack

Affirm; Remote; USD 160,000 - 210,000; Full time

Job summary

A leading financial technology company is seeking an experienced Analytics Lead to join their People Analytics team. This role involves designing scalable data architecture, developing ETL/ELT pipelines, and ensuring data quality across multiple HR data sources. The ideal candidate will have 5+ years of experience in dbt, SQL, and Python, and possess strong analytical skills. The role offers competitive compensation with flexible work options, including a remote-first work environment.

Benefits

100% subsidized medical coverage

Equity rewards

Flex spending allowances

Competitive vacation and holiday schedules

Qualifications

• 5+ years of experience with dbt, SQL and Python.
• Ability to design and build efficient data models in dbt.
• Experience with cloud data warehouses like Snowflake.

Responsibilities

• Design and deliver database models and reporting solutions.
• Develop and maintain ETL/ELT pipelines across HR data sources.
• Ensure data quality and integrity across all data assets.

Skills

dbt (Data Build Tool)

SQL

Python

Data Modeling

ETL Processes

Data Quality Assurance

Tools

Snowflake

Sigma

Fivetran

Airflow

Job description

Overview

Affirm is reinventing credit to make it more honest and friendly, giving consumers the flexibility to buy now and pay later without any hidden fees or compounding interest. We are seeking a highly skilled and action-oriented Analytics Lead to join the People Analytics organization and drive the next evolution of our data infrastructure, modeling, and reporting capabilities. The People Analytics team builds and maintains the data foundations that power key talent programs across Affirm, including Talent Acquisition, Total Rewards, Feedback & Development, and core employee data. The team drives the design, modeling, and reporting of high-quality, trusted people data, partnering closely with the business to deliver insights and data products that enable informed decisions. In this role, you will serve as the technical lead for our people data ecosystem—designing scalable architecture, setting engineering standards, and partnering across the business to deliver high-value, trusted data products. The ideal candidate brings strong analytical engineering expertise, a strategic mindset, an innate sense of curiosity, and the ability to lead through influence. You will play a key role in shaping our data roadmap, introducing modern tooling and automation, uplifting engineering best practices, and mentoring other analytics engineers. Join our team and help build the next generation of People Analytics at Affirm.

What You'll Do

• Design and deliver relational and non-relational database models, data pipelines, reporting, and visualization solutions while supporting all phases of the analytics development life cycle (ADLC), including requirements gathering, design, development, testing, and deployment.
• Develop, maintain, and scale robust ETL/ELT pipelines across HR data sources (e.g., Workday, Greenhouse Recruiting, internal tools such as Arbor), ensuring reliability, performance, and extensibility.
• Architect and implement scalable data models optimized for analytical querying and long-term maintainability.
• Ensure data quality, integrity, and reliability across all data assets, introducing automation and best practices for monitoring and validation.
• Collaborate with People Analytics stakeholders to translate requirements into sound technical solutions and influence longer-term data architecture decisions.
• Manage and optimize cloud data warehouse infrastructure (e.g., Snowflake), including performance tuning, cost management, and secure access patterns.
• Leverage AI and LLMs to automate data quality checks, enhance metadata management, and extract insights from unstructured HR data.
• Stay current on technology best practices and advocate for engineering excellence across the People Analytics team.
• Own and manage data governance, security, privacy, and retention standards across all People Analytics systems.

What We Look For

• 5+ years and expertise with dbt (Data Build Tool), SQL and Python required; including:
  • Experience writing clean, computationally efficient code involving ETL processes and data manipulation via dbt, SQL, and Python.
  • Demonstrated ability to design and build efficient, analytics-ready data models in dbt, transforming raw or unstructured data into well-defined marts.
  • Comfort with production level IDEs (e.g., Cursor, Visual Studio) and Version Control (e.g., git, specifically GitHub).
  • Experience using standard Python analysis packages (e.g., Pandas, NumPy).
• Experience with the following required:
• Snowflake or other cloud data warehouse.
• Sigma or other modern BI platform.
• Fivetran or similar integration platform for integrating structured, unstructured, or unclear data formats.
• Airflow or other orchestration platform.
• Experience with the following preferred:
• Leveraging LLMs for data transformation or analysis; MLOps.
• Data lakes and/or Iceberg table format.
• Custom data application development using Python or similar language (i.e. Streamlit dashboards, Slackbots).
• Additional Qualifications:
• Strong sense of ownership, intellectual curiosity, and the ability to think creatively and critically in a dynamic, fast-paced, and ambiguous environment.
• Demonstrated ability to provide technical leadership, influence cross-functional partners, and mentor other team members.
• Excellent communication skills and comfort translating technical topics for non-technical audiences.

Benefits

Pay Grade - M

Equity Grade - 8

Employees new to Affirm typically come in at the start of the pay range. Affirm focuses on providing a simple and transparent pay structure which is based on a variety of factors, including location, experience and job-related skills.

Base pay is part of a total compensation package that may include equity rewards, monthly stipends for health, wellness and tech spending, and benefits (including 100% subsidized medical coverage, dental and vision for you and your dependents.)

USA base pay range (CA, WA, NY, NJ, CT) per year: $180,000 - $230,000

USA base pay range (all other U.S. states) per year: $160,000 - $210,000

Please note that visa sponsorship is not available for this position.

Affirm is proud to be a remote-first company! The majority of our roles are remote and you can work almost anywhere within the country of employment. Affirmers in proximal roles have the flexibility to work remotely, but will occasionally be required to work out of their assigned Affirm office. A limited number of roles remain office-based due to the nature of their job responsibilities.

Note: Benefits section continues below.

Additional Benefits Information

We’re extremely proud to offer competitive benefits that are anchored to our core value of people come first. Some key highlights of our benefits package include:

• 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

We believe It’s On Us to provide an inclusive interview experience for all, including people with disabilities. We are happy to provide reasonable accommodations to candidates in need of individualized support during the hiring process.

[For U.S. positions that could be performed in Los Angeles or San Francisco] Pursuant to the San Francisco Fair Chance Ordinance and Los Angeles Fair Chance Initiative for Hiring Ordinance, Affirm will consider for employment qualified applicants with arrest and conviction records.

By clicking "Submit Application," you acknowledge that you have read Affirm's Global Candidate Privacy Notice and hereby freely and unambiguously give informed consent to the collection, processing, use, and storage of your personal information as described therein.