Staff Software Engineer, Backend (Lake Analytics Platform)
New
A
AffirmFinancial Technology
Remote CanadaFull-TimeStaff
SalaryCAN base pay range per year: 181,000 - 241,000
Apply NowOpens the employer's application page
Job Details
- Experience
- 8+ years of experience in software engineering, data infrastructure, or data platform engineering, with 2+ years of technical leadership responsibilities.
- Required Skills
- PythonSQLJVMSnowflakeSparkTerraformdbt
Requirements
- 8+ years of experience in software engineering, data infrastructure, or data platform engineering.
- 2+ years of technical leadership responsibilities.
- Proven experience architecting and operating large-scale OLAP systems or lakehouse platforms.
- Hands-on expertise with Apache Iceberg, Spark, and cloud-native data lake architectures.
- Expert-level experience with Snowflake, including RBAC, dynamic data masking, warehouse optimization, and query profiling.
- Proficiency in Python, SQL, or JVM-based languages.
- Experience with dbt or equivalent data transformation frameworks.
- Familiarity with Infrastructure as Code tools such as Terraform.
- Strong understanding of data modeling, schema evolution, and partition management.
- Bachelor’s degree in a related field or equivalent practical experience.
Responsibilities
- Define and drive the long-term technical roadmap for Affirm’s Lakehouse Platform across Apache Iceberg, Spark, Snowflake, and cloud-native storage.
- Architect and implement platform capabilities that make analytical data secure, trustworthy, discoverable, and easy to use.
- Design and operate secure, auditable data access capabilities across Snowflake and the lakehouse platform, including RBAC, dynamic data masking, and cataloging.
- Partner with Analytics Engineering to evolve data modeling, transformation pipelines, testing frameworks, and data quality practices.
- Establish best practices for lakehouse operations, including schema evolution, table maintenance, compaction, and production support.
- Identify and execute improvements for Snowflake warehouse tuning, query optimization, and cost management.
- Mentor engineers, raise technical quality, and foster an inclusive culture of design rigor and operational excellence.
View Full Description & ApplyYou'll be redirected to the employer's site
