Senior Staff Software Engineer, Backend (Data and Storage Services)

Senior Staff Software Engineer, Backend (Data and Storage Services) Affirm

• 3.7 San Francisco, CA Job Details $232,000
• $310,000 a year 16 hours ago Benefits Employee stock purchase plan Health insurance Dental insurance Vision insurance Qualifications Data model design Data transformation pipeline development Data lake Continuous Delivery (CD) implementation Cloud data warehouses Data modeling projects Infrastructure as Code (IaC) Spark Research SQL Team development Spark implementation Access control implementation Mentoring Software testing S3 Cloud Architecture Design (Architecture design skills) Open source contribution Cross-functional collaboration Team motivation (leadership skill) Python Amazon EKS Cross-functional communication Full Job Description Affirm is reinventing credit to make it more honest and friendly, giving consumers the flexibility to buy now and pay later without any hidden fees or compounding interest.

Affirm's engineering team is building a large-scale, highly-available, and global infrastructure that is shared across multiple financial products. Ensuring that our infrastructure is accessible to all engineers is critical to the success of the business. We pride ourselves on our culture across engineering of engaging in thorough technical design review, operational excellence, and capable incident response and analysis. 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. The Data Services organization encompasses the Lake Analytics Platform and Analytics Engineering teams. Our platform powers Affirm's analytical data ecosystem — from the lakehouse and query infrastructure that stores and serves data at scale, to the transformation and modeling layers that make data trustworthy and accessible to the business. We are responsible for Snowflake, FiveTran, Atlan, MonteCarlo, dbt, data governance, privacy controls, and the tooling that enables self-service analytics with an AI focused mindset across the company. What you'll do As a member of the Data and Storage Services organization, you will 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. What we look for

Architect and Implement:

Design, develop, and maintain core components of Affirm's lakehouse analytics platform, with a focus on scalability, governance, and reliability.

Snowflake Expertise:

Leverage deep knowledge of Snowflake to architect RBAC models, dynamic data masking, warehouse optimization, and multi-cluster compute strategies. Should possess deep understanding of Snowflake internals including query profiling, micro-partitioning, clustering, materialized views, and cost attribution.

Analytics Engineering:

Drive the technical strategy for data modeling and transformation using dbt, including testing frameworks, documentation standards, 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.

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.

Problem Solving:

Exceptional problem-solving and analytical skills, with the ability to identify and resolve complex technical challenges and establish long-lasting solutions and processes.

Programming Skills:

Proficiency in Python and SQL, with a strong emphasis on clean, maintainable code. Experience with Kotlin or Go is a plus.

Leadership:

Demonstrated leadership and mentorship skills, with the ability to inspire and guide others. You can also work cross-functionally addressing technical challenges and influencing roadmaps outside your direct area of ownership.

Innovation:

You drive innovation in the platforms you build and operate, and have experience contributing to open-source projects. You are passionate about engaging with the data engineering community. Infrastructure as Code (IaC): Familiarity with automation tools like Terraform for managing data infrastructure.

Communication:

Excellent communication and interpersonal skills, with the ability to clearly articulate technical ideas to both technical and non-technical audiences. This position requires either equivalent practical experience or a Bachelor's degree in a related field. Pay Grade

• R Equity Grade
• 15 Employees new to Affirm typically come in at the start of the pay range.

Affirm focuses on providing a simple and transparent pay structure which is based on a variety of factors, including location, experience and job-related skills. Base pay is part of a total compensation package that may include equity rewards, monthly stipends for health, wellness and tech spending, and benefits (including 100% subsidized medical coverage, dental and vision for you and your dependents.) USA base pay range (CA, WA, NY, NJ, CT) per year: $260,000

• 310,000 USA base pay range (all other U.S. states) per year: $232,000
• 282,000 #LI-Remote Affirm is proud to be a remote-first company!

The majority of our roles are remote and you can work almost anywhere within the country of employment. Affirmers in proximal roles have the flexibility to work remotely, but will occasionally be required to work out of their assigned Affirm office. A limited number of roles remain office-based due to the nature of their job responsibilities. We're extremely proud to offer competitive benefits that are anchored to our core value of people come first. Some key highlights of our benefits package include: Health care coverage

• Affirm covers all premiums for all levels of coverage for you and your dependents Flexible Spending Wallets
• generous stipends for spending on Technology, Food, various Lifestyle needs, and family forming expenses Time off
• competitive vacation and holiday schedules allowing you to take time off to rest and recharge ESPP
• An employee stock purchase plan enabling you to buy shares of Affirm at a discount We believe It's On Us to provide an inclusive interview experience for all, including people with disabilities.

We are happy to provide reasonable accommodations to candidates in need of individualized support during the hiring process. [For U.S. positions that could be performed in Los Angeles or San Francisco] Pursuant to the San Francisco Fair Chance Ordinance and Los Angeles Fair Chance Initiative for Hiring Ordinance, Affirm will consider for employment qualified applicants with arrest and conviction records. By clicking "Submit Application," you acknowledge that you have read Affirm's Global Candidate Privacy Notice and hereby freely and unambiguously give informed consent to the collection, processing, use, and storage of your personal information as described therein.