As a Senior Staff Software Engineer on Affirm's Data and Storage Services team, you will architect and evolve the company’s lakehouse analytics platform, focusing on Snowflake, Apache Iceberg, and Spark to ensure scalable and high-performance analytical infrastructure. Your responsibilities include designing robust RBAC models and dynamic data masking policies in Snowflake, leading technical practices for data modeling and transformation with dbt, and driving cost optimization strategies across Affirm's analytical compute and storage footprint. You will collaborate closely with product engineering teams to understand their data needs and provide guidance on best practices while mentoring engineers and fostering a culture of technical excellence. This role requires extensive experience in software or data engineering, deep expertise in Snowflake, proficiency in Python and SQL, and familiarity with tools like Terraform for infrastructure management.
Architect and evolve Affirm's lakehouse analytics platform using Snowflake, Apache Iceberg, and Spark.
Design and implement robust RBAC and dynamic data masking policies in Snowflake to ensure secure data access.
Lead technical direction for analytics engineering practices, including dbt-based transformation pipelines and data quality frameworks.
Drive cost optimization strategies across Affirm's analytical compute and storage footprint, focusing on efficient resource management.
Establish best practices for lakehouse operations at scale, addressing schema evolution, partitioning strategies, and observability.
What we're looking for
10+ years of experience in software or data engineering with proven delivery of complex data platform solutions.
Deep expertise (6+ years) in Snowflake, including RBAC design, query optimization, and cost management.
Strong experience with Apache Iceberg, Spark, and cloud-native data lake architectures on AWS.
Experience with dbt or equivalent transformation frameworks for data modeling, testing, and CI/CD pipelines.
Exceptional problem-solving skills to resolve complex technical challenges in large-scale systems.
Proficiency in Python and SQL, with additional experience in Kotlin or Go preferred.
Leadership and mentorship abilities, including cross-functional collaboration and influencing roadmaps.
Market check
Salary context
This
$260,000–$310,000
range sits above
100%
of similar postings on FindRole.
Peer median band
$132,000–$234,000
Median floor and ceiling across peers.
Typical midpoint (25–75%)
$165,000–$214,500
Middle half of comparable postings.
Based on 240 comparable postings.*
* 240 is the maximum number of comparable postings sampled.
Employer
About Affirm
Affirm is a buy-now, pay-later (BNPL) financial technology company that offers point-of-sale installment loans to consumers, allowing them to split purchases into fixed monthly payments with transparent terms. Industry: Financial Technology & Consumer Lending
Affirm currently has
57 open roles
on FindRole.
Listed pay typically runs
$190,000–$240,000
across 56 roles with salary data.