Analytics Lead, Full Stack

About This Role

Lead the evolution of Affirm's People Analytics data infrastructure, modeling, and reporting by serving as the technical lead for the people data ecosystem, designing scalable architecture, and setting engineering standards.

Responsibilities

• Design and deliver relational and non-relational database models, data pipelines, reporting, and visualization solutions.
• Develop, maintain, and scale robust ETL/ELT pipelines across HR data sources like Workday and Greenhouse Recruiting.
• Architect and implement scalable data models optimized for analytical querying and long-term maintainability.
• Ensure data quality, integrity, and reliability across all data assets through automation and best practices.
• Collaborate with People Analytics stakeholders to translate requirements into sound technical solutions and influence data architecture decisions.
• Manage and optimize cloud data warehouse infrastructure (e.g., Snowflake) for performance, cost, and security.
• 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.
• Own and manage data governance, security, privacy, and retention standards across People Analytics systems.

Requirements

• 5+ years of experience with dbt (Data Build Tool), SQL, and Python
• Experience writing clean, computationally efficient code involving ETL processes and data manipulation
• Demonstrated ability to design and build efficient, analytics-ready data models in dbt
• Comfort with production level IDEs (e.g., Cursor, Visual Studio)
• Experience with Version Control (e.g., git, GitHub)
• Experience using standard Python analysis packages (e.g., Pandas, NumPy)
• Experience with Snowflake or other cloud data warehouse
• Experience with Sigma or other modern BI platform
• Experience with Fivetran or similar integration platform
• Experience with Airflow or other orchestration platform

Qualifications

• 5+ years and expertise with dbt (Data Build Tool), SQL and Python

Nice to Have

• Experience 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)

Skills

* Required skills

Benefits