Top Benefits
About the 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
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
About Affirm
At Affirm, we’re using today’s technology to bring significant disruptive innovation to the financial industry. We focus on improving the lives of consumers by delivering simple, honest and transparent financial products.
We have roles across a variety of teams, including engineering, product, finance, operations, revenue, marketing, people and more.
A note to applicants: Fake job and recruiting scams are on the rise. Affirm will never ask you to pay any upfront fees or send you any checks to purchase equipment during any part of the recruiting process. Affirm only uses legitimate company email address domains (either “@affirm.com” or "@us.greenhouse-mail.io”) to communicate with candidates via email.
We have roles across a variety of teams, including engineering, product, finance, operations, revenue, marketing, people and more.
Affirm is also proud to be a remote-first company! Attracting great people starts by finding talent in different places. That's why we built remote work into the DNA of how we do business—but if an office space is more your style, we have offices in Chicago, New York City, Pittsburgh, San Francisco, and Toronto.
Not to mention we have comprehensive and award-winning benefits that were made for you.
Interested in learning more? Check out our careers page and apply today!
Visit affirm.com/careers for more information.
A note to applicants: Fake job and recruiting scams are on the rise. Affirm will never ask you to pay any upfront fees or send you any checks to purchase equipment during any part of the recruiting process. Affirm only uses legitimate company email address domains (either “@affirm.com” or "@us.greenhouse-mail.io”) to communicate with candidates via email.
Top Benefits
About the 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
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
About Affirm
At Affirm, we’re using today’s technology to bring significant disruptive innovation to the financial industry. We focus on improving the lives of consumers by delivering simple, honest and transparent financial products.
We have roles across a variety of teams, including engineering, product, finance, operations, revenue, marketing, people and more.
A note to applicants: Fake job and recruiting scams are on the rise. Affirm will never ask you to pay any upfront fees or send you any checks to purchase equipment during any part of the recruiting process. Affirm only uses legitimate company email address domains (either “@affirm.com” or "@us.greenhouse-mail.io”) to communicate with candidates via email.
We have roles across a variety of teams, including engineering, product, finance, operations, revenue, marketing, people and more.
Affirm is also proud to be a remote-first company! Attracting great people starts by finding talent in different places. That's why we built remote work into the DNA of how we do business—but if an office space is more your style, we have offices in Chicago, New York City, Pittsburgh, San Francisco, and Toronto.
Not to mention we have comprehensive and award-winning benefits that were made for you.
Interested in learning more? Check out our careers page and apply today!
Visit affirm.com/careers for more information.
A note to applicants: Fake job and recruiting scams are on the rise. Affirm will never ask you to pay any upfront fees or send you any checks to purchase equipment during any part of the recruiting process. Affirm only uses legitimate company email address domains (either “@affirm.com” or "@us.greenhouse-mail.io”) to communicate with candidates via email.