Staff Software Engineer focused on developing Affirm’s Lakehouse Platform with technologies like Apache Iceberg and Snowflake. Leading technical strategies and collaborative efforts across various teams.
Responsibilities
Influence technical strategy: Define and drive the long-term technical roadmap for Affirm’s Lakehouse Platform across Apache Iceberg, Spark, Snowflake, and cloud-native storage, balancing scalability, reliability, governance, performance, and cost.
Design and develop: Architect and implement platform capabilities that make analytical data secure, trustworthy, discoverable, and easy to use across Affirm’s engineering, analytics, machine learning, and business teams.
Strengthen governance and access controls: Design and operate secure, auditable data access capabilities across Snowflake and the lakehouse platform, including RBAC, dynamic data masking, cataloging, lineage, classification, and privacy policy enforcement.
Improve analytics engineering foundations: Partner with Analytics Engineering to evolve data modeling, transformation pipelines, testing frameworks, documentation standards, and data quality practices that enable trustworthy self-service analytics.
Operate at scale: Establish best practices for lakehouse operations, including schema evolution, table maintenance, partitioning, compaction, observability, incident response, production support, and readiness for on-call operations.
Optimize performance and cost: Identify and execute improvements across analytical compute and storage, including Snowflake warehouse tuning, query optimization, storage layout, lifecycle management, cost attribution, and operational efficiency.
Collaborate cross-functionally: Partner with Infrastructure, Lakehouse Analytics, Analytics Engineering, Machine Learning, BI, Product Engineering, and SRE to translate stakeholder needs into durable platform architecture.
Innovate: Stay ahead of industry trends in lakehouse architecture, open table formats, analytical compute engines, data governance, privacy engineering, semantic layers, agentic data tools, and AI-ready data infrastructure.
Build teams: Mentor engineers, raise technical quality, and foster an inclusive culture of design rigor, operational excellence, and continuous learning.
Requirements
8+ years of experience in software engineering, data infrastructure, or data platform engineering, with 2+ years of technical leadership responsibilities.
Hands-on experience leading teams to build critical data infrastructure.
Hands-on experience with Snowflake or comparable analytical data warehouses, including access control, data masking, query optimization, and cost management.
Strong experience with Apache Iceberg, Spark, and cloud-native data lake architectures.
Experience with dbt or equivalent transformation frameworks, including data modeling, testing, documentation, and CI/CD practices.
Proficiency in Python, SQL, or JVM-based languages, with a strong emphasis on clean, maintainable, production-quality systems.
Familiarity with Terraform or similar automation tools for managing data infrastructure.
This position requires equivalent practical experience or a Bachelor’s degree in a related field.
Benefits
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
Marketing Data Analytics Engineer building Salesforce, Marketo, and warehouse pipelines for PointClickCare’s healthcare analytics platform. Automating campaign reporting and supporting marketing - sourced pipeline insights.
Senior Analytics Engineer designing Lime’s finance - grade data warehouse and semantic layer. Ensuring governed, audit - ready reporting for the global shared micromobility business.
Analytics Engineer building Snowflake and dbt data platforms for Tucows’ Internet businesses. Applying AI, SQL, Looker, and Python to drive data - informed decisions.
Senior Analytics Engineer designing financial, GTM, and product data models for Lightspeed’s cloud commerce platform. Owning pipelines, documentation, and analytics foundations used across the business.
Senior Analytics Engineer building scalable data pipelines and AI - native analytics foundations at Mercury, a fintech company. Supporting agentic tooling, self - service analytics, governance, and data products.
Senior Business Systems Analyst modernizing Boeing Canada’s defence sustainment systems and cloud data platforms. Translating mission needs into requirements, analytics, integrations, and reporting solutions.
Senior Analytics Engineer building GTM pipelines, metrics, dashboards, and AI data tools. Supporting Motive’s platform for safer, more productive physical operations.
Data Analytics Engineer building trusted SQL data systems for Toptal, a global talent network. Owning transformation, governance, warehousing, and AI - enabled analytics foundations.
Analytics Engineer building dbt models, AI - ready datasets, and Tableau reporting for Movable Ink’s content personalization platform. Translating stakeholder needs into trusted metrics and business intelligence.