Senior Staff Software Engineer, Backend (Data and Storage Services)
About the role
The Data and Storage Services team is responsible for handling all of Affirm's Data (OLAP and OLTP) requirements and encompasses the entire range from critical online checkout databases all the way to our Batch Orchestration, Streaming Infrastructure, Event Driven Frameworks, BI and analytics tools and systems. Our mission is to provide trustworthy, intuitive, and cost-efficient solutions for Affirmers to secure, store, analyze, and transform data at exceptional scale.
Responsibilities
Collaborate with other teams — including Product, Infrastructure, Lakehouse Infra, Lakehouse Analytics and Analytics Engineering — to architect and evolve Affirm's lakehouse analytics platform, driving strategy around Snowflake, Apache Iceberg, and Spark to deliver scalable, high-performance analytical infrastructure.
Design and implement robust Role-Based Access Control (RBAC) and dynamic data masking policies in Snowflake, ensuring data access is secure, compliant, and auditable across the organization.
Lead the technical direction of analytics engineering practices, including data modeling, transformation pipelines (dbt), and data quality frameworks that enable trustworthy, self-service analytics.
Drive data governance and privacy engineering initiatives, leveraging tools like Atlan to manage data cataloging, lineage, classification, and policy enforcement.
Identify and execute cost optimization strategies across Affirm's analytical compute and storage footprint, including Snowflake warehouse tuning, query optimization, and efficient data lifecycle management.
Collaborate with product engineering, data science, and business intelligence teams to understand their data needs and provide continuous guidance on design, architecture, and best practices.
Establish and champion best practices for lakehouse operations at scale, including schema evolution, table maintenance, partitioning strategies, and observability.
Stay ahead of industry trends in analytical data platforms, data governance, and privacy technologies, and identify opportunities to innovate and improve our data offerings.
Mentor engineers across the Lake Analytics Platform and Analytics Engineering teams, providing guidance on emerging technologies, development practices, and fostering a culture of technical excellence.
Participate in an on-call rotation and collaborate with other teams such as SRE to resolve production issues.
Qualifications
Experience: 10+ years of experience in software engineering or data engineering, with a proven track record of delivering complex data platform solutions that improve accessibility, performance, and governance of analytics infrastructure.
Snowflake Expertise: 6+ years of hands-on experience with Snowflake or comparable analytical data warehouses, including RBAC design, data masking, query optimization, and cost management.
Lakehouse & Big Data: Strong experience with Apache Iceberg, Spark, and cloud-native data lake architectures on AWS (S3, EKS).
Analytics Engineering: Experience with dbt or equivalent transformation frameworks, including data modeling best practices, testing, and CI/CD for data pipelines.
Data Governance & Privacy: Design and operate data governance frameworks using tools like Atlan, including data cataloging, lineage tracking, classification, and automated privacy policy enforcement.
Lakehouse Architecture: Tackle the challenges of large-scale analytical data systems, including Apache Iceberg table management, schema evolution, storage optimization, and integration with Spark and Snowflake.
Collaboration: Work closely with product managers, software engineers and analysts to translate business requirements into technical solutions, and with fellow engineers to deliver high-quality data infrastructure.
Mentorship: Guide and mentor junior and senior engineers, sharing your expertise and fostering a culture of technical excellence.
Innovation: Stay ahead of the curve by researching and experimenting with emerging technologies and trends in the lakehouse, data governance, and analytics engineering space.