Analytics Engineer, Affirm
People Data
CA$109-159k
+ ESPP
POS installment loans
Be an early applicant
POS installment loans
1001+ employees
Be an early applicant
CA$109-159k
+ ESPP
1001+ employees
Company mission
To deliver honest and transparent financial products that improve users' lives.
Role
Who you are
- 3+ 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
- Building efficient and concise data models in dbt to transform unstructured source data into analytics-ready denormalized 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)
- Strong sense of ownership, intellectual curiosity and an ability to think creatively and critically and thrive in a fast-paced, dynamic, and often ambiguous work environment
What the job involves
- We are in search of an action-oriented and analytically inclined Analytics Engineer to join the People Analytics organization and significantly expand our data integration, transformation, and reporting capabilities
- People Analytics is responsible for the infrastructure, business logic, and deliverables for data across the People space; including talent acquisition, total rewards, feedback & development, and employee data
- This position will be instrumental in architecting and building robust data infrastructure and tools, significantly enhancing our team’s ability to deliver high-value data products across the business
- This role is primarily suited for candidates with strong data skills, particularly with experience in the design and creation of ETLs and SQL-based relational database structures
- The ideal candidate will not only have superb technical skills but also strong interpersonal skills and the ability to take a leading role in driving our data and reporting capabilities to the next level
- You'll have the opportunity to make a significant impact by building robust data infrastructure and tools that empower our People Analytics organization and cross-functional partners across the business
- Join our team and be part of Affirm's mission to reinvent credit!
- Design and deliver relational and non-relational database models, data pipelines, reporting and visualization solutions by supporting all phases of the analytics development life cycle (ADLC), including requirements gathering, design, development, testing and deployment
- Develop and maintain robust ETL/ELT pipelines for various HR data sources (e.g., Workday, Greenhouse Recruiting)
- Architect and implement scalable data models optimized for performance and analytical querying
- Ensure data quality, integrity, and reliability across all data assets
- Collaborate with People Analytics team members to understand data requirements and translate them into technical solutions
- Manage and optimize cloud data warehouse infrastructure (e.g., Snowflake)
- Leverage AI and LLMs to, for example, automate data quality checks, enhance metadata management, and extract deeper insights from unstructured HR data
- Be on the lookout for technology best practices and advocate for them
- Be an advocate for data governance, security, privacy, quality and retention
Our take
Affirm offers point-of-sale loans to consumers, working with merchants like Shopify, KAYAK, and Walmart. Buy now, pay later transactions have grown in popularity in recent years, and this business is tapping into the market with a totally different approach to credit - by delivering the Affirm card, the first US debit card with the option to pay-over-time.
Boasting over 21M consumers and 337,000+ merchants, the company offers flexible payback options, ranging from 3 to 36 months. The interest rates run between 0% and 30%, so, while they are not necessarily the cheapest option, Affirm prides itself on having no fees for late payments, no hidden charges, and total transparency about what people will pay before they take out a loan.
Affirm collects payments from the customers and pays the merchants directly, shouldering the risk itself. The company has boosted its market share, expanding its availability beyond the US to include most of Canada, and continues to launch new features and create new partnerships towards bettering its offering.
Kirsty
Company Specialist at Welcome to the Jungle
Insights
-11% employee growth in 12 months
Company
Funding (last 2 of 5 rounds)
Sep 2020
$500m
SERIES G
Apr 2019
$300m
SERIES F
Total funding: $1.1bn
Company benefits
- Compensation: We have a simple, flexible, and transparent remote-first compensation structure so you can make the best decisions for yourself and your family
- Spending Wallets: Access tech, food, lifestyle, and family planning wallets for your expenses
- Supportive Communities: Get involved with our employee resource groups and community groups
- Remote-first Workforce: If your role is remote, you can set up shop anywhere in your home country
- Generous Time Off: Take the time you need when life happens
- Health Benefits: Get a plan that fits your needs
- Mental Healthcare: Take care of your mind with great mental health programs
- Parental Leave: Birth and non-birth parents get 18 weeks’ paid leave. Plus, a 4-week return-to-work transition program, at full base pay
- Away Days: We offer 20 company-wide paid days off—which help our teams collectively pause to recharge
- Learning & Development: Engage in exciting learning programs to level up your growth
Company HQ
Chinatown, San Francisco, CA
Leadership
Max Levchin
(Co-Founder & CEO)Has founded/co-founded numerous companies, holding various executive positions at each, including Paypal, Slide, Glow, HVF Labs, and SciFi VC. Also worked at large brands including Google, Yelp, Yahoo, and Evernote.
Share this job
View 124 more jobs at Affirm